Connection and ConnectionHandler

Hi all,





we have a java servlet with a Tomcat based Oracle connection pool.





Is there any way to take advantage of this connections to perform structure searching or we need to create an additional Connection based on the Jchem Connection Handler?





Thanks in advance.

Hi,





ConnectionHandler also stores a standard java.sql.Connection object, plus the name of the property table (the default property table is "JChemProperties").





If a ConnectionHandler object is required, you can simply take the connection object from your connection pool, and set it for the ConnectionHandler:





ConnectionHandler ch=new ConnectionHandler();


ch.setConnection( connectionFromThePool);





You may also set the property table, if it's not the default:





ch.setPropertyTable("MyPropertyTable");





Please visit the API for more information:





http://www.jchem.com/doc/api/chemaxon/util/ConnectionHandler.html





Best regards,





Szilard

Thanks !!!!!