geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lin Sun <>
Subject Re: How to configure a datasource to use OracleDataSource for Datasource pooling
Date Thu, 14 Jun 2007 14:15:41 GMT
Hi, I tried this with Geronimo 1.1 w/ daytrader.  Basically I need to 
copy the oracle tranql rar file and the oracle jar file into my 
repository, and specify the dependency of the oracle jar file somewhere 
in the plan -


and develop a resource adapter plan like below  (below is an application 
scoped connection pool plan, but it can also be a server wide plan).


The oracle tranql rar file isn't in the geronimo assembly, 
unfortunatelly.  So you'll have to get it from the Tranql project 
(  You can download the binary 
(that is a bit old than what I used) or build it yourself.  The ra.xml 
inside of the rar file contains what configuration parameters you can 
specify in the connection pool plan.

HTH, Lin

Piers Geyman wrote:
> Hi,
> I am trying to migrate from tomcat to geronimo and I am having trouble being
> able to configure my Oracle RAC datasource in geronimo to use the Oracle
> Driver's connection pooling rather than the default geonimo pooling.
> In tomcat I configured my datasource as follows, which used the Oracle
> Datasource connection pool rather than DBCP, but I cannot see how I can do
> the same in Geronimo.
>         <Resource
>                 auth="Container"
>                 description="My Oracle Datasource"
>                 name="jdbc/myOracleDataSource"
>                 type="oracle.jdbc.pool.OracleDataSource"
>                 factory="oracle.jdbc.pool.OracleDataSourceFactory"
>                 driverClassName="oracle.jdbc.OracleDriver"
>                 user="devapp"
>                 password="devapp"
>                 maxIdle="20"
>                 minIdle="10"
>                 maxWait="5000"
>                 maxActive="100"
>                 connectionCachingEnabled="true"
>                 fastConnectionFailoverEnabled="true"
>                 connectionCacheName="myOracleDatasourceCache"
>                 onsConfigStr="nodes=oraclehost1:6200,oraclehost2:6200"
>                 connectionProperties="oracle.jdbc.ReadTimeout=30000"/>
> I see that other connection pools to the databases seem to use tranQL, but
> there seems to be no documentation for this product.
> Any help would be appreciated.
> Thanks and regards
> Piers

View raw message