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]
