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]