ORA-01453: SET TRANSACTION must be first statement of transaction error in the 
method
-------------------------------------------------------------------------------------

                 Key: TORQUE-83
                 URL: https://issues.apache.org/jira/browse/TORQUE-83
             Project: Torque
          Issue Type: Improvement
          Components: Test Project
         Environment: Torque and DBCP
            Reporter: yanrong zhang


the code that cause the problem as following, please help :

conn = Torque.getConnection(); 
      conn.setAutoCommit(false); 
      prepstmt = conn.createStatement(); 
      rs = prepstmt.executeQuery(sql); 
      conn.commit(); 
      while (rs.next()) { 
        if (rs.getString(2).trim().compareTo( 
            "com.wireless.sms.business.logicprocess.LogicManager") == 0) { 
          this.cpname = "myname"; 
        } 
        else { 
          this.CPName(rs.getS } 
    catch (Exception ex) { 
      result = new ArrayList(); 
      com.wireless.common.init.LogSystem.syslog.error(ex); 
    } 
    finally { 
      ClossDB.ClossDB2(null, prepstmt, null, rs); 
      if(conn!=null){ 
          Torque.closeConnection(conn); 
      } 
    } 
    return result; 
  }


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to