Helpful Information
Home
Categories
Contact us
Category: Firebird SQL Development
Select For update with Lock
How can I check the row that has been seleted with lock options before?
Set Firebird transaction params
isc_tpb_nowait
and wach exception isc_lock_conflict (SQLCODE -901 )
Set Firebird transaction params
isc_tpb_nowait
and wach exception isc_lock_conflict (SQLCODE -901 )
how is this done in java?
I user the following code to connect to my DB
private java.sql.Connection firebird_connection = null;
try
{
firebird_connection = DriverManager.getConnection(databaseURL, username,userpass);
firebird_connection.setAutoCommit(false);
firebird_connection.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
}
catch (java.sql.SQLException e)
{
System.out.println(e.getMessage());
return false;
}
privacy (GDPR)