Uploaded image for project: 'Agroal'
  1. Agroal
  2. AG-182

Transaction isolation level -1 not supported.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 1.14
    • None
    • pool
    • None
    • False
    • False

      I'm trying to set transaction isolation level

       

       

      try(Connection conn = connPool.getConnection()) {
          try { 
              conn.setAutoCommit(false);
              conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
              // do my things
              conn.commit();
              System.out.println("commit");
          } catch (Exception e) {
               e.printStackTrace();
               conn.rollback(); 
               throw e; 
          }
      }
      System.out.println("conn closed");
      
      
      

      but I got this warning

      commit
      2021-10-21 11:56:01,577 WARN  [AgroalEventLoggingListener.java:76] (executor-thread-0) Datasource '<default>': Transaction isolation level -1 not supported.
      conn closed

      after the connection close(that was after I commit my transaction, the end of try(Connection...)

       

              lbarreiro-1 Luis Barreiro
              liuzqt Ziqi Liu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: