I am using idb in a servlet environment for a very low-activity database.
It probably gets 30 hits a day, no big deal.
The servlets share a "database" class that abstracts away the basic
database connectivity. This database class keeps the same connection and
statement to the database, only closing the resultSet object once the
query is finished.
What I am finding is that the servlets consume memory so that every three
or four days I have to shut down the server (vqServer) and restart.
Should I be closing the statement as well? How about the database
connection? Might this be the source of my heap-monster?
-Matt Bishop
matt@bishop.org
EARTH FIRST--we'll screw up the other planets later.
To unsubscribe from this list, please send an
email to 'majordomo@smartcard.co.uk' with the text
'unsubscribe instantdb' in the message body.
|