1 Reply Latest reply on Mar 29, 2004 3:06 PM by aloubyansky

    NOT NULL columns with default problem

    guix

      Hi:
      using Jboss 3.2.3 with Oracle OCI drievr for windows XP (latest version) on a 8.1.7 database, when I try to create a new entity I get the error:
      ORA-01400: cannot insert NULL into ("DB","TABLE","FIELD")
      Seems like Jboss is not aware of the fact that the field is not null but it has a default.
      Is there a way to tell jboss that if I don't pass a value for this field its should take it out of the create sql?

      Cheers
      Guix