Hi.
I've got a problem: I tried to setup oracle connection pooling in my
tomcat configuration, but didn't succeed. I checked Tomcat docs and Oracle
docs to produce this, but nothing helped :(
Does anyone have in production such a configuration, using
Oracle-implemented connection pooling? Please, help me to do the
same...
Here is my configs....
[server.xml]
....
<Resource auth="Container" name="jdbc/DB" scope="Shareable"
type="javax.sql.ConnectionPoolDataSource"/>
<ResourceParams name="jdbc/DB">
<parameter>
<name>factory</name>
<value>oracle.jdbc.pool.OracleDataSourceFactory</value>
</parameter>
<parameter>
<name>dataSourceName</name>
<value>oracle.jdbc.pool.OracleConnectionPoolDataSource</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@dbserver:1521:SID</value>
</parameter>
<parameter>
<name>description</name>
<value>my datasource</value>
</parameter>
<parameter>
<name>user</name>
<value>...</value>
</parameter>
<parameter>
<name>password</name>
<value>...</value>
</parameter>
</ResourceParams>
...
[end server.xml]
[web.xml]
...
<resource-env-ref>
<description>my db</description>
<resource-env-ref-name>jdbc/DB</resource-env-ref-name>
<resource-env-ref-type>javax.sql.ConnectionPoolDataSource</resource-env-ref-type>
</resource-env-ref>
...
[end web.xml]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
