Subject firebird 1.5 deadlock problem and java
Author ynoc78
hi there,
i have 2 transactions

java.sql.Connection con1
java.sql.Connection con2

con1.setTransactionIsolation(TRANSACTION_SERIALIZABLE);
con1.setAutoCommit(false);
con2.setTransactionIsolation(TRANSACTION_SERIALIZABLE);
con2.setAutoCommit(false);

both execute a transaction
con1: update X set value = 'v1';
con2: update X set value = 'v2';

con1 is commited when the user finished his inputs (so not right away).
con2 could try before con1 commits to update. because i dont know how
to set the connection param to "NOWAIT" con2 freezes until con1 commits.
How can i set the transaction param to "ISC_TPB_NOWAIT" ?

Please help