I'm trying to setup connection pooling in Tomcat 4.1.24 to use Oracle's JDBC libraries. I've defined (in my web.xml) a <Resource> and <ResourceParams> sections as follows:
<Resource name="jdbc/Db"
auth="Container"
type="oracle.jdbc.pool.OracleConnectionCacheImpl"/>
<ResourceParams name="jdbc/Db">
<parameter><name>factory</name>
<value>oracle.jdbc.pool.OracleDataSourceFactory</value></parameter>
<!--
<parameter><name>url</name>
<value>jdbc:oracle:thin:@200.65.6.188:1521:tiggs9i</value></parameter>
-->
<parameter><name>driverType</name>
<value>thin</value></parameter>
<parameter><name>serverName</name>
<value>200.65.6.188</value></parameter>
<parameter><name>networkProtocol</name>
<value>tcp</value></parameter>
<parameter><name>databaseName</name>
<value>tiggs9i</value></parameter>
<parameter><name>portNunber</name>
<value>1521</value></parameter>
<parameter><name>user</name>
<value>cmluser</value></parameter>
<parameter><name>password</name>
<value>cml</value></parameter>
<parameter><name>maxLimit</name>
<value>20</value></parameter>
<parameter><name>minLimit</name>
<value>10</value></parameter>
<parameter><name>cacheScheme</name>
<value>1</value></parameter>
</ResourceParams>
As you can see, I've commented out the URL setting as that wasn't working and replaced it with the driverType through portNumber settings. It still doesn't work. When I do a lookup() on the java:comp/env context for the DataSource I get the following:
NamingException: User credentials doesn't match the existing ones
I don't know what that means as I know that the username and password given above are valid.
I also can't find any useful documentation for OracleDataSourceFactory. Any idea where I should look. It isn't in Oracle9i JDBC Developer's Guide and Reference and a Google search gives nothing useful yet it is a class provided in the classes12.jar JDBC library.
Any help is appreciated.
Kevin.