0 Replies Latest reply on Jun 17, 2004 12:13 PM by caesarkim

    error message : column can't be null.

    caesarkim Newbie

      java.sql.SQLException: General error, message from server: "Column 'client' cannot be null"

      this is what i got from local ejb entity bean implementation.
      this is my deployment descriptor.
      <abstract-schema-name>MAIN_PROJECT</abstract-schema-name>
      <cmp-field><field-name>id</field-name></cmp-field>
      <cmp-field><field-name>client</field-name></cmp-field>
      <cmp-field><field-name>projectOwner</field-name></cmp-field>
      <cmp-field><field-name>createDate</field-name></cmp-field>
      <cmp-field><field-name>lastChange</field-name></cmp-field>
      <primkey-field>id</primkey-field>




      here is my code..
      jndiContext = new InitialContext();
      Object mainObject = (Object) jndiContext.lookup("jndi/LocalMainProject");
      MainProjectLocalHome mainHome = (MainProjectLocalHome)mainObject;
      MainProjectLocal main = mainHome.create(new Integer(13));
      main.setClient("nyc");
      main.setAdministratorId(new Integer(1));
      main.setProjectOwner("caesar");
      main.setCreateDate(new java.sql.Date(System.currentTimeMillis()));
      main.setLastChange(new java.sql.Date(System.currentTimeMillis()));


      even though these setter methods are defined in local interface and defined as abstract in entity bean, it keeps saying that "java.sql.SQLException: General error, message from server: "Column 'client' cannot be null"".

      it looks really weird to me... anybody has any idea?