From torque-user-return-5663-apmail-db-torque-user-archive=db.apache.org@db.apache.org Mon Dec 20 17:52:28 2004 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 7462 invoked from network); 20 Dec 2004 17:52:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 20 Dec 2004 17:52:27 -0000 Received: (qmail 86282 invoked by uid 500); 20 Dec 2004 17:50:41 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 86217 invoked by uid 500); 20 Dec 2004 17:50:40 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 86086 invoked by uid 99); 20 Dec 2004 17:50:38 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.seitenbau.net (HELO mail.seitenbau.net) (194.175.229.106) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 20 Dec 2004 09:50:30 -0800 Received: from [195.127.188.18] (helo=www.seitenbau.net) by mail.seitenbau.net with esmtp (Exim 4.30) id 1CgRfv-0004Uc-0L for torque-user@db.apache.org; Mon, 20 Dec 2004 18:50:27 +0100 In-Reply-To: Subject: Re: Auto Commit + Transaction Problems To: "Apache Torque Users List" X-Mailer: Lotus Notes Release 6.0 September 26, 2002 Message-ID: From: Thomas Fischer Date: Mon, 20 Dec 2004 18:50:26 +0100 X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21, 2004) at 20.12.2004 06:50:25 PM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Scan-Signature: cc804c609332c6931084d8dc4f477936 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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" 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: torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: torque-user-help@db.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org