This is the same problem i'm having. I'm using the RC1 release of the JDBC drivers. I've had the database working before, but now all it responds with is a "request synchronization error" The program is running via tomcat 4.0.

Statement select: SELECT * FROM GAME_TABLE

Here's the bottom of the stack trace,

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 com.ifone.util.SQLManager.select(SQLManager.java:45)
...

Anyone have any ideas?

--- In Firebird-Java@y..., Danilo Luiz Rheinheimer <danilo@f...> wrote:
> >> 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@f...