[jira] Closed: (TORQUE-83) ORA-01453: SET TRANSACTION must be first statement of transaction error in the method

["Thomas Fischer (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TORQUE-83?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Fischer closed TORQUE-83.
--------------------------------

    Resolution: Duplicate

> 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: Runtime
>         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