I've read a lot of articles and guides in
JDBC connection pooling, and all of them involve the use of JNDI lookup to retrieve a DataSource.
I'm wondering if it is
required to use JDNI in order to create a pooled connection? Or I can simply instantiate the driver class as follows:
The reason why I'm looking into alternatives that doesn't involve JNDI is due to a bug between WAS and the Oracle driver. I am unable to register OracleConnectionPoolDataSource into the WAS JNDI context correcty (the datasource got registered into the context but returned as "com.ibm.ejs.cm.JDBC1PhaseRF", a class that cannot be casted into sql.javax.DataSource).
[ August 12, 2002: Message edited by: Felix Kan ]