Database Pooling

Connecting to Other Databases

Given all the configuration information we've presented in the last few sections, allowing an application to access databases besides MySQL using JNDI should be a snap. Here are the configurations for some other popular databases:

Oracle

 <database>   <jndi-name>jdbc/oracle</jndi-name>   <driver type="oracle.jdbc.pool. OracleConnectionPoolDataSource">   <url>jdbc:oracle:myschema:@localhost:product</url>   <user>username</user>   <password>password</password>   </driver> </database> 

Postgres

 <database>   <jndi-name>jdbc/mypostgre</jndi-name>   <driver type="org.postgresql.Driver">   <url>jdbc:postgres://localhost/product</url>   <user>username</user>   <password>password</password>   </driver> </database>