Write NULL to Database

[stuermer_g]

Hi

I'm working with JBoss 3.0.4 in combination with MS SQL-Server 2000.

I've setted up the ConnectionManager and used CMP 2.0. It really works fine.

The Problem I have is that I has to write NULL into a Database-Column. When I try to write a Object(String) with value null it seems to work, but can I do it when I use a int or a double.
Is there a way to force the Container to execute a SQL-

Statement like this:
UPDATE table_1 set Value = null where sid = 1


Thanks
Gerhard

[stuermer_g]

I got the answer:

Just don't use primtive types like int, boolean, ..
Instead just use the Wrapper Classes Integer, Boolean and set them to null if you want to have NULL in the Database