[OJB-developers] RE: PreparedStatement error with oracle
Brought to you by:
thma
Menu
▾
▴
[OJB-developers] RE: PreparedStatement error with oracle
|
From: Joerg M. <joe...@gm...> - 2002-05-13 15:23:49
|
Ranjan, this solved the problem! Thank you very much, Jörg. > -----Original Message----- > From: Ranjan Bagchi [mailto:ran...@fr...] > Sent: Monday, May 13, 2002 3:02 PM > To: obj...@li... > Cc: Joerg Mattes > Subject: Re: PreparedStatement error with oracle > > > Joerg, > > I was running into the same error (ORA-0911). I found that my > respository.xml had the following: > > <JdbcConnectionDescriptor id="default"> > <dbms.name>oracle</dbms.name> > [...] > > When changing it to > <JdbcConnectionDescriptor id="default"> > <dbms.name>Oracle</dbms.name> > [..] > > (i.e. capitalizing Oracle) fixed it. > > Hope this helps, > > Ranjan > > > Message: 10 > > From: "Joerg Mattes" <joe...@gm...> > > To: <obj...@li...> > > Date: Mon, 13 May 2002 14:06:57 +0200 > > Subject: [OJB-developers] PreparedStatement error with oracle > > > > This is a multi-part message in MIME format. > > > > ------=_NextPart_000_001D_01C1FA87.7153C990 > > Content-Type: text/plain; > > charset="iso-8859-1" > > Content-Transfer-Encoding: quoted-printable > > > > 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_CAL > ENDARDATA.M= > > > ONDAY,NS_CALENDARDATA.TUESDAY,NS_CALENDARDATA.WEDNESDAY,NS_CAL > ENDARDATA.T= > > > HURSDAY,NS_CALENDARDATA.FRIDAY,NS_CALENDARDATA.SATURDAY,NS_CAL > ENDARDATA.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(TTC7Protoco > l.java:595)= > > > > at = > > > oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatem > ent.java:16= > > 00) > > at = > > > oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.j > ava:1758) > > at = > > > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle > Statement.j= > > ava:1807) > > at = > > > oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecut > eUpdate(Ora= > > clePreparedStatement.java:3191) > > at = > > > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl > ePreparedSt= > > atement.java:354) > > at = > > > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracle > PreparedSta= > > tement.java:283) > > at = > > > ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess > .java:327) > > at = > > > ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Persiste > nceBrokerIm= > > 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(Pe > rsistenceBr= > > okerImpl.java:539) > > at = > > > ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(P > ersistenceB= > > rokerImpl.java:512) > > at = > > > ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIte > rator.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(Persiste > nceBrokerIm= > > 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(P > ersistenceB= > > rokerImpl.java:519) > > at = > > > ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIte > rator.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 > > > > > > > > ------=_NextPart_000_001D_01C1FA87.7153C990 > > Content-Type: text/html; > > charset="iso-8859-1" > > Content-Transfer-Encoding: quoted-printable > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > > <HTML><HEAD> > > <META http-equiv=3DContent-Type content=3D"text/html; = > > charset=3Diso-8859-1"> > > <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR> > > <STYLE></STYLE> > > </HEAD> > > <BODY bgColor=3D#ffffff> > > <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> > > <DIV><FONT face=3DArial size=3D2>My application worked fine > with version = > > 0.7.327. I=20 > > get these problems since I updated to 0.8.400:</FONT></DIV> > > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > > <DIV><FONT face=3DArial size=3D2>Oracle error (ORA-00911: invalid = > > character)=20 > > when OJB issues a PreparedStatement for a referenced > object. I = > > suppose the=20 > > error means that Oracle wrongly interprets the > character=20 > > '?'.</FONT></DIV> > > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > > <DIV><FONT face=3DArial size=3D2>My environment is: > Win2000, JDK 1.3, = > > Oracle 8.1,=20 > > Thin-JDBC (classes12_01.zip)</FONT></DIV> > > <DIV><FONT face=3DArial size=3D2>Below is a the stack = > > trace...</FONT></DIV> > > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > > <DIV><FONT face=3DArial size=3D2>Thanks for help,</FONT></DIV> > > <DIV><FONT face=3DArial size=3D2>Joerg.</FONT> </DIV> > > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > > <DIV><FONT face=3DArial size=3D2>...... (truncated)</FONT></DIV> > > <DIV><FONT face=3DArial > size=3D2>[ojb.broker.accesslayer.SqlGenerator] = > > DEBUG: SQL:=20 > > SELECT=20 > > > NS_CALENDARDATA.CALENDARID,NS_CALENDARDATA.CALENDARNAME,NS_CAL > ENDARDATA.M= > > > ONDAY,NS_CALENDARDATA.TUESDAY,NS_CALENDARDATA.WEDNESDAY,NS_CAL > ENDARDATA.T= > > > HURSDAY,NS_CALENDARDATA.FRIDAY,NS_CALENDARDATA.SATURDAY,NS_CAL > ENDARDATA.S= > > UNDAY=20 > > FROM NS_CALENDARDATA WHERE (NS_CALENDARDATA.CALENDARID =3D = > > ?)</FONT></DIV> > > <DIV> </DIV> > > <DIV><FONT face=3DArial size=3D2>java.sql.SQLException: ORA-00911: = > > invalid=20 > > character</FONT></DIV> > > <DIV> </DIV> > > <DIV><FONT face=3DArial size=3D2> at=20 > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:11 > 4)<BR> = > > ;at=20 > > oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)<BR> at=20 > > oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)<BR> at=20 > > > oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)< > BR> at= > > =20 > > > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protoco > l.java:595)= > > <BR> at=20 > > > oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatem > ent.java:16= > > 00)<BR> at=20 > > > oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.j > ava:1758)<B= > > R> at=20 > > > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle > Statement.j= > > ava:1807)<BR> at=20 > > > oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecut > eUpdate(Ora= > > clePreparedStatement.java:3191)<BR> at=20 > > > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl > ePreparedSt= > > atement.java:354)<BR> at=20 > > > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracle > PreparedSta= > > tement.java:283)<BR> at=20 > > > ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess > .java:327)<= > > BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Persiste > nceBrokerIm= > > pl.java:1062)<BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity( > Persistence= > > BrokerImpl.java:1169)<BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject( > Persistence= > > BrokerImpl.java:744)<BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReference(Pe > rsistenceBr= > > okerImpl.java:539)<BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(P > ersistenceB= > > rokerImpl.java:512)<BR> at=20 > > > ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIte > rator.java:= > > 269)<BR> at=20 > > > ojb.broker.accesslayer.RsIterator.next(RsIterator.java:153)<BR > > at=20 > > .......... (truncated)</FONT></DIV> > > <DIV> </DIV> > > <DIV><FONT face=3DArial > size=3D2>[ojb.broker.accesslayer.RsIterator] = > > ERROR:=20 > > null<BR>ojb.broker.PersistenceBrokerSQLException<BR> at=20 > > > ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess > .java:356)<= > > BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Persiste > nceBrokerIm= > > pl.java:1062)<BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity( > Persistence= > > BrokerImpl.java:1169)<BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject( > Persistence= > > BrokerImpl.java:744)<BR> at=20 > > > ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(P > ersistenceB= > > rokerImpl.java:519)<BR> at=20 > > > ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIte > rator.java:= > > 269)<BR> at=20 > > > ojb.broker.accesslayer.RsIterator.next(RsIterator.java:153)<BR > > at=20 > > ..........=20 > > > (truncated)<BR>java.util.NoSuchElementException<BR>java.util.N > oSuchElemen= > > tException<BR> at=20 > > > ojb.broker.accesslayer.RsIterator.next(RsIterator.java:162)<BR > > at=20 > > .......... (truncated)</FONT></DIV> > > <DIV> </DIV> > > <DIV><FONT face=3DArial = > > size=3D2>[ojb.broker.singlevm.PersistenceBrokerImpl] ERROR:=20 > > expected type: class = > > it.nch.ness.network.core.CalendarData<BR></FONT></DIV> > > <DIV><FONT face=3DArial size=3D2><A=20 > > > href=3D"mailto:obj...@li..."> > </A></FONT>= > > </DIV></BODY></HTML> > > > > ------=_NextPart_000_001D_01C1FA87.7153C990-- > > > > > > > > > > --__--__-- > > > > _______________________________________________ > > Objectbridge-developers mailing list > > Obj...@li... > > https://lists.sourceforge.net/lists/listinfo/objectbridge-developers > > > > > > End of Objectbridge-developers Digest > > > > > |
