Subject | firebird 1.5 deadlock problem and java |
---|---|
Author | ynoc78 |
Post date | 2004-12-05T17:37:22Z |
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
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