-------- Original Message --------
Subject: org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR
Date: Tue, 29 Oct 2002 11:11:02 +0800
From: "dhamu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Dear Sir,
I am working on jakarta OJB,ODMG and OQL with Oracle as a backend,i
am able to delete all records, by using the following code:
OQLQuery query = odmg.newOQLQuery();
String oqlQuery = "select del from " + AddFormForm.class.getName();
query.create(oqlQuery);
............
.........
......
But i want to delete specific record so i used the following:
String bindStr="5";
OQLQuery query = odmg.newOQLQuery();
String oqlQuery = "select del from " + AddFormForm.class.getName() + " where
id =$1";
query.create(oqlQuery);
query.bind(bindStr);
.........
.....
....
But it throwing following errors.
ava.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(OracleStatement.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(OracleStatement.java
) at
oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(Oracle
PreparedStatement.java) at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java) at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java) at
org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown Source) at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Un
known Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown
Source) at
Test.main(Test.java:32)org.apache.ojb.broker.PersistenceBrokerSQLException[O
DMG] ERROR: null at
org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown Source) at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Un
known Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known 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)
Please help me.
Thanks with regards,
Dhamu
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
