RE: Oracle OJB error
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:X: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=60,
testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300,
timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
batchMode=false
useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
ignoreAutoCommitExceptions=false
sequenceDescriptor=
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-.
>
> 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.(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(
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-. 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.(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.(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(DelegatingMethod
RE: Oracle OJB error
There is no Oracle error in the stack track or in the spy.log. -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-. 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.(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.(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) >
Re: Oracle OJB error
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::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=60,
testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300,
timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
batchMode=false
useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
ignoreAutoCommitExceptions=false
sequenceDescriptor=
]
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
ersistence
RE: Oracle OJB error
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::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=60,
>>testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300,
>>timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
>>
>> batchMode=false
>>
>> useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>>
>> ignoreAutoCommitExceptions=false
>>
>> sequenceDescriptor=
>>
>>]
>>
>>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)
>>
>>
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::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=60,
testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300,
timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
batchMode=false
useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
ignoreAutoCommitExceptions=false
sequenceDescriptor=
]
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]
RE: Oracle OJB error
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::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=60,
> testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300,
> timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
>
> batchMode=false
>
> useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>
> ignoreAutoCommitExceptions=false
>
> sequenceDescriptor=
>
> ]
>
> 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]
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::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=60,
testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300,
timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
batchMode=false
useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
ignoreAutoCommitExceptions=false
sequenceDescriptor=
]
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]
Oracle OJB error
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::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=60,
testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300,
timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
batchMode=false
useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
ignoreAutoCommitExceptions=false
sequenceDescriptor=
]
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
