Hi, I can get a connection running to Oracle just using the tranql connector that uses the tranQL/geronimo connection pooling, but I need to use the Oracle Connection Pooling as I am using Oracle RAC and oracle needs to manage the connections in the pool based on information it receives from the Oracle RAC.
Do I need to develop my own Resource Adapter to be able to have database connection served by the Oracle Connection Factory Pool (oracle.jdbc.pool.OracleDataSourceFactory), or am I missing some obvious configuration of geronimo/tranQL that would allow me to specify the Oracle class (oracle.jdbc.pool.OracleDataSourceFactory) as my connection pool? Thanks and regards Piers Lin Sun-2 wrote: > > 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 - > > > <dep:dependency> > <dep:groupId>oracle</dep:groupId> > <dep:artifactId>classes12</dep:artifactId> > <dep:version>10g</dep:version> > <dep:type>jar</dep:type> > </dep:dependency> > > > 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). > > <ext-module> > <connector>TradeDataSource</connector> > > <external-path>tranql/tranql-connector-oracle-xa/1.1/rar</external-path> > <connector > xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1";> > <resourceadapter> > <outbound-resourceadapter> > <connection-definition> > > <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface> > <connectiondefinition-instance> > <name>jdbc/TradeDataSource</name> > <config-property-setting > name="UserName">trade</config-property-setting> > <config-property-setting > name="Password">trade</config-property-setting> > <config-property-setting > name="DatabaseName">tradedb</config-property-setting> > <config-property-setting > name="DataSourceName">TradeDataSource</config-property-setting> > <config-property-setting > name="ServerName">linsun2</config-property-setting> > <config-property-setting > name="PortNumber">1521</config-property-setting> > <config-property-setting > name="DriverType">thin</config-property-setting> > <connectionmanager> > <xa-transaction> > <transaction-caching/> > </xa-transaction> > <single-pool> > <max-size>10</max-size> > <min-size>0</min-size> > > <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds> > <idle-timeout-minutes>30</idle-timeout-minutes> > <match-one/> > </single-pool> > </connectionmanager> > </connectiondefinition-instance> > </connection-definition> > </outbound-resourceadapter> > </resourceadapter> > </connector> > </ext-module> > > The oracle tranql rar file isn't in the geronimo assembly, > unfortunatelly. So you'll have to get it from the Tranql project > (http://tranql.codehaus.org/Download). 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" >> >> url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclehost1)(PORT=1529))(ADDRESS=(PROTOCOL=TCP)(HOST=oraclehost2)(PORT=1529))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TESTDB)))" >> 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 this message in context: http://www.nabble.com/How-to-configure-a-datasource-to-use-OracleDataSource-for-Datasource-pooling-tf3921766s134.html#a11121302 Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
