JNDI configuration

[Vincent Lambert]

Hi,
 
I am trying to configure OJB to connect a database with a connection
pool.
I am using :
OJB 0.9.5
Tomcat 4.0.3
JDK 1.4
Commons-collections 2.0
Commons-dbpc 1.0
Commons-pool 1.0.1
 
 
Here is my jdbc-connection-descriptor :
 
 <jdbc-connection-descriptor
  platform="MySQL"
  jdbc-level="3.0"
  jndi-datasource-name="java:comp/env/jdbc/catalogueDS"
  username="us_catalogue"
  password="us_catalogue"/>

 
 
Every thing works well when i use th followind DataSource :
 
                 <Resource name="jdbc/catalogueDS" auth="Container"
type="javax.sql.DataSource"/>
                  <ResourceParams name="jdbc/catalogueDS">
                    <parameter>
                      <name>user</name>
                      <value>us_catalogue</value>
                    </parameter>
                    <parameter>
                      <name>password</name>
                      <value>us_catalogue</value>
                    </parameter>
                    <parameter>
                      <name>driverClassName</name>
                      <value>org.gjt.mm.mysql.Driver</value>
                    </parameter>
                    <parameter>
                      <name>driverName</name>
 
<value>jdbc:mysql://localhost:3306/db_catalogue</value>
                    </parameter>
                  </ResourceParams>

 
But when I configure a connection pool it does not work any more :

                 <Resource name="jdbc/catalogueDS" auth="Container"
type="javax.sql.DataSource"/>
                  <ResourceParams name="jdbc/catalogueDS">
                    <parameter>
                      <name>factory</name>
 
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                    </parameter>
                    <parameter>
                      <name>maxActive</name>
                      <value>5</value>
                    </parameter>
                    <parameter>
                      <name>maxIdle</name>
                      <value>3</value>
                    </parameter>
                    <parameter>
                      <name>maxWait</name>
                      <value>60000</value>
                    </parameter>
                    <parameter>
                      <name>username</name>
                      <value>us_catalogue</value>
                    </parameter>
                    <parameter>
                      <name>password</name>
                      <value>us_catalogue</value>
                    </parameter>
                    <parameter>
                      <name>driverClassName</name>
                      <value>org.gjt.mm.mysql.Driver</value>
                    </parameter>
                    <parameter>
                      <name>url</name>
 
<value>jdbc:mysql://localhost:3306/db_catalogue</value>
                    </parameter>
                  </ResourceParams>

 
Thanks for help...
 
Regards,
Vince