Hi, in my code i never use a commit/rollback. If I'm not mistaken Torque makes a commit/rollback internally when method save() is called???? Can you explain a little bit more what you mean with testOnBorrow??
Ferruh > > Hi, > > One reason could be that you do not commit /rollback a connection before > giving it back to the pool, and the pool does not do a commit/rollback, > and > you fetch the connection again and the pool tries to set transaction > isolation or something similar. > Another reason might be that are you explicitly using any "set Transaction > ..." statement, and it is not the first statement in the transaction. This > can happen e.g. if you use testOnBorrow = true. > > Thomas > > "Ferruh Zamangoer" <[EMAIL PROTECTED]> schrieb am > 20.12.2004 18:31:12: > >> Hi NG, >> >> is there any way in Torque to turn on auto commit? We have the problem > that >> we become the following Exception, when we want to insert a dataset into > the >> database. >> >> java.sql.SQLException: ORA-01453: SET TRANSACTION muss erste Anweisung > der >> Transaktion sein >> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) >> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) >> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) >> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) >> at > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094) >> at >> > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132 > >> ) >> at >> > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015) > >> at >> > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java > >> :2877) >> at >> > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState > >> ment.java:608) >> at >> > oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.j > >> ava:684) >> at >> > oracle.jdbc.driver.OracleConnection.setReadOnly(OracleConnection.java:1579) >> at >> > org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setReadOnly(ConnectionImp > >> l.java:392) >> at >> > org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa > >> taSource.java:490) >> at >> > org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa > >> taSource.java:458) >> at > org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743) >> at org.apache.torque.Torque.getConnection(Torque.java:306) >> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1496) >> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1448) >> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1411) >> at > com.gistec.geomisservice.PtFreetextPeer.doInsert(PtFreetextPeer.java:33) >> at >> > com.gistec.geomisservice.sync.DataInserter.setPtText(DataInserter.java:461) >> at >> > com.gistec.geomisservice.sync.DataInserter.createCI_Citation(DataInserter.ja > >> va:5420) >> at >> > com.gistec.geomisservice.sync.DataInserter.setCI_Citation(DataInserter.java: > >> 5393) >> at >> > com.gistec.geomisservice.sync.DataInserter.setFeatureTypeB44(DataInserter.ja > >> va:3208) >> at >> > com.gistec.geomisservice.sync.DataInserter.setAttributeTypeB44(DataInserter. > >> java:3150) >> at >> > com.gistec.geomisservice.sync.DataInserter.setGF_AttributeType(DataInserter. > >> java:3093) >> at >> > com.gistec.geomisservice.sync.DataInserter.setMD_DescriptionList(DataInserte > >> r.java:2962) >> at >> > com.gistec.geomisservice.sync.DataInserter.setMD_MaintenanceInformation(Data > >> Inserter.java:998) >> at >> > com.gistec.geomisservice.sync.DataInserter.setMetdataMaintenance(DataInserte > >> r.java:1332) >> at >> > com.gistec.geomisservice.sync.DataInserter.doInsert(DataInserter.java:124) >> at >> > com.gistec.geomisservice.sync.DataSync.metaDataMustBeInserted(DataSync.java: > >> 248) >> at com.gistec.geomisservice.sync.DataSync.syncData(DataSync.java:197) >> at > com.gistec.geomisservice.TestClient.LogicTest.main(LogicTest.java:86) >> rethrown as org.apache.torque.TorqueException: ORA-01453: SET >> TRANSACTION >> muss erste Anweisung der Transaktion sein >> at > org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:755) >> at org.apache.torque.Torque.getConnection(Torque.java:306) >> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1496) >> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1448) >> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1411) >> at > com.gistec.geomisservice.PtFreetextPeer.doInsert(PtFreetextPeer.java:33) >> at >> > com.gistec.geomisservice.sync.DataInserter.setPtText(DataInserter.java:461) >> at >> > com.gistec.geomisservice.sync.DataInserter.createCI_Citation(DataInserter.ja > >> va:5420) >> at >> > com.gistec.geomisservice.sync.DataInserter.setCI_Citation(DataInserter.java: > >> 5393) >> at >> > com.gistec.geomisservice.sync.DataInserter.setFeatureTypeB44(DataInserter.ja > >> va:3208) >> at >> > com.gistec.geomisservice.sync.DataInserter.setAttributeTypeB44(DataInserter. > >> java:3150) >> at >> > com.gistec.geomisservice.sync.DataInserter.setGF_AttributeType(DataInserter. > >> java:3093) >> at >> > com.gistec.geomisservice.sync.DataInserter.setMD_DescriptionList(DataInserte > >> r.java:2962) >> at >> > com.gistec.geomisservice.sync.DataInserter.setMD_MaintenanceInformation(Data > >> Inserter.java:998) >> at >> > com.gistec.geomisservice.sync.DataInserter.setMetdataMaintenance(DataInserte > >> r.java:1332) >> at >> > com.gistec.geomisservice.sync.DataInserter.doInsert(DataInserter.java:124) >> at >> > com.gistec.geomisservice.sync.DataSync.metaDataMustBeInserted(DataSync.java: > >> 248) >> at com.gistec.geomisservice.sync.DataSync.syncData(DataSync.java:197) >> at > com.gistec.geomisservice.TestClient.LogicTest.main(LogicTest.java:86) >> Caused by: java.sql.SQLException: ORA-01453: SET TRANSACTION muss erste >> Anweisung der Transaktion sein >> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) >> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) >> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) >> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) >> at > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094) >> at >> > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132 > >> ) >> at >> > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015) > >> at >> > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java > >> :2877) >> at >> > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState > >> ment.java:608) >> at >> > oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.j > >> ava:684) >> at >> > oracle.jdbc.driver.OracleConnection.setReadOnly(OracleConnection.java:1579) >> at >> > org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setReadOnly(ConnectionImp > >> l.java:392) >> at >> > org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa > >> taSource.java:490) >> at >> > org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa > >> taSource.java:458) >> at > org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743) >> ... 18 more >> >> >> Can anybody tell us what is going wrong is there any problem in the code > or >> is has the database some problems by executing the statements. >> >> Thanks for any help in advance. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
