Hi Armin,
I made the changes you suggest.. the debug statements show
OJB: Create new DBCP connection
pool:[EMAIL PROTECTED]
jcd-alias=APPLICATION
default-connection=true
dbms=Oracle9i
jdbc-level=3.0
driver= oracle.jdbc.driver.OracleDriver
protocol=jdbc
sub-protocol=oracle
db-alias=thin:@XX.X.XX.XX:XXXXX:VPSu
user=application
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>
But the Platform dependend error Caused by: java.sql.SQLException:
Attempt to set Escape Processing after SQL is already processed still
occurred.
-----Original Message-----
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: Monday, December 12, 2005 10:17 AM
To: OJB Users List
Subject: Re: Oracle OJB error
Hi Eric,
Ferrer, Eric wrote:
> There is no Oracle error in the stack track or in the spy.log.
>
seems this is caused by oracle 10g driver
Caused by: java.sql.SQLException: Attempt to set Escape Processing after
SQL is already processed
Please try to use Oracle9i platform settings in your
jdbc-connection-descriptor. Set platform="Oracle9i" instead of
platform="Oracle". 'Oracle9i' setting is for 9i and higher.
regards,
Armin
> -----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]
>
>
---------------------------------------------------------------------
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]
