tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Federico Tello Gentile" <fdtel...@flashmail.com>
Subject RE: TOMAT slowing down a lot after a while
Date Tue, 24 Oct 2000 16:03:23 GMT
You were right!
I was closing the ResultSets but not the Statements.
Now I've fixed it and it works a lot better.
However it is still a bug, because when I wasn't loading the servets on
startup the conection with the DB was closed but the Statement objects that
were stil open weren't closed.

I guess for my college assignment it'll work like this, but I've read Access
doesn't lock records on access if they aren't done from the Access UI.

It won't hurt setting up a mySQL db, I guess I can export the data without
problems.

Thanks to all of you.

----- Mensaje original -----
De: Julio Serje (@Canada) <jserje@home.com>
> Hi,
>
> I'm running a small app. with Tomcat and JDBC connections to MS Access,
and
> have had no problems at all, so I think you may be doing something wrong
(or
> ommiting something). As a general recommendation (I'm sorry if it sounds
> stupid, but may help you...) you should make sure that you are closing ALL
> jdbc objects (including resultsets and statements, i.e:
>
> stmt.close();
> rset.close();



Mime
View raw message