JNDI problem for getting connection from a pool - Tomcat 4.1.18

[Anonymous]

Hi there !
I�m trying to use the Tomcat�s connection pool but something I don�t know is going wrong. The code snippet is as follows :
. . .
Object value = ctx.lookup("java:/comp/env/dsdb1");

Connection c = ((DataSource) value).getConnection();
. . .
I�ve already configured the DataSource for the context I�m using the pool with the parameters as follows :
Property Value
JNDI Name: dsdb1
Data Source URL: jdbc:mysql://localhost:3306/turma1
JDBC Driver Class: org.gjt.mm.mysql.Driver
User Name: root
Password:
Max. Active Connections: 5
Max. Idle Connections: 2
Max. Wait for Connection: 5000
Validation Query:
The USE NAMING parameter is set to true.
I�m using a .jsp to test the pool with the code above , but when I call the testpool.jsp page, the browser keeps on waiting for the server�s response... I�ve already tracked the code and it �stops� right on the getConnection method.
Any idea why it�s �freezing� ?
Thanks !
F�bio

[herbert christy]

Hi,
I encountered the same problem and I read somewhere. It works.
Make sure the common-dbcp & pool-1 jar files are located in
/common/lib folder. These jar files can be downloaded from tomcat website.
The next step is adding these parameters between your <ResourceParams>
in your server.xml

<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>300</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>

Somehow, after I added these parameters, it works fine.
Give it a try.