On Cayenne end you need to specify JNDIDataSourceFactory and use the
JNDI name mapped in Tomcat.
I don't have experience with OracleDataSourceFactory pool per se, but
you don't have to use it - AFAIK Tomcat wraps the driver in its own
pool.
Watch out for two things:
1. Oracle driver jar must be in $tomcat_home/common/lib
2. server.xml entry depends on Tomcat version. Here is examples of my
existing configurations (note that there is no factory specification
anywhere, just the driver)
*** Tomcat 5.5
<Context path="/myapp" docBase="myapp">
<Resource name="jdbc/myds" auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin..27.0.0.1:1521:dbname"
username="userName" password="secret" maxActive="5"
maxIdle="2"
maxWait="-1"/>
</Context>
*** Tomcat 5.0
<Resource name="jdbc/myds" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myds">
<parameter>
<name>username</name>
<value>***</value>
</parameter>
<parameter>
<name>password</name>
<value>****</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin..27.0.0.1:1521:dbname</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
</ResourceParams>
Andrus
On Apr 4, 2006, at 6:54 PM, Marie Goutière wrote:
> Hello everybody.
>
> Is it possible to make an OracleDataSourceFactory with Tomcat (in
> the tomcat web.xml /ressourceParam tag) works with Cayenne or not.
>
> We're trying to open an other connection to an Oracle database but
> it doesn't work.
> It seems that tomcat doesn't "take care" of this
> OracleDataSourceFactory.
>
> Is anyone has ever tried this ?
>
> Thanks
> Marie
>
>
>
This archive was generated by hypermail 2.0.0 : Tue Apr 04 2006 - 11:26:57 EDT