This looks like a type-mismatch:
bindStr is a String.
"id" sounds like a Numeric value.
Please try to bind
Integer bindInt = new Integer(5);
against you r parameter.
cheers,
Thomas
Dhamodharan P wrote:
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.
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
