Hi, don't think the reason for your problem is the <jdbc-connection-descriptor>. It seems more like a problem on the java side. Mayby it helps if you take a look at the actual sql that is sent to the database. p6spy included in the jakarta-ojb/lib is great for tracing the database traffic, because you can see the real values of the used bind variables.
Regards Max > -----Urspr�ngliche Nachricht----- > Von: Dhamodharan P [mailto:dhamubooks@;yahoo.co.uk] > Gesendet: Donnerstag, 7. November 2002 07:26 > An: OJB Users List > Betreff: Re: dbalias for oracle > > > > Dear all, > > Check my repository.xml file, is it valid for oracle Impl. > > <jdbc-connection-descriptor > platform="Oracle" > jdbc-level="2.0" > driver="oracle.jdbc.driver.OracleDriver" > protocol="jdbc" > subprotocol="oracle" > > dbalias="oci8:@(description=(address=(host=dhamu)(protocol=tcp > )(port=1521))(connect_data=(sid=tsmc)))" > username="dhamu" > password="dhamu"/> > > > > But i am facing the following error: > > java.sql.SQLException: ORA-01036: illegal variable name/number > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) > at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java) > at > oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess. > java) at > oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatem > ent.java)[org.apache.ojb.broker.accesslayer.JdbcAccess] > ERROR: SQLException during the execution of the query: > ORA-01036: illegal variable name/number > ORA-01036: illegal variable name/number > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle > Statement.java) at > oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecut > eUpdate(OraclePreparedStatement.java) at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl > ePreparedStatement.java) at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracle > PreparedStatement.java) at > org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unkn > own Source) at > org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIterat > orFromQuery(Unknown Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Unknown Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Unknown Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Unknown Source) at > org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) > at Test.main(Test.java:32)org.apache.ojb.br! > oker.PersistenceBrokerSQLException[ODMG] ERROR: null at > org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unkn > own Source) at > org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIterat > orFromQuery(Unknown Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Unknown Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Unknown Source) at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Unknown Source) at > org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) > at Test.main(Test.java:32)org.odmg.QueryException at > org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) > at Test.main(Test.java:32) > > > Thanks in advance > > Dhamu > > > > > --------------------------------- > Get a bigger mailbox -- choose a size that fits your needs. > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
