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
|
