[OJB-developers] Re: PreparedStatement error with oracle

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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_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
> 
> 
> 
> ------=_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>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Oracle error (ORA-00911: invalid =
> character)=20
> when&nbsp;OJB issues a PreparedStatement for a referenced object. I =
> suppose the=20
> error means that Oracle&nbsp;wrongly interprets&nbsp;the character=20
> '?'.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</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>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Thanks for help,</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Joerg.</FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</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_CALENDARDATA.M=
> ONDAY,NS_CALENDARDATA.TUESDAY,NS_CALENDARDATA.WEDNESDAY,NS_CALENDARDATA.T=
> HURSDAY,NS_CALENDARDATA.FRIDAY,NS_CALENDARDATA.SATURDAY,NS_CALENDARDATA.S=
> UNDAY=20
> FROM NS_CALENDARDATA WHERE (NS_CALENDARDATA.CALENDARID =3D =
> ?)</FONT></DIV>
> <DIV>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>java.sql.SQLException: ORA-00911: =
> invalid=20
> character</FONT></DIV>
> <DIV>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>&nbsp;at=20
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)<BR>&nbsp=
> ;at=20
> oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)<BR>&nbsp;at=20
> oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)<BR>&nbsp;at=20
> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)<BR>&nbsp;at=
> =20
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:595)=
> <BR>&nbsp;at=20
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:16=
> 00)<BR>&nbsp;at=20
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)<B=
> R>&nbsp;at=20
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.j=
> ava:1807)<BR>&nbsp;at=20
> oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(Ora=
> clePreparedStatement.java:3191)<BR>&nbsp;at=20
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedSt=
> atement.java:354)<BR>&nbsp;at=20
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSta=
> tement.java:283)<BR>&nbsp;at=20
> ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:327)<=
> BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerIm=
> pl.java:1062)<BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Persistence=
> BrokerImpl.java:1169)<BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(Persistence=
> BrokerImpl.java:744)<BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReference(PersistenceBr=
> okerImpl.java:539)<BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceB=
> rokerImpl.java:512)<BR>&nbsp;at=20
> ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:=
> 269)<BR>&nbsp;at=20
> ojb.broker.accesslayer.RsIterator.next(RsIterator.java:153)<BR>&nbsp;at=20
> .......... (truncated)</FONT></DIV>
> <DIV>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>[ojb.broker.accesslayer.RsIterator] =
> ERROR:=20
> null<BR>ojb.broker.PersistenceBrokerSQLException<BR>&nbsp;at=20
> ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:356)<=
> BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerIm=
> pl.java:1062)<BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Persistence=
> BrokerImpl.java:1169)<BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(Persistence=
> BrokerImpl.java:744)<BR>&nbsp;at=20
> ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceB=
> rokerImpl.java:519)<BR>&nbsp;at=20
> ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:=
> 269)<BR>&nbsp;at=20
> ojb.broker.accesslayer.RsIterator.next(RsIterator.java:153)<BR>&nbsp;at=20
> ..........=20
> (truncated)<BR>java.util.NoSuchElementException<BR>java.util.NoSuchElemen=
> tException<BR>&nbsp;at=20
> ojb.broker.accesslayer.RsIterator.next(RsIterator.java:162)<BR>&nbsp;at=20
> .......... (truncated)</FONT></DIV>
> <DIV>&nbsp;</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>=
> &nbsp;</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
> 
> 