About Transaction Handling in Java

[kimkim991]

I have set the auto-commit mode to false. Then run the tranactions
. In this transaction, First, Insert two records in to the "ABC" table. then select one of the inserted records in "ABC" table. After transacation , there is no record can be found.
I have tried to set the following statement
connection.setTransactionIsolation(Connection.TRAN SACTION_READ_UNCOMMITTED) ;
But there is a error.

[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R java.sql.SQLException: READ_COMMITTED 和 SERIALIZABLE is unique valid level for transaction
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:111)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:145)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:207)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at oracle.jdbc.driver.PhysicalConnection.setTransacti onIsolation(PhysicalConnection.java:1607)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:79)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at org.logicalcobwebs.proxool.WrappedConnection.invok e(WrappedConnection.java:162)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at org.logicalcobwebs.proxool.WrappedConnection.inter cept(WrappedConnection.java:87)
[2011/7/13 18:41:00:556 CST] 00000025 SystemErr R at oracle.jdbc.internal.OracleConnection$$EnhancerByP roxool$$322a6dd9.setTransactionIsolation(<generate d>)


Thank

[r035198x]

Are you using Oracle?
Because Oracle does not support Connection.TRANSACTION_READ_UNCOMMITTED.

[masijade]

Create a small, self-contained, compilable example that displays the same symptoms as your current problem and post that.