Campo Not null no banco

0 respostas
A

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"?>
&lt;!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd"&gt;
&lt;jbosscmp-jdbc&gt;
  &lt;defaults&gt;
    &lt;datasource&gt;java:ControlDs&lt;/datasource&gt;
    &lt;datasource-mapping&gt;mySQL&lt;/datasource-mapping&gt;
    &lt;create-table&gt;false&lt;/create-table&gt;
    &lt;remove-table&gt;false&lt;/remove-table&gt;
    &lt;pk-constraint&gt;true&lt;/pk-constraint&gt;
  &lt;/defaults&gt;
  &lt;enterprise-beans&gt;
    &lt;entity&gt;
      &lt;ejb-name&gt;Funcionario&lt;/ejb-name&gt;
      &lt;create-table&gt;false&lt;/create-table&gt;
      &lt;remove-table&gt;false&lt;/remove-table&gt;
      &lt;table-name&gt;funcionario&lt;/table-name&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;idFuncionario&lt;/field-name&gt;
        &lt;column-name&gt;idFuncionario&lt;/column-name&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;cpf&lt;/field-name&gt;
        &lt;column-name&gt;cpf&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;nome&lt;/field-name&gt;
        &lt;column-name&gt;nome&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;endereco&lt;/field-name&gt;
        &lt;column-name&gt;endereco&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;estado&lt;/field-name&gt;
        &lt;column-name&gt;estado&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;cidade&lt;/field-name&gt;
        &lt;column-name&gt;cidade&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;cep&lt;/field-name&gt;
        &lt;column-name&gt;cep&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;sexo&lt;/field-name&gt;
        &lt;column-name&gt;sexo&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;dtNascimento&lt;/field-name&gt;
        &lt;column-name&gt;dtNascimento&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;cargo&lt;/field-name&gt;
        &lt;column-name&gt;cargo&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;foneResidencial&lt;/field-name&gt;
        &lt;column-name&gt;foneResidencial&lt;/column-name&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;foneCelular&lt;/field-name&gt;
        &lt;column-name&gt;foneCelular&lt;/column-name&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;email&lt;/field-name&gt;
        &lt;column-name&gt;email&lt;/column-name&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;dtAdmissao&lt;/field-name&gt;
        &lt;column-name&gt;dtAdmissao&lt;/column-name&gt;
        &lt;not-null/&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;dtDesligamento&lt;/field-name&gt;
        &lt;column-name&gt;dtDesligamento&lt;/column-name&gt;
      &lt;/cmp-field&gt;
      &lt;cmp-field&gt;
        &lt;field-name&gt;usuario&lt;/field-name&gt;
        &lt;column-name&gt;usuario&lt;/column-name&gt;
      &lt;/cmp-field&gt;
      &lt;unknown-pk&gt;
        &lt;unknown-pk-class&gt;java.lang.Integer&lt;/unknown-pk-class&gt;
        &lt;field-name&gt;idFuncionario&lt;/field-name&gt;
        &lt;read-only&gt;true&lt;/read-only&gt;
        &lt;column-name&gt;idFuncionario&lt;/column-name&gt;
        &lt;jdbc-type&gt;INTEGER&lt;/jdbc-type&gt;
        &lt;sql-type&gt;INT&lt;/sql-type&gt;
        &lt;auto-increment /&gt;
      &lt;/unknown-pk&gt;
      &lt;entity-command name="mysql-get-generated-keys" /&gt;
    &lt;/entity&gt;
  &lt;/enterprise-beans&gt;
&lt;/jbosscmp-jdbc&gt;
Criado 17 de maio de 2005
Respostas 0
Participantes 1