How does PreparedStatement.setObject() API behaves with null value?
posted 11 years ago
How does PreparedStatement.setObject() API behaves with null value? For e.g. If i have
would the null passed in setObject is tranlated as SQL data type Null always? or do i have to use setNull() API? JDBC 3.0 spec says that,
(section 13.2.2) a value must be provided (setXXX()). if the value is not set, then a SQLException should be thrown.
Is this enforced in JDBC 2.0 also? I could not get documentation abt this for JDBC 2.0...so i am doubtful. when i run this code, it works fine sometimes. however, sometimes i get, java.sql.SQLException: ORA-01475: must reparse cursor to change bind variable datatype this behavior is random. so i am doubtful abt the behavior of setObject() Can anybody exaplin this?