I'm searching for an example server.xml that uses the Oracle connection pool mechanism
from oracle. (As opposed to poolman, etc...)
Any help would be greatly appreciated, I cannot seem to get the server.xml correctly
configured with the Oracle connection pool classes.
What I've tried -
<Resource name="jdbc/timesheet" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/timesheet">
<parameter>
<parameter><name>user</name><value>my_username</value></parameter>
<parameter><name>password</name><value>my_password</value></parameter>
<name>factory</name>
<value>oracle.jdbc.pool.OracleDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.pool.OracleDataSource</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:oracle:thin:@MYHOST:1521:ORCL</value>
</parameter>
</ResourceParams>
When I try and get a connection from the pool, it returns null. If I configure it to
not use a connection pool, the code works, so I know the problem is with the oracle
pool definition.
Thanks,
Ryan