|
<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>
<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.
<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>
<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>
<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>
<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 (c) 1998-2009 Caucho Technology, Inc. All rights reserved.
caucho® ,
resin® and
quercus®
are registered trademarks of Caucho Technology, Inc.
| 
