Pessoal estou utilizando um banco MySQL e nele tenho uma tabela com alguns campos NOT NULL. Crie um entity bean e quando vou inserir os dados seto todos os valores e passo o objeto parao método create… o campo que ele diz estar recebendo null nao está… e a msg de erro é essa:
java.rmi.ServerException: EJBException:; nested exception is: javax.ejb.EJBException: Could not create entity:java.sql.SQLException: Column 'cpf' cannot be null
O meu jbosscmp-jdbc.xml esta assim:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">
<jbosscmp-jdbc>
<defaults>
<datasource>java:ControlDs</datasource>
<datasource-mapping>mySQL</datasource-mapping>
<create-table>false</create-table>
<remove-table>false</remove-table>
<pk-constraint>true</pk-constraint>
</defaults>
<enterprise-beans>
<entity>
<ejb-name>Funcionario</ejb-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<table-name>funcionario</table-name>
<cmp-field>
<field-name>idFuncionario</field-name>
<column-name>idFuncionario</column-name>
</cmp-field>
<cmp-field>
<field-name>cpf</field-name>
<column-name>cpf</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>nome</field-name>
<column-name>nome</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>endereco</field-name>
<column-name>endereco</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>estado</field-name>
<column-name>estado</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>cidade</field-name>
<column-name>cidade</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>cep</field-name>
<column-name>cep</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>sexo</field-name>
<column-name>sexo</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>dtNascimento</field-name>
<column-name>dtNascimento</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>cargo</field-name>
<column-name>cargo</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>foneResidencial</field-name>
<column-name>foneResidencial</column-name>
</cmp-field>
<cmp-field>
<field-name>foneCelular</field-name>
<column-name>foneCelular</column-name>
</cmp-field>
<cmp-field>
<field-name>email</field-name>
<column-name>email</column-name>
</cmp-field>
<cmp-field>
<field-name>dtAdmissao</field-name>
<column-name>dtAdmissao</column-name>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>dtDesligamento</field-name>
<column-name>dtDesligamento</column-name>
</cmp-field>
<cmp-field>
<field-name>usuario</field-name>
<column-name>usuario</column-name>
</cmp-field>
<unknown-pk>
<unknown-pk-class>java.lang.Integer</unknown-pk-class>
<field-name>idFuncionario</field-name>
<read-only>true</read-only>
<column-name>idFuncionario</column-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INT</sql-type>
<auto-increment />
</unknown-pk>
<entity-command name="mysql-get-generated-keys" />
</entity>
</enterprise-beans>
</jbosscmp-jdbc>