Hi Thomas,
Please help me, no one replied me.
My quetion is as follows
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(OraclePreparedStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.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(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at
Test.main(Test.java:32)org.apache.ojb.broker.PersistenceBrokerSQLException[ODMG]
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(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(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)
Please help me.
Thanks with regards,
Dhamu
---------------------------------
Get a bigger mailbox -- choose a size that fits your needs.
