Helpful Information

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;
}