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]