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]
