Here it is Jakob, DEBUG - OJB: TableAlias(): using hints ? false,null,,swav,123,2005-12-09 14:42:51.649 DEBUG - OJB: SQL:SELECT A0.MODIFY_DTIME,A0.PARAMETER_NAME,A0.SYSTEM_ID,A0.DATA_TAG,A0.MODIFY_USE R,A0.CREATE_DTIME,A0.CREATE_USER,A0.PARAMETER_VALUE,A0.DESCRIPTION,A0.SY STEM_PARAMETER_ID,A0.MODIFY_USER_DB FROM SYSTEM_PARAMETER A0 WHERE A0.SYSTEM_ID = ?,null,,swav,123,2005-12-09 14:42:51.649
13984 2005-12-09 14:42:51,649 ERROR - OJB: Platform dependend failure,null,,swav,123,2005-12-09 14:42:51.649 org.apache.ojb.broker.platforms.PlatformException: Could not set escape processing at org.apache.ojb.broker.platforms.PlatformOracleImpl.afterStatementCreate( PlatformOracleImpl.java:63) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatemen t(StatementsForClassImpl.java:333) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatemen t(StatementsForClassImpl.java:223) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt (StatementsForClassImpl.java:167) at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( StatementManager.java:637) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccess Impl.java:276) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObje ct.java:74) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIter atorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( PersistenceBrokerImpl.java:1780) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Pe rsistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Que ryReferenceBroker.java:104) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Que ryReferenceBroker.java:203) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Que ryReferenceBroker.java:223) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1205) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu ery(DelegatingPersistenceBroker.java:331) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu ery(DelegatingPersistenceBroker.java:331) at com.transcore.nucleus.persist.connection.ojb.OJBDataConnection.loadByExa mple(OJBDataConnection.java:608) at com.transcore.nucleus.persist.connection.ojb.OJBDataConnection.loadByExa mple(OJBDataConnection.java:595) at com.transcore.placid.lookup.AppLookupData.popSysParams(AppLookupData.jav a:2154) at com.transcore.placid.lookup.AppLookupData.populate(AppLookupData.java:38 8) at com.transcore.placid.lookup.AppLookupData.<init>(AppLookupData.java:358) at com.transcore.placid.lookup.AppLookupData.getSubInstance(AppLookupData.j ava:323) at com.transcore.placid.util.file.FileSupport.getImageServerUrl(FileSupport .java:110) at com.transcore.placid.util.file.FileSupport.imageBeansPathToUrl(FileSuppo rt.java:81) at com.transcore.placid.util.file.FileSupport.pathToUrl(FileSupport.java:55 ) at com.transcore.bland.ui.queue.plate.PlateTypeSelectDelegate.loadFrontImag ePaths(PlateTypeSelectDelegate.java:151) at com.transcore.bland.ui.queue.plate.PlateTypeSelectDelegate.load(PlateTyp eSelectDelegate.java:103) at com.transcore.bland.ui.queue.plate.PlateTypeSelectDelegate.next(PlateTyp eSelectDelegate.java:74) at com.transcore.bland.ui.queue.plate.PlateTypeSelectDelegateTester.test_ne xt(PlateTypeSelectDelegateTester.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTe stRunner.java:421) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRun ner.java:305) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRu nner.java:186) Caused by: java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12 5) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:16 2) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:22 7) at oracle.jdbc.driver.OracleSql.setEscapeProcessing(OracleSql.java:343) at oracle.jdbc.driver.OraclePreparedStatement.setEscapeProcessing(OraclePre paredStatement.java:3190) at com.p6spy.engine.spy.P6Statement.setEscapeProcessing(P6Statement.java:18 1) at org.apache.commons.dbcp.DelegatingPreparedStatement.setEscapeProcessing( DelegatingPreparedStatement.java:213) at org.apache.commons.dbcp.DelegatingPreparedStatement.setEscapeProcessing( DelegatingPreparedStatement.java:213) at org.apache.ojb.broker.platforms.PlatformOracleImpl.afterStatementCreate( PlatformOracleImpl.java:59) ... 44 more -----Original Message----- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 1:54 PM To: OJB Users List Subject: Re: Oracle OJB error hi eric, i do not have an oracle installation here so i can only guess. but afaik ojb only sets the escapeProcessing. btw could you please post the oracle sql exception ? jakob Ferrer, Eric schrieb: > Hi Jakob, > > OJB is the persistence layer used throughout the project. I can create > a test connecting to Oracle directly and see what happens. I am > currently creating a SQL Server instance and seeing if I get similar > results from OJB. > > Could it be the OraclePlatform implementation in OJB that is doing > something Oracle does not want it to do? > > Thanks > > -----Original Message----- > From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] > Sent: Friday, December 09, 2005 1:29 PM > To: OJB Users List > Subject: Re: Oracle OJB error > > hi eric, > > the error is caused by stmt.setEscapeProcessing(true) in > the paltform: > > public void afterStatementCreate(Statement stmt) throws > PlatformException > { > try > { > stmt.setEscapeProcessing(true); > } > catch (SQLException e) > { > throw new PlatformException("Could not set escape > processing", e); > } > } > > have you tried stmt.setEscapeProcessing(true) on a prepared statement > without using ojb ? > > jakob > > Ferrer, Eric schrieb: > >>We recently started getting a weird error with OJB and we are trying > > to > >>find out if its an Oracle specific issue or an OJB issue that would >>happen cross databases. >> >> >> >>We get from our logs >> >>OJB: Create new DBCP connection >>pool:[EMAIL PROTECTED] >> >> jcd-alias=SECURITY >> >> default-connection=false >> >> dbms=Oracle >> >> jdbc-level=3.0 >> >> driver=oracle.jdbc.driver.OracleDriver >> >> protocol=jdbc >> >> sub-protocol=oracle >> >> db-alias=thin:@XX.X.XX.XX:XXXX:VPSu >> >> user=security >> >> password=***** >> >> eager-release=false >> >> ConnectionPoolDescriptor={whenExhaustedAction=0, >>validationQuery=SELECT 1 FROM DUAL, maxIdle=-1, maxActive=256, >>maxWait=5000, removeAbandoned=false, numTestsPerEvictionRun=10, >>testWhileIdle=false, minEvictableIdleTimeMillis=600000, >>testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300, >>timeBetweenEvictionRunsMillis=-1, testOnBorrow=true} >> >> batchMode=false >> >> useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE >> >> ignoreAutoCommitExceptions=false >> >> sequenceDescriptor=<null> >> >>] >> >>38359 2005-12-08 16:27:48,455 DEBUG - OJB: SQL:INSERT INTO LOG >> > > (LOG_ID,LOG_DTIME,LOG_LEVEL,MESSAGE,SESSION_ID,LOG_USER,MODULE,SOURCE,EX > > CEPTION,CREATE_USER,CREATE_DTIME,MODIFY_USER,MODIFY_DTIME,MODIFY_USER_DB > >>,DATA_TAG) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) >>,null,,swav,112233,2005-12-08 16:27:48.455 >> >>38468 2005-12-08 16:27:48,564 ERROR - OJB: Platform dependend >>failure,null,,swav,112233,2005-12-08 16:27:48.564 >> >>org.apache.ojb.broker.platforms.PlatformException: Could not set > > escape > >>processing >> >> at >> > > org.apache.ojb.broker.platforms.PlatformOracleImpl.afterStatementCreate( > >>PlatformOracleImpl.java:63) >> >> at >> > > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatemen > >>t(StatementsForClassImpl.java:333) >> >> at >> > > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatemen > >>t(StatementsForClassImpl.java:223) >> >> at >> > > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt > >>(StatementsForClassImpl.java:167) >> >> at >> > > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > >>StatementManager.java:637) >> >> at >> > > org.apache.ojb.broker.util.BrokerHelper.doesExist(BrokerHelper.java:628) > >> at >> > > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroker > >>Impl.java:679) >> >> at >> > > org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingP > >>ersistenceBroker.java:174) >> >> at >> > > org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingP > >>ersistenceBroker.java:174) >> >> at >> > > com.transcore.nucleus.persist.connection.ojb.OJBDataConnection.save(OJBD > >>ataConnection.java:825) >> >> at >> > > com.transcore.nucleus.persist.connection.ojb.OJBDataConnection.save(OJBD > >>ataConnection.java:798) >> >> at >> > > com.transcore.premise.measure.logger.db.DbLoggerDelegate.commit(DbLogger > >>Delegate.java:162) >> >> at >> > > com.transcore.premise.measure.logger.db.DbLoggerDelegate$DbLogWriteTask. > >>run(DbLoggerDelegate.java:45) >> >> at java.util.TimerThread.mainLoop(Timer.java:432) >> >> at java.util.TimerThread.run(Timer.java:382) >> >> >> >>Any thoughts what could be causing this error? The application >>continues to run, but this error continues to repeat itself >> >> >> >> > > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]