There is no Oracle error in the stack track or in the spy.log. -----Original Message----- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, December 10, 2005 3:45 AM To: OJB Users List Subject: Re: Oracle OJB error
hi eric, i'm looking for the sql exception with an oracle error, something like ORA-xxxx. jakob Ferrer, Eric schrieb: > 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] > > --------------------------------------------------------------------- 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]
