1 Reply Latest reply on Dec 11, 2002 11:26 AM by Gerhard Stürmer

    Write NULL  to Database

    Gerhard Stürmer Newbie

      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