Insert database NULL

[visu Nekk]

Hi,

In Java, if we encounter any null values, it gets inserted into the database as null. But the Oracle database null type is NULL. Can we insert database specific null while inserting itself from Java.

Regards,
Visu Nekk

[Shailesh Chandra]

Originally posted by visu Nekk:
Hi,

In Java, if we encounter any null values, it gets inserted into the database as null.

Do you mean null is inserted as string or you mean something else ?

I think somewhere in your code you are converting your variable to a string as 'null'.

Can we insert database specific null while inserting itself from Java.

Yes, you can directly use setNull method of preparedstatement.

Shailesh
[ November 11, 2008: Message edited by: Shailesh Chandra ]