cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: OracleDataSourceFactory
Date Tue, 04 Apr 2006 15:26:30 GMT
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  

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"
           username="userName" password="secret" maxActive="5"  

*** Tomcat 5.0

<Resource name="jdbc/myds" auth="Container"  
<ResourceParams name="jdbc/myds">



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

View raw message