Usually people use stmt.executeUpdate(...), not stmt.execute(...),
but I will check this issue.

Thanks a lot!

Roman Rokytskyy

--- In Firebird-Java@y..., "Blas Rodriguez Somoza" <blas@p...> wrote:
> Hello
>
> I have found the following bug in the driver
>
> When executing the code
>
> stmt=conn.createStatement();
> stmt.execute("update CTSTABLE2 set PRICE=PRICE*20 where
TYPE_ID=1");
> java.sql.ResultSet retResSet=stmt.getResultSet();
> stmt.close();
>
> the getResultSet method throws
>
> java.lang.Error: registerStatement called with no transaction
> at
> org.firebirdsql.jca.FBManagedConnection.registerStatement
(FBManagedConnectio
> n.java:633)
> at
> org.firebirdsql.jdbc.FBResultSet$FBStatementFetcher.<init>
(FBResultSet.java:
> 2519)
> at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:104)
> at org.firebirdsql.jdbc.FBStatement.getResultSet
(FBStatement.java:526)
>
> When, according to the specifications it must return a empty
ResultSet.
>
> Regards
> Blas Rodriguez Somoza