adam jvok wrote:
public static void deadLock(String firstTable, String secondTable,
ResultSet[] data1) throws SQLException, Exception {
Connection conn = DriverManager.getConnection("jdbc:default:connection");
conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE) ;
boolean ac=conn.getAutoCommit();
conn.setAutoCommit(false) ;
[snip]
conn.setAutoCommit(ac) ;
Somewhat unrelated, but FYI the JDBC connection in a Java procedure is
always in non-auto commit mode, thus there is no need to change its
auto-commit status or reset it.
Dan.
