Hibernate...erro no insert ...could not insert:

Olá ,

está me dando esse erro no hora do insert o que será???

abs

– web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>
     <servlet>
          <servlet-name>cadastra</servlet-name>
          <servlet-class>br.com.wincomp.projeto.servlet.IncluirAlunos</servlet-class>
     </servlet>

     <servlet-mapping>
              <servlet-name>cadastra</servlet-name>
              <url-pattern>/cadastra</url-pattern>
     </servlet-mapping>


</web-app>


package br.com.wincomp.projeto.servlet;
import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import br.com.wincomp.projeto.bean.Alunos;

public class IncluirAlunos extends HttpServlet {
    /**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException , IOException {

           PrintWriter output = response.getWriter();

           output.println("<html>");
           output.println("<body>");

      try  {

           
           String nome         = request.getParameter("nome");
           String endereco     = request.getParameter("endereco");
           String cep          = request.getParameter("cep");
           String cidade       = request.getParameter("cidade");
           String estado       = request.getParameter("estado");
           String pais         = request.getParameter("pais");
           
           Alunos  aluno = new Alunos();
           
           aluno.setNome(nome);
           aluno.setEndereco(endereco);
           aluno.setCep(cep);
           aluno.setCidade(cidade);
           aluno.setEstado(estado);
           aluno.setPais(pais);

           //
		   SessionFactory sf;
		   sf = new Configuration().configure("br/com/wincomp/projeto/bean/hibernate.cfg.xml").buildSessionFactory();
		   //sf = new Configuration().configure().buildSessionFactory();
		   Session s = sf.openSession(); // abre session
		   Transaction  tx = s.beginTransaction(); //cria transação
		   s.save(aluno);
		  //s.saveOrUpdate(aluno);
		   tx.commit();
		   s.close();
           
           //
		   
           output.println("<font color=blue>");
           output.println("Operação Relalizada com Sucesso ....");
           output.println("</font>");
      }
      

      catch (Exception ex) {
           output.println(ex.getMessage());
      	   ex.printStackTrace();
           
      }
      output.println("&lt;/body&gt;");
      output.println("&lt;/html&gt;&quot;);
      output.close();


    }
}

–bean

public class Alunos {

	int idaluno;
	String nome;
	String endereco;
	String cep;
	String cidade;
	String estado;
	String pais;
	
	public Alunos(){
	}
	
	public int getIdaluno() {
		return idaluno;
	}
	public void setIdaluno(int idaluno) {
		this.idaluno = idaluno;
	}
	public String getNome() {
		return nome;
	}
	public void setNome(String nome) {
		this.nome = nome;
	}
	public String getEndereco() {
		return endereco;
	}
	public void setEndereco(String endereco) {
		this.endereco = endereco;
	}
	public String getCep() {
		return cep;
	}
	public void setCep(String cep) {
		this.cep = cep;
	}
	public String getCidade() {
		return cidade;
	}
	public void setCidade(String cidade) {
		this.cidade = cidade;
	}
	public String getEstado() {
		return estado;
	}
	public void setEstado(String estado) {
		this.estado = estado;
	}
	public String getPais() {
		return pais;
	}
	public void setPais(String pais) {
		this.pais = pais;
	}
	
	
}

–Alunos.hbm.xml

&lt;?xml version='1.0' encoding='utf-8'?&gt;  
    &lt;!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping.dtd"&gt;  
    &lt;hibernate-mapping&gt;  
        &lt;class name="br.com.wincomp.projeto.bean.Alunos" table="alunos"&gt;  
            &lt;id name="idaluno" column="idaluno" type="int"&gt;  
                &lt;generator class="native"/&gt;  
            &lt;/id&gt;  
            &lt;property name="nome" column="nome" type="string"/&gt;
            &lt;property name="endereco" column="endereco" type="string"/&gt;
            &lt;property name="cep"  column="cep" type="string" /&gt;
            &lt;property name="cidade" column="cidade" type="string"/&gt;     
            &lt;property name="estado"/&gt;
            &lt;property name="pais" column="pais" type="string"/&gt;  
        &lt;/class&gt;  
     &lt;/hibernate-mapping&gt;  

–hibernate

&lt;?xml version='1.0' encoding='utf-8'?&gt;  

    &lt;!DOCTYPE hibernate-configuration PUBLIC  
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"  
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"&gt;  
      
    &lt;hibernate-configuration&gt;  
      &lt;session-factory&gt;  
      &lt;!-- Database connection settings --&gt;  
        
         &lt;property name="connection.driver_class"&gt;com.mysql.jdbc.Driver&lt;/property&gt;  
         &lt;property name="connection.url"&gt;jdbc:mysql://127.0.0.1:3306/loja&lt;/property&gt;  
         &lt;property name="connection.username"&gt;root&lt;/property&gt;
		 &lt;property name="connection.password"&gt;paribe&lt;/property&gt;	        
		 &lt;!-- JDBC connection pool (use the built-in) --&gt;  
         &lt;property name="connection.pool_size"&gt;1&lt;/property&gt;    
		 &lt;!-- SQL dialect --&gt;  
		&lt;property name="dialect"&gt;org.hibernate.dialect.MySQLDialect&lt;/property&gt;
        
        &lt;property name="current_session_context_class"&gt;thread&lt;/property&gt;
       
        &lt;property name="cache.provider_class"&gt;org.hibernate.cache.NoCacheProvider&lt;/property&gt;
        &lt;property name="show_sql"&gt;false&lt;/property&gt;
          
         &lt;mapping resource ="br/com/wincomp/projeto/bean/Alunos.hbm.xml"/&gt;         
           
           
     &lt;/session-factory&gt;  
   &lt;/hibernate-configuration&gt;  
   
  

02/01/2008 15:16:10 org.apache.catalina.core.AprLifecycleListener init
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Arquivos de programas\Java\jdk1.5.0_12\bin;.;C:\WINNT\system32;C:\WINNT;C:\Arquivos de programas\Java\jdk1.5.0_12\bin\..\jre\bin\client;C:\Arquivos de programas\Java\jdk1.5.0_12\bin\..\jre\bin;C:\Arquivos de programas\CA\SharedComponents\PEC\bin;C:\Arquivos de programas\Java\jdk1.5.0_12\bin;C:\Apps\ant\bin;C:\Oracle\Product\DSG6i\bin;C:\Oracle\Product\9.2.0\bin;C:\Oracle\Product\OWB903\bin;C:\Arquivos de programas\Oracle\jre\1.1.8\bin;C:\Arquivos de programas\Oracle\jre\1.3.1\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Oracle\Product\DSG6i\jdk\bin;C:\Oracle\Product\DSG6i\REPADM61\jre1_4\bin;C:\Oracle\Product\DSG6i\REPADM61\jre1_4\bin\client;C:\Arquivos de programas\CA\CCC_Harvest;c:\winnt\system32;C:\Arquivos de programas\CA\Cryptography\;C:\Arquivos de programas\CA\AllFusion Harvest Change Manager
02/01/2008 15:16:10 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
02/01/2008 15:16:10 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1500 ms
02/01/2008 15:16:10 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
02/01/2008 15:16:10 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.14
02/01/2008 15:16:12 org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(C:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\licao1\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
02/01/2008 15:16:22 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
02/01/2008 15:16:22 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
02/01/2008 15:16:22 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/125  config=null
02/01/2008 15:16:22 org.apache.catalina.startup.Catalina start
INFO: Server startup in 11897 ms
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.exception.ConstraintViolationException: could not insert: [br.com.wincomp.projeto.bean.Alunos]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
	at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
	at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
	at br.com.wincomp.projeto.servlet.IncluirAlunos.service(IncluirAlunos.java:55)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'cep' cannot be null
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1012)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
	... 29 more
02/01/2008 15:18:52 org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
02/01/2008 15:18:53 org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(C:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\licao1\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.InvalidMappingException: Could not parse mapping document from resource br/com/wincomp/projeto/bean/Alunos.hbm.xml
	at org.hibernate.cfg.Configuration.addResource(Configuration.java:569)
	at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1587)
	at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1555)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1534)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1508)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1428)
	at br.com.wincomp.projeto.servlet.IncluirAlunos.service(IncluirAlunos.java:51)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.InvalidMappingException: Could not parse mapping document from input stream
	at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:508)
	at org.hibernate.cfg.Configuration.addResource(Configuration.java:566)
	... 19 more
Caused by: org.dom4j.DocumentException: Invalid byte 1 of 1-byte UTF-8 sequence. Nested exception: Invalid byte 1 of 1-byte UTF-8 sequence.
	at org.dom4j.io.SAXReader.read(SAXReader.java:484)
	at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:499)
	... 20 more
02/01/2008 15:24:36 org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already.  Could not load java.net.BindException.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1244)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
	at com.mysql.jdbc.SQLError.createLinkFailureMessageBasedOnHeuristics(SQLError.java:1211)
	at com.mysql.jdbc.CommunicationsException.&lt;init&gt;(CommunicationsException.java:53)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3134)
	at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:1616)
	at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4223)
	at com.mysql.jdbc.ConnectionImpl.cleanup(ConnectionImpl.java:1257)
	at com.mysql.jdbc.ConnectionImpl.finalize(ConnectionImpl.java:2663)
	at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
	at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
	at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
	at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)

esqueci da tabela…

DROP TABLE IF EXISTS loja.alunos;
CREATE TABLE loja.alunos (
idaluno int(10) unsigned NOT NULL auto_increment,
nome varchar(45) NOT NULL,
endereco varchar(45) NOT NULL,
cep varchar(45) NOT NULL,
cidade varchar(45) NOT NULL,
estado varchar(45) NOT NULL,
pais varchar(45) NOT NULL,
PRIMARY KEY (idaluno)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Fui direto ao stack trace e vi o seguinte:

Não acredito q vc teve a capacidade de duplicar seu próprio post !!!

:?

Já disse.
O cep está chegando nulo.

Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'cep' cannot be null  

Obrigado …pela ajuda…

deu certo …