2 Replies Latest reply on Jun 8, 2006 3:42 AM by oyabun

    How to choose Oracle DEFAULT value over NULL value?

    oyabun

      Hi,

      I want JBoss to insert the DEFAULT value into MYCOLUMN. If I don't set the MYCOLUMN variable to some value, JBoss will want to INSERT NULL into the table. Is there a way to tell JBoss that I want the DEFAULT value inserted, the one that comes with the Oracle CREATE statement?

      for example:

      CREATE TABLE SPIELKONTO
      (
      ...
      ...
      MYCOLUMN NNUMBER(10) DEFAULT 1 NOT NULL,
      ...
      ...
      )


      Thanks,
      Alex