Hello!

I've a problem with prepared statements and
ResultSet.HOLD_CURSORS_OVER_COMMIT in
autocommit connections:

PreparedStatement prp =
conAC.prepareStatement (dbo.getStatement (),
ResultSet.FETCH_FORWARD,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.HOLD_CURSORS_OVER_COMMIT);

org.firebirdsql.jdbc.FBDriverNotCapableException:
Holdable cursors are supported only for scrollable insensitive result sets.
at org.firebirdsql.jdbc.AbstractConnection.checkHoldability(AbstractConnection.java:793)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:856)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824)
[...]


"Holdable cursors are supported
only for scrollable insensitive
result sets."

But ResultSet.TYPE_SCROLL_INSENSITIVE &
ResultSet.HOLD_CURSORS_OVER_COMMIT is a
scrollable insensitive result set?


So I can't set prp statements with HOLD_CURSORS_OVER_COMMIT :-(

best regards,
josh.