[Hsqldb-user] Statement/Connection question

[Bayless K. <bk...@co...>]

I have two Statements using the same Connection with JDBC in a Java program.
On Statement #1, I open a ResultSet to process a list of records.
At the end of each record, I use the Statement #2 to update a single record in another table.
It appears that this update on Statement #2 is closing the ResultSet on Statement #1.
Is that correct? I feel sure I have done this in the past with no problems.

Using Hsqldb 2.0.0 on Windows 7 with Java 1.6.24.

Bayless Kirtley