[OJB-developers] PreparedStatement error with oracle

[Joerg M. <joe...@gm...>]

Hi all,
My application worked fine with version 0.7.327. I get these problems =
since I updated to 0.8.400:

Oracle error (ORA-00911: invalid character) when OJB issues a =
PreparedStatement for a referenced object. I suppose the error means =
that Oracle wrongly interprets the character '?'.


My environment is: Win2000, JDK 1.3, Oracle 8.1, Thin-JDBC =
(classes12_01.zip)
Below is a the stack trace...

Thanks for help,
Joerg.=20


...... (truncated)
[ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT =
NS_CALENDARDATA.CALENDARID,NS_CALENDARDATA.CALENDARNAME,NS_CALENDARDATA.M=
ONDAY,NS_CALENDARDATA.TUESDAY,NS_CALENDARDATA.WEDNESDAY,NS_CALENDARDATA.T=
HURSDAY,NS_CALENDARDATA.FRIDAY,NS_CALENDARDATA.SATURDAY,NS_CALENDARDATA.S=
UNDAY FROM NS_CALENDARDATA WHERE (NS_CALENDARDATA.CALENDARID =3D ?)

java.sql.SQLException: ORA-00911: invalid character

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
 at =
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:595)=

 at =
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:16=
00)
 at =
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
 at =
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.j=
ava:1807)
 at =
oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(Ora=
clePreparedStatement.java:3191)
 at =
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedSt=
atement.java:354)
 at =
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSta=
tement.java:283)
 at =
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:327)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerIm=
pl.java:1062)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Persistence=
BrokerImpl.java:1169)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(Persistence=
BrokerImpl.java:744)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReference(PersistenceBr=
okerImpl.java:539)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceB=
rokerImpl.java:512)
 at =
ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:=
269)
 at ojb.broker.accesslayer.RsIterator.next(RsIterator.java:153)
 at .......... (truncated)

[ojb.broker.accesslayer.RsIterator] ERROR: null
ojb.broker.PersistenceBrokerSQLException
 at =
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:356)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerIm=
pl.java:1062)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Persistence=
BrokerImpl.java:1169)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(Persistence=
BrokerImpl.java:744)
 at =
ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceB=
rokerImpl.java:519)
 at =
ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:=
269)
 at ojb.broker.accesslayer.RsIterator.next(RsIterator.java:153)
 at .......... (truncated)
java.util.NoSuchElementException
java.util.NoSuchElementException
 at ojb.broker.accesslayer.RsIterator.next(RsIterator.java:162)
 at .......... (truncated)

[ojb.broker.singlevm.PersistenceBrokerImpl] ERROR: expected type: class =
it.nch.ness.network.core.CalendarData