I'm trying to get a Oracle Connection Pool , using TomCat.
I have this configuration in server.xml:
<Resource name="JDBC/ORA" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="JDBC/ORA">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@grede:1521:cem4</value>
</parameter>
<parameter>
<name>password</name>
<value>desenv</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.pool.OraclePooledConnection</value>
</parameter>
<parameter>
<name>username</name>
<value>desenv</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
And I put this configuration in web.xml:
<resource-ref>
<description>Oracle DataSource</description>
<res-ref-name>JDBC/ORA</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
My source code is following:
initCtx = new InitialContext();
envCtx = (Context)initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup(jndiName);
conn = ds.getConnection(username,password);
But , the following error message is showed:
Cannot create JDBC driver of class
'oracle.jdbc.pool.OracleConnectionPoolDataSource'
fro connect URL 'jdbc:oracle:thin:@xxxx:1521:xxx'
java.lang.NullPointerException
I've already put the ojdbc14.jar Oracle driver
in the lib diretory of TomCAt.
Can anybody help me
Thanks a lot !