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?