How to Setup Global JNDI Mapping for Oracle JDBC Connection Pooling with Tomcat

Posted by on August 21, 2008

 Making a User Dependent Connection so we could realize the so called connection proxy.

  •  Setup the server.xml file without the username and password
Setup the server.xml file with an entry without the username and password specified as shown in the example below:
 
<Resource name="jdbc/db2"
auth="Container"
type="oracle.jdbc.pool.OracleDataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
factory="oracle.jdbc.pool.OracleDataSourceFactory"
url="jdbc:oracle:thin:@oracle.microdeveloper.com:1521:db2"
maxActive="20"
maxIdle="10"
maxWait="-1" />
 
  •  Add code to the class to set the username and password
In the class, before the connection is formed, add a call to the datasource to set the username and password. This can be done in one of two ways as shown below:
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup(”java:/comp/env”);
OracleDataSource ds = (OracleDataSource) envContext.lookup(”jdbc/db2″);

   if (envContext == null) throw new Exception(”Error: No Context”);
   if (ds == null) throw new Exception(”Error: No DataSource”);
   if (ds != null){
      ds.setUser(”scott”);
      ds.setPassword(”tiger”);
      conn = ds.getConnection();
   } catch (Exception e) {
  e.printStackTrace();
}
- or -
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup(”java:/comp/env”);
OracleDataSource ds = (OracleDataSource) envContext.lookup(”jdbc/db2″);

   if (envContext == null) throw new Exception(”Error: No Context”);
   if (ds == null) throw new Exception(”Error: No DataSource”);
   if (ds != null){
      conn = ds.getConnection(”scott”,”tiger”);
   } catch (Exception e) {
  e.printStackTrace();
}
We can now supply different user credentials fro each connection
 
This method has been tested on Oracle 8.1.6 through 10.0.1 and Tomcat 5.0.28, 5.5.4, 5.5.7, and 5.5.9.
Uncategorized

Comments are closed.