-----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]