Tim Halloran wrote:
Is this in a program? What does the JDBC code look like? You can try
increasing its memory using -Xmx1200m or some such to the JVM.
It's a servlet application (using Jetty as the container and embedded
Derby). The JDBC is as follows:
PreparedStatement stat = database.getConnection().prepareStatement(
query,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY
);
ResultSet res = stat.executeQuery();
Generating the ResultSet takes a minute or so.
Do not catch Throwable, this pretty much never a good idea. What could
> you do?
I know, but I want to at least try to write a console message before
cave closing time if something bad happens.
----------------------------------------------------------------------
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing & MIS | "Those who don't know their history
University of Brighton | are condemned to relive it" (Santayana)
----------------------------------------------------------------------
