Toad is a terrific database tool, for Oracle: http://www.toadsoft.com/
It is a 5 star product. -----Original Message----- From: Kevin Andryc [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 2:41 PM To: Tomcat Users List Subject: RE: Database locked by Tomcat What is Toad? Kevin Andryc Web Systems Engineer MISER http://www.umass.edu/miser/ Phone: (413)-545-3460 [EMAIL PROTECTED] -----Original Message----- From: Scott Purcell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 03:36 PM To: Tomcat Users List Subject: RE: Database locked by Tomcat Have you updated any record using Toad? I updated some records in toad and forgot to hit commit, and it screwed me up for hours. My code that worked earlier stopped working and I was getting all kinds of wierd problems. I went back to toad, hit commit, and all problems disappeared. -----Original Message----- From: Kevin Andryc [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 1:07 PM To: Tomcat Users List Subject: RE: Database locked by Tomcat Hi Jeff, Thanks for the suggestion and code. I have tried this and Tomcat still holds the database. I know this because I have a program from Sysinternals that lists the files held by a process and the database is one of them. But here is the weird part. After some amount of time, the database does get released. I am lost at this point. Any more suggestions? Thanks, Kevin Kevin Andryc Web Systems Engineer MISER http://www.umass.edu/miser/ Phone: (413)-545-3460 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 01:54 PM To: Tomcat Users List Subject: Re: Database locked by Tomcat Hi, Kevin. Correction: Database locked by YOU! :) You've closed the statement but not the connection. You need a conn.close() after the commit. This shouldn't lock the database by itself, although if you keep leaving connections open, then you will eventually hit a connection max limit, which could be what's hanging it. I would also recommend that you put all that stuff in a try block and finally close the connection, something like this: Statement stmt = null; Connection conn = DriverManager.getConnection(dbfUrl, "", ""); try { // do some stuff conn.commit(); } catch(Exception e) { conn.rollback(); } finally { if ( stmt != null ) { try { stmt.close(); } catch(SQLException e) { // handle or ignore } } conn.close(); } HTH, Jeff Kevin Andryc <kandryc@miser. To: Tomcat Users List <[EMAIL PROTECTED]> umass.edu> cc: Subject: Database locked by Tomcat 06/11/02 12:44 PM Please respond to "Tomcat Users List" I am Running Tomcat 4.0 on Windows 2000. I have a servlet, which calls a program that connects to a DBF database natively (not using JDBC-ODBC) and updates records in the database. The problem I am having is that Tomcat does not release the database until I restart the Tomcat service. I close the connection and even do a "commit()". Has anyone else had a problem and if so, is there a solution? Below is some sample code: Class.forName(dbfDriverName).newInstance(); Connection conn = DriverManager.getConnection(dbfUrl, "", ""); Statement stmt = conn.createStatement(); // do some stuff statement.close(); connection.commit(); Thanks, Kevin -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
