Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of mrkafk@gmail.com designates
 209.85.161.46 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject
         :content-type:content-transfer-encoding;
        b=LiUwBFPKDiwyBGawF4jWCdsDsVJ8ty9527b5DG13BkkrkG7hlxee/DgXXBQkg8NXhY
         8QRRie4Dniz5AKfRUPjYNSgSEG37LytyMNJ/G1o2fbI1Gemp6KzScMeegOpN+K+/VoAR
         qAZNgnyERS60XfXl4+2s4wfsJlSVLSVU8WupU=
Message-ID: <4BF12001.6030805@gmail.com>
Date: Mon, 17 May 2010 12:52:49 +0200
From: Marcin Krol <mrkafk@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: ShutdownException while executing query
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello everyone,

I'm new to Derby and don't know what I'm doing wrong: I have an app that 
produces a temporary file, loads it into Derby (with 
SYSCS_UTIL.SYSCS_IMPORT_TABLE), creates some indexes, and then executes 
a simple query:

ResultSet res = derbyst.executeQuery("SELECT COUNT(*) FROM TMP_CVER");
printoutResultSet(res);

printoutResultSet just iterates over result set rows.

After printoutResultSet the program terminates.

The thing is I'm frequently getting ShutdownExceptions when 
printoutResultSet is executing.

It looks as if execution flew by printoutResultSet and finalized my 
class which caused .next() method on result set to throw an exception: I 
do get class finalization diagnostic printouts.

But I'm not doing any multithreaded programming in this program. I'm 
puzzled as to what could cause this.


private void printoutResultSet(ResultSet rs) throws SQLException {
     if (rs != null)
     {
         logger.trace("Result:");

         ResultSetMetaData md = rs.getMetaData();
         int colcount = md.getColumnCount();
         while (rs.next())
         {
             String line = "";
             for (int i = 1; i <= colcount; i++)
                 line += rs.getString(i) + ", ";
             System.out.println(line);
         }
     } else
         logger.trace("null ResultSet after executing h2 Query");
}


-- 

Regards,
mk

--
Premature optimization is the root of all fun.