Submitted by: Ludovic Orban (lorban)

Assigned to: Roman Rokytskyy (rrokytskyy)

When executing this statement: INSERT INTO users(id) VALUES (GEN_ID(user_id_seq, 1))
and the user_id_seq generator is not present, Jaybird throws an exception.

Now compare these two stack traces:

with JayBird-2.0.1 JDK_1.4:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544343. invalid request BLR at offset 34
generator USER_ID_SEQ is not defined
at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:850)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:813)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:806)
at org.firebirdsql.pool.PingablePooledConnection.prepareStatement(PingablePooledConnection.java:399)
at org.firebirdsql.pool.XPreparedStatementCache.take(XPreparedStatementCache.java:117)
at org.firebirdsql.pool.PingablePooledConnection.getPreparedStatement(PingablePooledConnection.java:376)
at org.firebirdsql.pool.PooledConnectionHandler.handlePrepareStatement(PooledConnectionHandler.java:295)
at org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:223)
at $Proxy0.prepareStatement(Unknown Source)
...

and with Jaybird-2.1.0 JDK_1.4:

org.firebirdsql.jdbc.FBSQLException: Exception. null
at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(FBStatementFactory.java:85)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:869)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:817)
at org.firebirdsql.pool.PingablePooledConnection.prepareStatement(PingablePooledConnection.java:431)
at org.firebirdsql.pool.XPreparedStatementCache.take(XPreparedStatementCache.java:117)
at org.firebirdsql.pool.PingablePooledConnection.getPreparedStatement(PingablePooledConnection.java:408)
at org.firebirdsql.pool.PooledConnectionHandler.handlePrepareStatement(PooledConnectionHandler.java:295)
at org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:223)
at $Proxy0.prepareStatement(Unknown Source)
...

The error message got dropped in version 2.1.0.