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]