JDBC Connection Pooling and Jchem

I just installed jchem 3.2.6 (ojdbc14.jar) and all is working but it appears that the JDBC connections are not persisting. Each jc_compare search results in an oracle connect and disconnect. Our install of 3.1.5 (classes12.zip) does not exhibit this behavior. How do I enable connection pooling in jchem ? Maybe I am missing a step but nowhere in the docs does it talk about configuring connection pooling parameters.

Quote:

Maybe I am missing a step but nowhere in the docs does it talk about configuring connection pooling parameters.

You're the first JChem Cartrdige user I hear mention connection pooling. <smile/>





You probably have a user login configured for the JDBC in Tomcat (along with a password), correct? If so, try the following:





1. open a sqlplus session as this user


2. call jchem_core_pkg.use_password(<user-s-password>)





Let me know if this helps.





Thanks


Peter

We are not using jchem_core_pkg.use_password. The password is set via the admin screen only.





The behavior I am seeing is that connections to the cartridge user on version 3.1.5 are being re-used.





The recent install is generating a new Oracle connection each time we do a search.





If you tail the Oracle listener.log "tail -f $ORACLE_HOME/network/log/listener.log" and do a jc_compare you will see a new connection each time you run a search.





This is a performance issue becuase each search is now incurring the delay associated with an Oracle connection.

Ok, you will have it back (connection pooling with this kind of setup) with JChem 3.2.7 or 3.2.8 at the latest. (We have a very short commit deadline for 3.2.7.)





Thanks


Peter

JChem 3.2.7 has been released with the JChem Cartridge "super user" using connection pool again.





P.