Subject Re: [Firebird-Java] commit retain / rollback retain
Author Evgeny Putilin
Hi
> Does Jaybird offer any way to commit or rollback retaining, and keep result sets open, without
> using the "holdability" flag?
Yes. You can execute statement "commit retaining" like any other statement. Execute "commit" work for Firebird API and didn't work for Jaybird.
Example(it's work):
....
PreparedStatement commitRetaining = connection.prepareStatement("commit retaining");

.....
commitRetaining.executeUpdate();// Call commit retaining

....


WBR Eugeney Putilin