ansaurus

Question

Tomcat sometimes chokes on my new war file

Answer 1

A:

Well, I don't use that particular Tomcat server any more, and when I load the WAR file to my self-hosted tomcat, it sometimes gives that exception, but then it tries again and eventually loads it. I have no idea why the other Tomcat was like it was, but the hosting company evidently did some changes to it.

Paul Tomblin 2009-11-01 20:02:50

Do you use container connection pooling or handle the conneciton objects yourself?

Thorbjørn Ravn Andersen 2010-02-17 20:27:55

@Thor - I don't know, I didn't write most of the code for this app.

Paul Tomblin 2010-02-17 20:32:08

Answer 2

+1 A:

Hi guys .. I got this problem . the main reason that there is a connection object for JDBC (I suppose its static ) ...so just close it and give it value null in ovverrided function finilizer() like this ( con refers to connection Obj. ) :

@Override

protected void finalize() throws Throwable {

        super.finalize();

        try{
             con.close();
             }catch(Exception r){
                  r.getMessage();
             }
             con=null;
    }

This solve my problem, but on the other hand I dont recommand to use connection as static never .. M.

Free_Palestine 2010-01-29 06:55:49

You should fix it immediately. This way your webapp would only live for about half a hour until the DB decides to timeout and reclaim the connection. Always, always acquire *and* close connection, statement and resultset in the **shortest possible scope**, i.e. all inside the very same method block where the SQL is to be executed. Declare them outside try/finally block, acquire them in try block and close them in reversed order in finally block. For basic examples of correct JDBC code check this article: http://balusc.blogspot.com/2008/07/dao-tutorial-data-layer.html

BalusC 2010-01-29 11:46:22

the most efficient way to do this is by having the container do JDBC connection pooling.

Thorbjørn Ravn Andersen 2010-02-17 20:25:41

ansaurus

tags:

views:

answers:

Tomcat sometimes chokes on my new war file

related questions