db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "yanrong zhang (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-83) ORA-01453: SET TRANSACTION must be first statement of transaction error in the method
Date Thu, 08 Feb 2007 15:21:06 GMT
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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message