tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Andryc <kand...@miser.umass.edu>
Subject RE: Database locked by Tomcat
Date Wed, 12 Jun 2002 19:49:53 GMT
Unfortunately I am not using Oracle. I am connecting to a Dbase database
(.DBF).

Kevin Andryc
Web Systems Engineer
MISER
http://www.umass.edu/miser/
Phone: (413)-545-3460
kandryc@miser.umass.edu



-----Original Message-----
From: Scott Purcell [mailto:spurcell@vertisinc.com]
Sent: Wednesday, June 12, 2002 03:46 PM
To: Tomcat Users List
Subject: RE: Database locked by Tomcat

Toad is a terrific database tool, for Oracle:
http://www.toadsoft.com/

It is a 5 star product.




-----Original Message-----
From: Kevin Andryc [mailto:kandryc@miser.umass.edu]
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
kandryc@miser.umass.edu



-----Original Message-----
From: Scott Purcell [mailto:spurcell@vertisinc.com]
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:kandryc@miser.umass.edu]
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
kandryc@miser.umass.edu



-----Original Message-----
From: jeff.guttadauro@abbott.com [mailto:jeff.guttadauro@abbott.com]
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
<tomcat-user@jakarta.apache.org>
                    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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>






--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message