I am using hibernate 3, following is a hql that I am using for update

query = session.createQuery("update myTable set field1 =?, field2 = ? where id=?");
query.setParameters (0, value1);
query.setParameters(1, 'value2);
query.setParameters(2, idValue);

The field1 type in db is numeric and the problem is that when value1 is a java null pointer, hibernate throws exception like this:

Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)
at org.hibernate.hql.ast.UpdateStatementExecutor.execute(UpdateStatementExecutor.java:76)


My question is that What's the right value for database NULL in HQL?

Thanks

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

It is the best that use classes (BigDecimal,Integer,Long) instead primitive for number datatype

I have tried it ... but it doesnt work for me... any other ideas that you think could work .... plz i need to get it work very badly...

I have this problen when I use Oracle.

in this HQL:

from entity e
where
:userOID in elements(e.operators)

if "userOID" is null returns: ORA-00932: inconsistent datatypes: expected BINARY got NUMBER

Hibernate sets the parameter as serialized type.

tks!