[castor-dev] Castor JDO and Connection Pooling

[Schlachter, Steffen (LDS)]

Hi,

 

I am trying to use Castor JDO with a Tomcat Connection Pool (for Ingres 2.6 database).

 

In the Castor JDO documentation I found the following example:

 

...

Database        db;

// Lookup databse in JNDI
ctx = new InitialContext();
db = (Database) ctx.lookup( "java:comp/env/jdo/mydb" );

// Do something
. . .
// Close the database
db.close();

 

The Problem is that the lookup returns a javax.sql.DataSource object which cannot be casted to a Database object as shown above.

 

My Web.xml config file has the following configuration entry:

...

  <resource-ref>
    <description>...</description>
    <res-ref-name>jdbc/deaDB</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

...

 

which refers to the following server.xml entry:

 

<Context ...>
 <ResourceParams name="jdbc/deaDB">
  <parameter>
   <name>factory</name>
   <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
   <name>driverClassName</name>
   <value>ca.edbc.jdbc.EdbcDriver</value>
  </parameter>
  <parameter>
   <name>url</name>
   <value>jdbc:edbc://localhost: ...</value>
  </parameter>
  <parameter>
   <name>username</name>
   <value>xyz</value>
  </parameter>
  <parameter>
   <name>password</name>
   <value>xyz</value>
  </parameter>
  <parameter>
   <name>maxActive</name>
   <value>8</value>
  </parameter>
  <parameter>
   <name>maxIdle</name>
   <value>3</value>
  </parameter>
  <parameter>
   <name>maxWait</name>
   <value>10000</value>
  </parameter>
  <parameter>
   <name>removeAbandoned</name>
   <value>true</value>
  </parameter>
  <parameter>
   <name>removeAbandonedTimeout</name>
   <value>60</value>
  </parameter>
  <parameter>
   <name>logAbandoned</name>
   <value>true</value>
  </parameter>
 </ResourceParams>
</Context>

 

 

Where  is the problem? Can anyone provide an example of using Castor JDO with a Tomcat connection pool?

 

Thanx,

 

   Steffen