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?
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?