posted 19 years ago
I have a query
select * from vma where status=?
now when I create a preparedstatement for this query and then set null
like
pstmt.setNull(1,java.sql.Types.VARCHAR);
executing this query returns an empty result set
where as if I directly run a query like
select * from vma where status is null
this is returning many records
Is the preparedstatment behaviour correct? shouldn't it correspond to the same query?
Any help is appreciated
Regards
Monmohan