Subject JBIRD 1.55+ Double trouble
Author nagypapi
My program errors like never before :)

The code snippet in my program:
Statement st=conn.createStatement();
Statement st2=conn.createStatement();

String query="select a,lot,of,stuff from a_table where
date>='"+date+"' order by something";

ResultSet rs=st.executeQuery(query);
while( {
query="select some,other,stuff from a_different_table where
ResultSet rs2=st2.executeQuery(query);
while( do_stuff_that_only_read_from_rs2();

if there is no data returned from the first query, I get no problem.
But if there is data returned from the first query, I get an Exception
both with JBIRD1.55 and with JBIRD2.
This code worked beforehand with JBIRD1.55, until I put in the

And this is not all. It seems I get a different error at a different
place with embedded and with ss.

Embedded Error occurs at while( :
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic
SQL Error
SQL error code = -504
at ...

SS error occurs at while(
org.firebirdsql.jdbc.FBSQLException: The result set is closed

Now I remembered that you helped me with the last error, saying I
cannot have two resultsets open with autocommit set to true, because
of the JDBC spec.

But I set autocommit to false, as you can see in the snippet, so I
kept on looking and I found, that after the first loop of
while( and while( autocommit changes automaticly
to true...

But I still don't have an idea why the embedded-specific error occurs,
and the error message doesn't say much either.

Is this a bug, or is this me, or is this both :)
Can you derive something from these errors, or do I need to produce a
test case?