|
| |
MySQL Connector/J JDBC configuration
<database>
<jndi-name>jdbc/mysql</jndi-name>
<driver>
<type>com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource</type>
<url>jdbc:mysql://localhost:3306/dbname</url>
<user>username</user>
<password>password</password>
</driver>
...
</database>
|
TODO
Oracle JDBC configuration
<database>
<jndi-name>jdbc/oracle</jndi-name>
<driver>
<type>oracle.jdbc.pool.OracleConnectionPoolDataSource</type>
<url>jdbc:oracle:thin:@localhost:1521:dbname</url>
<user>username</user>
<password>password</password>
</driver>
...
</database>
|
Note, the XADataSource is only needed for distributed transactions.
If your transactions only include the single data source, the
OracleConnectionPoolDataSource will be more efficient.
Oracle XADataSource JDBC configuration
<database>
<jndi-name>jdbc/oracle-xa</jndi-name>
<xa>true</xa>
<driver>
<type>oracle.jdbc.xa.client.OracleXADataSource</type>
<url>jdbc:oracle:thin:@localhost:1521:dbname</url>
<user>username</user>
<password>password</password>
</driver>
...
</database>
|
Informix JDBC configuration
<database>
<jndi-name>jdbc/informix</jndi-name>
<driver>
<type>com.informix.jdbcx.IfxConnectionPoolDataSource</type>
<url>jdbc:informix-sqli://123.45.67.89:1533/dbname</url>
<init-param param-name="INFORMIXSERVER" param-value="myserver"/>
<user>username</user>
<password>password</password>
</driver>
...
</database>
|
Informix XADataSource JDBC configuration
<database>
<jndi-name>jdbc/informix-xa</jndi-name>
<xa>true</xa>
<driver type="com.informix.jdbcx.IfxXADataSource">
<url>jdbc:informix-sqli://123.45.67.89:1533/dbname</url>
<init-param param-name="INFORMIXSERVER" param-value="myserver"/>
<user>username</user>
<password>password</password>
</driver>
...
</database>
|
<database>
<jndi-name>jdbc/sqlserver</jndi-name>
<driver type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource">
<serverName>csdevsqla01.office.foo</serverName>
<databaseName>Reports</databaseName>
<user>XXX</user>
<password>YYY</password>
<selectMethod>cursor</selectMethod>
</driver>
<xa>true</xa>
</database>
|
Contributions welcome!
Contributions welcome!
<database>
<jndi-name>jdbc/name</jndi-name>
<driver>
<type>org.postgresql.Driver</type>
<url>jdbc:postgresql://127.0.0.1:5432/dbname</url>
<user>username</user>
<password>password</password>
</driver>
...
</database>
|
"hsqldb is a relational database engine written in Java. It
offers a small (less than 160k), fast database engine which
offers both in memory and disk based tables."
Contributions welcome!
Copyright © 1998-2005 Caucho Technology, Inc. All rights reserved.
Resin® is a registered trademark,
and HardCoretm and Quercustm are trademarks of Caucho Technology, Inc. | |
|