Results 1 to 3 of 3
  1. #1
    kimkim991 is offline Member
    Join Date
    Jul 2011
    Posts
    1
    Rep Power
    0

    Default About Transaction Handling in Java

    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

  2. #2
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    8

    Default

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

  3. #3
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

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

Similar Threads

  1. How to handle Transaction IN and OUT in Inventory using java
    By techsing14 in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 04-13-2011, 04:27 AM
  2. Error for second transaction
    By anilkumar_vist in forum Advanced Java
    Replies: 0
    Last Post: 12-29-2010, 04:22 AM
  3. Replies: 0
    Last Post: 06-28-2010, 01:30 PM
  4. Jotm (Java Open Transaction Management)- Heap Memory Issues
    By hariprashanth in forum Advanced Java
    Replies: 0
    Last Post: 12-18-2008, 12:42 PM
  5. jsp:include in a sql:transaction
    By sam2020 in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 07-31-2008, 09:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •