Connection open after exiting Jchem.

User 6f93634cd9

03-05-2005 12:43:41

Hi,





I have intergrated an existing webapplication with Jchem. Because the application uses a MS Access database I have stored the Jchem data in the same database.





The webapplication runs on IIS on port 80, Jchem on Tomcat 5.5.7 on the same server on port 8080. Connection from the Jchem tot the database is with an jdbc.odbc connection.





It all works fine, but after switching to another website, the connection from the Jchem application to the database remains active. The .ldb file remains and can't be deleted until after a restart of Tomcat. This, in turn, prevents the other application from reconnecting to the database.





Whith SQL server or Oracle this wouldn't be a problem, however, our client wants to remain on MS Access for the time being.





The question is how and where in the code do I close the connection?

ChemAxon 9c0afc9aaf

03-05-2005 19:20:12

Hi,





When talking about JChem, do you mean the JSP example application that comes with the package (jchem/examples/jsp1_x/) ?





I think MS Access should allow more than 1 connection at the same time.


Maybe it's an Access configuration issue ?





Best regards,





Szilard