Subject Re[2]: [Firebird-Java] request synchronization error
Author Danilo Luiz Rheinheimer
>> What can cause this error ? It happens when I execute a
>> Statement.executeQuery(sql).
>> java.sql.SQLException: fetch problem: org.firebirdsql.gds.GDSException: request synchronization error
>> at org.firebirdsql.jdbc.FBResultSet$FBCachedFetcher.<init>(FBResultSet.java:2590)
>> at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:124)
>> at org.firebirdsql.jdbc.FBStatement.getCachedResultSet(FBStatement.java:539)
>> at org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:102)
>> at testex.Main.main(Main.java:52)

>> fetch problem: org.firebirdsql.gds.GDSException: request synchronization error

NS> This is probably a bug in Jaybird. SQL exception thrown during early fetch
NS> operation is ignored by driver and error like this gets thrown when it
NS> continues trying to fetch data. What error do you get when execute
NS> your query by isql or another tool ?

No error, it works ok. Using SQL Explores who comes with Delphi 6.

NS> Could you give out some data to
NS> reproduce the error ?

I have a database where this happens.
It has 2 mb. If you want I can send it to you private e-mail.
And this do not happen everytime. But when it happen I need to exit
JBuilder to make it work again.

--
Best regards,
Danilo mailto:danilo@...