Duvidas com Hibernate.[RESOLVIDO]

Ace · Setembro 20, 2010, 2:18pm

Boa tarde Pessoal,
Preciso fazer uma listagem simples, ao meu banco de dados utilizando Hibernate, tenho minhas classes, Dao, e a de teste.
meu hibernate.xml tbm esta configurado certo acredito eu. Porem essa listagem está me dando erro.

Exception in thread "main" java.lang.NullPointerException at br.com.dao.FuncionarioDao.buscaFuncionario(FuncionarioDao.java:27) at br.com.teste.TestaPesquisaILike.main(TestaPesquisaILike.java:19)

Seguem as classes…


package br.com.dao;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

import br.com.model.Funcionario;

public class FuncionarioDao extends Dao<Funcionario> {
	
	private Session session;
	
	public FuncionarioDao(Session session){
		super (session, Funcionario.class);
		}	
	
	
  public Funcionario lista(String nome){
		return (Funcionario) this.session.load(Funcionario.class, nome);
	}
	
  	@SuppressWarnings("unchecked")
	public List<Funcionario> buscaFuncionario(String nome){
		Criteria c = getSession().createCriteria(Funcionario.class);
		c.add(Restrictions.ilike("nome", nome));
		c.addOrder(Order.asc("email"));
		return c.list();
	}
	
	protected Session getSession(){		
		return session;
	}	
	
	

}

[code]package br.com.teste;

import java.util.List;

import org.hibernate.Session;

import br.com.dao.FuncionarioDao;
import br.com.hibernateUtil.HibernateUtil;
import br.com.model.Funcionario;

public class TestaPesquisaILike {

public static void main(String[] args) {
    
    Session s = new HibernateUtil().getSession();
    
    FuncionarioDao funDao = new FuncionarioDao(s);        

    List<Funcionario> listaFun = funDao.buscaFuncionario("k%");
    for (Funcionario f :  listaFun){        
        System.out.println(f.getNome());
    }

}

}[/code]


<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory>
		
		<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
		<property name="hibernate.c3p0.min_size">20</property>
        <property name="hibernate.c3p0.max_size">75</property>
        <property name="hibernate.c3p0.timeout">180</property>
        <property name="hibernate.c3p0.idle_test_period">100</property>		
		
	
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://localhost/teste</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">123456</property>
		
		<property name="hibernate.show_sql">true</property>
		<property name="hibernate.format_sql">true</property>
		
		<mapping class="br.com.model.Funcionario" />
		<mapping class="br.com.model.Fornecedor" />
		<mapping class="br.com.model.ContaPagar" />
		
	</session-factory>
</hibernate-configuration>

Alguem pode me dar uma força…vlw

abras

Ace · Setembro 20, 2010, 2:19pm

[quote=Ace]Boa tarde Pessoal,
Preciso fazer uma listagem simples, ao meu banco de dados utilizando Hibernate, tenho minhas classes, Dao, e a de teste.
meu hibernate.xml tbm esta configurado certo acredito eu. Porem essa listagem está me dando erro.

Exception in thread "main" java.lang.NullPointerException at br.com.dao.FuncionarioDao.buscaFuncionario(FuncionarioDao.java:27) at br.com.teste.TestaPesquisaILike.main(TestaPesquisaILike.java:19)

Seguem as classes…


package br.com.dao;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

import br.com.model.Funcionario;

public class FuncionarioDao extends Dao<Funcionario> {
	
	private Session session;
	
	public FuncionarioDao(Session session){
		super (session, Funcionario.class);
		}	
	
	
  public Funcionario lista(String nome){
		return (Funcionario) this.session.load(Funcionario.class, nome);
	}
	
  	@SuppressWarnings("unchecked")
	public List<Funcionario> buscaFuncionario(String nome){
		Criteria c = getSession().createCriteria(Funcionario.class);
		c.add(Restrictions.ilike("nome", nome));
		c.addOrder(Order.asc("email"));
		return c.list();
	}
	
	protected Session getSession(){		
		return session;
	}	
	
	

}

[code]package br.com.teste;

import java.util.List;

import org.hibernate.Session;

import br.com.dao.FuncionarioDao;
import br.com.hibernateUtil.HibernateUtil;
import br.com.model.Funcionario;

public class TestaPesquisaILike {

public static void main(String[] args) {
    
    Session s = new HibernateUtil().getSession();
    
    FuncionarioDao funDao = new FuncionarioDao(s);        

    List<Funcionario> listaFun = funDao.buscaFuncionario("k%");
    for (Funcionario f :  listaFun){        
        System.out.println(f.getNome());
    }

}

}[/code]


<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory>
		
		<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
		<property name="hibernate.c3p0.min_size">20</property>
        <property name="hibernate.c3p0.max_size">75</property>
        <property name="hibernate.c3p0.timeout">180</property>
        <property name="hibernate.c3p0.idle_test_period">100</property>		
		
	
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://localhost/teste</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">123456</property>
		
		<property name="hibernate.show_sql">true</property>
		<property name="hibernate.format_sql">true</property>
		
		<mapping class="br.com.model.Funcionario" />
		<mapping class="br.com.model.Fornecedor" />
		<mapping class="br.com.model.ContaPagar" />
		
	</session-factory>
</hibernate-configuration>

Alguem pode me dar uma força…vlw

abras[/quote]

OBS: Meu BD não está NULO.

romarcio · Setembro 20, 2010, 2:34pm

Aparece o SQL da consulta no console ?

Se sim, pega ele e testa no banco de dados.

Ace · Setembro 20, 2010, 2:38pm

Puts cara Pior q nem tah aparecendo a consulta no console…

romarcio · Setembro 20, 2010, 2:45pm

Então tem coisa errada, pq vc setou no xml:

<property name="hibernate.show_sql">true</property>  
<property name="hibernate.format_sql">true</property>

Essas duas propriedades são justamente para mostrar o SQL e formatar o SQL no log que aparece no console.

Ace · Setembro 20, 2010, 2:47pm

Da uma olhada ae…


14:31:51,877  INFO Version:15 - Hibernate Annotations 3.4.0.GA
 14:31:51,908  INFO Environment:543 - Hibernate 3.3.0.SP1
 14:31:51,908  INFO Environment:576 - hibernate.properties not found
 14:31:51,908  INFO Environment:709 - Bytecode provider name : javassist
 14:31:51,923  INFO Environment:627 - using JDK 1.4 java.sql.Timestamp handling
 14:31:52,001  INFO Version:14 - Hibernate Commons Annotations 3.1.0.GA
 14:31:52,017  INFO Configuration:1460 - configuring from resource: /hibernate.cfg.xml
 14:31:52,017  INFO Configuration:1437 - Configuration resource: /hibernate.cfg.xml
 14:31:52,079 DEBUG DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
 14:31:52,079 DEBUG DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
 14:31:52,079 DEBUG DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
 14:31:52,126 DEBUG Configuration:1421 - hibernate.connection.provider_class=org.hibernate.connection.C3P0ConnectionProvider
 14:31:52,126 DEBUG Configuration:1421 - hibernate.c3p0.min_size=20
 14:31:52,126 DEBUG Configuration:1421 - hibernate.c3p0.max_size=75
 14:31:52,126 DEBUG Configuration:1421 - hibernate.c3p0.timeout=180
 14:31:52,126 DEBUG Configuration:1421 - hibernate.c3p0.idle_test_period=100
 14:31:52,126 DEBUG Configuration:1421 - hibernate.dialect=org.hibernate.dialect.MySQLDialect
 14:31:52,126 DEBUG Configuration:1421 - hibernate.connection.driver_class=com.mysql.jdbc.Driver
 14:31:52,126 DEBUG Configuration:1421 - hibernate.connection.url=jdbc:mysql://localhost/teste
 14:31:52,126 DEBUG Configuration:1421 - hibernate.connection.username=root
 14:31:52,126 DEBUG Configuration:1421 - hibernate.connection.password=123456
 14:31:52,126 DEBUG Configuration:1421 - hibernate.show_sql=true
 14:31:52,126 DEBUG Configuration:1421 - hibernate.format_sql=true
 14:31:52,126 DEBUG AnnotationConfiguration:644 - null <- org.dom4j.tree.DefaultAttribute@60420f [Attribute: name class value "br.com.model.Funcionario"]
 14:31:52,142 DEBUG AnnotationConfiguration:644 - null <- org.dom4j.tree.DefaultAttribute@e94e92 [Attribute: name class value "br.com.model.Fornecedor"]
 14:31:52,142 DEBUG AnnotationConfiguration:644 - null <- org.dom4j.tree.DefaultAttribute@12a54f9 [Attribute: name class value "br.com.model.ContaPagar"]
 14:31:52,142  INFO Configuration:1575 - Configured SessionFactory: null
 14:31:52,142 DEBUG Configuration:1576 - properties: {hibernate.connection.password=123456, java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Arquivos de programas\Java\jre6\bin, java.vm.version=17.0-b17, hibernate.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=BR, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Documents and Settings\rafael.justino\workspace\JSF, java.runtime.version=1.6.0_21-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Arquivos de programas\Java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\RAFAEL~1.JUS\CONFIG~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, hibernate.c3p0.idle_test_period=100, sun.jnu.encoding=Cp1252, hibernate.c3p0.timeout=180, java.library.path=C:\Arquivos de programas\Java\jre6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre6/bin/client;C:/Arquivos de programas/Java/jre6/bin;D:\Arquivos de programas\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Arquivos de programas\Java\jdk1.6.0_01\bin;C:\ant\bin;C:\Python25;C:\Arquivos de programas\Microsoft SQL Server\90\Tools\binn\;D:\Arquivos de programas\Symantec\Symantec Endpoint Protection Manager\Php, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\rafael.justino, user.timezone=GMT-03:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, hibernate.format_sql=true, hibernate.c3p0.min_size=20, hibernate.connection.driver_class=com.mysql.jdbc.Driver, user.name=rafael.justino, java.class.path=C:\Documents and Settings\rafael.justino\workspace\JSF\build\classes;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\annotations-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina-ant.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina-ha.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina-tribes.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\el-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jasper-el.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jasper-jdt.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jasper.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jsp-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\servlet-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-coyote.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-dbcp.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-i18n-es.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-i18n-fr.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-i18n-ja.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\ant-contrib-1.0b2.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\ant-junit-1.6.5.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\antlr-2.7.6.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\antlr.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\asm-attrs.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\asm.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\c3p0-0.9.0.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\cglib-2.2.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.2.1-javadoc.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.2.1-sources.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.2.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-testframework-3.2.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\dom4j-1.6.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\dom4j.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\ejb3-persistence.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-annotations.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-commons-annotations.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-core.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-jpa-2.0-api-1.0.0.Final.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-testing.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-tools.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-validator-4.1.0.Final.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate3.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\javassist-3.9.0.GA.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\javassist.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jaxb-api-2.2.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jaxb-impl-2.1.12.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jta-1.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jta.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\junit-3.8.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\junit.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\log4j-1.2.14.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\log4j.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-api-1.5.6.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-api-1.5.8.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-api.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-log4j12-1.5.6.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-log4j12.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\validation-api-1.0.0.GA.jar, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Arquivos de programas\Java\jre6, sun.arch.data.model=32, hibernate.connection.url=jdbc:mysql://localhost/teste, hibernate.dialect=org.hibernate.dialect.MySQLDialect, user.language=pt, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=75, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_21, java.ext.dirs=C:\Arquivos de programas\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Arquivos de programas\Java\jre6\lib\resources.jar;C:\Arquivos de programas\Java\jre6\lib\rt.jar;C:\Arquivos de programas\Java\jre6\lib\sunrsasign.jar;C:\Arquivos de programas\Java\jre6\lib\jsse.jar;C:\Arquivos de programas\Java\jre6\lib\jce.jar;C:\Arquivos de programas\Java\jre6\lib\charsets.jar;C:\Arquivos de programas\Java\jre6\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.connection.provider_class=org.hibernate.connection.C3P0ConnectionProvider, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
 14:31:52,157 DEBUG AnnotationConfiguration:806 - Validator not present in classpath, ignoring event listener registration
 14:31:52,157 DEBUG HibernateSearchEventListenerRegister:209 - Search not present in classpath, ignoring event listener registration.
 14:31:52,157  INFO HibernateSearchEventListenerRegister:53 - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
 14:31:52,157 DEBUG Configuration:1318 - Preparing to build session factory with filters : {}
 14:31:52,157 DEBUG AnnotationConfiguration:258 - Execute first pass mapping processing
 14:31:52,219 DEBUG AnnotationConfiguration:529 - Process hbm files
 14:31:52,219 DEBUG AnnotationConfiguration:537 - Process annotated classes
 14:31:52,235  INFO AnnotationBinder:419 - Binding entity from annotated class: br.com.model.Funcionario
 14:31:52,251 DEBUG Ejb3Column:161 - Binding column DTYPE. Unique false. Nullable false.
 14:31:52,282 DEBUG EntityBinder:295 - Import with entity name Funcionario
 14:31:52,297  INFO EntityBinder:422 - Bind entity br.com.model.Funcionario on table Funcionario
 14:31:52,297 DEBUG AnnotationBinder:1022 - Processing br.com.model.Funcionario property annotation
 14:31:52,313 DEBUG AnnotationBinder:1022 - Processing br.com.model.Funcionario field annotation
 14:31:52,329 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Funcionario.id
 14:31:52,329 DEBUG Ejb3Column:161 - Binding column id. Unique false. Nullable true.
 14:31:52,329 DEBUG AnnotationBinder:1257 - id is an id
 14:31:52,329 DEBUG SimpleValueBinder:220 - building SimpleValue for id
 14:31:52,344 DEBUG PropertyBinder:131 - Building property id
 14:31:52,344 DEBUG AnnotationBinder:1293 - Bind @Id on id
 14:31:52,344 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Funcionario.email
 14:31:52,344 DEBUG Ejb3Column:161 - Binding column email. Unique false. Nullable true.
 14:31:52,344 DEBUG PropertyBinder:110 - binding property email with lazy=false
 14:31:52,344 DEBUG SimpleValueBinder:220 - building SimpleValue for email
 14:31:52,344 DEBUG PropertyBinder:131 - Building property email
 14:31:52,344 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Funcionario.nome
 14:31:52,344 DEBUG Ejb3Column:161 - Binding column nome. Unique false. Nullable true.
 14:31:52,360 DEBUG PropertyBinder:110 - binding property nome with lazy=false
 14:31:52,360 DEBUG SimpleValueBinder:220 - building SimpleValue for nome
 14:31:52,360 DEBUG PropertyBinder:131 - Building property nome
 14:31:52,360 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Funcionario.senha
 14:31:52,360 DEBUG Ejb3Column:161 - Binding column senha. Unique false. Nullable true.
 14:31:52,360 DEBUG PropertyBinder:110 - binding property senha with lazy=false
 14:31:52,360 DEBUG SimpleValueBinder:220 - building SimpleValue for senha
 14:31:52,360 DEBUG PropertyBinder:131 - Building property senha
 14:31:52,360 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Funcionario.usuario
 14:31:52,360 DEBUG Ejb3Column:161 - Binding column usuario. Unique false. Nullable true.
 14:31:52,360 DEBUG PropertyBinder:110 - binding property usuario with lazy=false
 14:31:52,360 DEBUG SimpleValueBinder:220 - building SimpleValue for usuario
 14:31:52,360 DEBUG PropertyBinder:131 - Building property usuario
 14:31:52,360  INFO AnnotationBinder:419 - Binding entity from annotated class: br.com.model.Fornecedor
 14:31:52,360 DEBUG Ejb3Column:161 - Binding column DTYPE. Unique false. Nullable false.
 14:31:52,360 DEBUG EntityBinder:295 - Import with entity name Fornecedor
 14:31:52,360  INFO EntityBinder:422 - Bind entity br.com.model.Fornecedor on table Fornecedor
 14:31:52,360 DEBUG AnnotationBinder:1022 - Processing br.com.model.Fornecedor property annotation
 14:31:52,360 DEBUG AnnotationBinder:1022 - Processing br.com.model.Fornecedor field annotation
 14:31:52,360 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Fornecedor.id
 14:31:52,360 DEBUG Ejb3Column:161 - Binding column id. Unique false. Nullable true.
 14:31:52,375 DEBUG AnnotationBinder:1257 - id is an id
 14:31:52,375 DEBUG SimpleValueBinder:220 - building SimpleValue for id
 14:31:52,375 DEBUG PropertyBinder:131 - Building property id
 14:31:52,375 DEBUG AnnotationBinder:1293 - Bind @Id on id
 14:31:52,375 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Fornecedor.descricao
 14:31:52,375 DEBUG Ejb3Column:161 - Binding column descricao. Unique false. Nullable true.
 14:31:52,375 DEBUG PropertyBinder:110 - binding property descricao with lazy=false
 14:31:52,375 DEBUG SimpleValueBinder:220 - building SimpleValue for descricao
 14:31:52,375 DEBUG PropertyBinder:131 - Building property descricao
 14:31:52,375 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.Fornecedor.nome
 14:31:52,375 DEBUG Ejb3Column:161 - Binding column nome. Unique false. Nullable true.
 14:31:52,375 DEBUG PropertyBinder:110 - binding property nome with lazy=false
 14:31:52,375 DEBUG SimpleValueBinder:220 - building SimpleValue for nome
 14:31:52,375 DEBUG PropertyBinder:131 - Building property nome
 14:31:52,375  INFO AnnotationBinder:419 - Binding entity from annotated class: br.com.model.ContaPagar
 14:31:52,375 DEBUG Ejb3Column:161 - Binding column DTYPE. Unique false. Nullable false.
 14:31:52,375 DEBUG EntityBinder:295 - Import with entity name ContaPagar
 14:31:52,375  INFO EntityBinder:422 - Bind entity br.com.model.ContaPagar on table ContaPagar
 14:31:52,375 DEBUG AnnotationBinder:1022 - Processing br.com.model.ContaPagar property annotation
 14:31:52,375 DEBUG AnnotationBinder:1022 - Processing br.com.model.ContaPagar field annotation
 14:31:52,375 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.ContaPagar.id
 14:31:52,375 DEBUG Ejb3Column:161 - Binding column id. Unique false. Nullable true.
 14:31:52,375 DEBUG AnnotationBinder:1257 - id is an id
 14:31:52,375 DEBUG SimpleValueBinder:220 - building SimpleValue for id
 14:31:52,375 DEBUG PropertyBinder:131 - Building property id
 14:31:52,375 DEBUG AnnotationBinder:1293 - Bind @Id on id
 14:31:52,391 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.ContaPagar.data
 14:31:52,391 DEBUG Ejb3Column:161 - Binding column data. Unique false. Nullable true.
 14:31:52,391 DEBUG PropertyBinder:110 - binding property data with lazy=false
 14:31:52,391 DEBUG SimpleValueBinder:220 - building SimpleValue for data
 14:31:52,391 DEBUG PropertyBinder:131 - Building property data
 14:31:52,391 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.ContaPagar.descricao
 14:31:52,391 DEBUG Ejb3Column:161 - Binding column descricao. Unique false. Nullable true.
 14:31:52,391 DEBUG PropertyBinder:110 - binding property descricao with lazy=false
 14:31:52,391 DEBUG SimpleValueBinder:220 - building SimpleValue for descricao
 14:31:52,391 DEBUG PropertyBinder:131 - Building property descricao
 14:31:52,391 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.ContaPagar.fornecedor
 14:31:52,391 DEBUG Ejb3Column:161 - Binding column null. Unique false. Nullable true.
 14:31:52,391 DEBUG Ejb3Column:161 - Binding column fornecedor. Unique false. Nullable true.
 14:31:52,391 DEBUG PropertyBinder:131 - Building property fornecedor
 14:31:52,391 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.ContaPagar.pago
 14:31:52,391 DEBUG Ejb3Column:161 - Binding column pago. Unique false. Nullable false.
 14:31:52,391 DEBUG PropertyBinder:110 - binding property pago with lazy=false
 14:31:52,391 DEBUG SimpleValueBinder:220 - building SimpleValue for pago
 14:31:52,391 DEBUG PropertyBinder:131 - Building property pago
 14:31:52,391 DEBUG AnnotationBinder:1133 - Processing annotations of br.com.model.ContaPagar.valor
 14:31:52,391 DEBUG Ejb3Column:161 - Binding column valor. Unique false. Nullable true.
 14:31:52,406 DEBUG PropertyBinder:110 - binding property valor with lazy=false
 14:31:52,406 DEBUG SimpleValueBinder:220 - building SimpleValue for valor
 14:31:52,406 DEBUG PropertyBinder:131 - Building property valor
 14:31:52,406 DEBUG AnnotationConfiguration:401 - processing fk mappings (*ToOne and JoinedSubclass)
 14:31:52,469 DEBUG Configuration:1153 - processing extends queue
 14:31:52,469 DEBUG Configuration:1157 - processing collection mappings
 14:31:52,469 DEBUG Configuration:1168 - processing native query and ResultSetMapping mappings
 14:31:52,469 DEBUG Configuration:1176 - processing association property references
 14:31:52,469 DEBUG Configuration:1198 - processing foreign key constraints
 14:31:52,484 DEBUG Configuration:1281 - resolving reference to class: br.com.model.Fornecedor
 14:31:52,484  INFO AnnotationConfiguration:369 - Hibernate Validator not found: ignoring
 14:31:52,484  INFO ConnectionProviderFactory:95 - Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
 14:31:52,484  INFO C3P0ConnectionProvider:103 - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/teste
 14:31:52,484  INFO C3P0ConnectionProvider:104 - Connection properties: {user=root, password=****}
 14:31:52,484  INFO C3P0ConnectionProvider:107 - autocommit mode: false
 14:31:53,155  INFO SettingsFactory:116 - RDBMS: MySQL, version: 5.0.67-community-nt
 14:31:53,155  INFO SettingsFactory:117 - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.7 ( Revision: ${svn.Revision} )
 14:31:53,170  INFO Dialect:175 - Using dialect: org.hibernate.dialect.MySQLDialect
 14:31:53,186  INFO TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions)
 14:31:53,186  INFO TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
 14:31:53,186  INFO SettingsFactory:170 - Automatic flush during beforeCompletion(): disabled
 14:31:53,186  INFO SettingsFactory:174 - Automatic session close at end of transaction: disabled
 14:31:53,186  INFO SettingsFactory:181 - JDBC batch size: 15
 14:31:53,186  INFO SettingsFactory:184 - JDBC batch updates for versioned data: disabled
 14:31:53,186  INFO SettingsFactory:189 - Scrollable result sets: enabled
 14:31:53,186 DEBUG SettingsFactory:193 - Wrap result sets: disabled
 14:31:53,186  INFO SettingsFactory:197 - JDBC3 getGeneratedKeys(): enabled
 14:31:53,186  INFO SettingsFactory:205 - Connection release mode: auto
 14:31:53,186  INFO SettingsFactory:229 - Maximum outer join fetch depth: 2
 14:31:53,186  INFO SettingsFactory:232 - Default batch fetch size: 1
 14:31:53,186  INFO SettingsFactory:236 - Generate SQL with comments: disabled
 14:31:53,186  INFO SettingsFactory:240 - Order SQL updates by primary key: disabled
 14:31:53,186  INFO SettingsFactory:244 - Order SQL inserts for batching: disabled
 14:31:53,186  INFO SettingsFactory:420 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
 14:31:53,201  INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
 14:31:53,201  INFO SettingsFactory:252 - Query language substitutions: {}
 14:31:53,201  INFO SettingsFactory:257 - JPA-QL strict compliance: disabled
 14:31:53,201  INFO SettingsFactory:262 - Second-level cache: enabled
 14:31:53,201  INFO SettingsFactory:266 - Query cache: disabled
 14:31:53,201  INFO SettingsFactory:405 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
 14:31:53,201  INFO SettingsFactory:276 - Optimize cache for minimal puts: disabled
 14:31:53,201  INFO SettingsFactory:285 - Structured second-level cache entries: disabled
 14:31:53,201  INFO SettingsFactory:305 - Echoing all SQL to stdout
 14:31:53,201  INFO SettingsFactory:314 - Statistics: disabled
 14:31:53,201  INFO SettingsFactory:318 - Deleted entity synthetic identifier rollback: disabled
 14:31:53,217  INFO SettingsFactory:333 - Default entity-mode: pojo
 14:31:53,217  INFO SettingsFactory:337 - Named query checking : enabled
 14:31:53,310  INFO SessionFactoryImpl:187 - building session factory
 14:31:53,310 DEBUG SessionFactoryImpl:205 - Session factory constructed with filter configurations : {}
 14:31:53,310 DEBUG SessionFactoryImpl:209 - instantiating session factory with properties: {java.runtime.name=Java(TM) SE Runtime Environment, hibernate.connection.password=123456, sun.boot.library.path=C:\Arquivos de programas\Java\jre6\bin, java.vm.version=17.0-b17, hibernate.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=BR, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Documents and Settings\rafael.justino\workspace\JSF, java.runtime.version=1.6.0_21-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Arquivos de programas\Java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\RAFAEL~1.JUS\CONFIG~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, hibernate.c3p0.idle_test_period=100, sun.jnu.encoding=Cp1252, hibernate.c3p0.timeout=180, java.library.path=C:\Arquivos de programas\Java\jre6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre6/bin/client;C:/Arquivos de programas/Java/jre6/bin;D:\Arquivos de programas\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Arquivos de programas\Java\jdk1.6.0_01\bin;C:\ant\bin;C:\Python25;C:\Arquivos de programas\Microsoft SQL Server\90\Tools\binn\;D:\Arquivos de programas\Symantec\Symantec Endpoint Protection Manager\Php, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\rafael.justino, user.timezone=GMT-03:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, java.specification.version=1.6, file.encoding=Cp1252, hibernate.format_sql=true, hibernate.c3p0.min_size=20, hibernate.connection.driver_class=com.mysql.jdbc.Driver, java.class.path=C:\Documents and Settings\rafael.justino\workspace\JSF\build\classes;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\annotations-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina-ant.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina-ha.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina-tribes.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\catalina.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\el-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jasper-el.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jasper-jdt.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jasper.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\jsp-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\servlet-api.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-coyote.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-dbcp.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-i18n-es.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-i18n-fr.jar;C:\Documents and Settings\rafael.justino\workspace\apache-tomcat-6.0.29\lib\tomcat-i18n-ja.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\ant-contrib-1.0b2.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\ant-junit-1.6.5.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\antlr-2.7.6.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\antlr.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\asm-attrs.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\asm.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\c3p0-0.9.0.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\cglib-2.2.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.2.1-javadoc.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.2.1-sources.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-3.2.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections-testframework-3.2.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\commons-collections.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\dom4j-1.6.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\dom4j.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\ejb3-persistence.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-annotations.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-commons-annotations.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-core.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-jpa-2.0-api-1.0.0.Final.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-testing.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-tools.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate-validator-4.1.0.Final.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\hibernate3.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\javassist-3.9.0.GA.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\javassist.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jaxb-api-2.2.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jaxb-impl-2.1.12.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jta-1.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\jta.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\junit-3.8.1.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\junit.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\log4j-1.2.14.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\log4j.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-api-1.5.6.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-api-1.5.8.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-api.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-log4j12-1.5.6.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\slf4j-log4j12.jar;C:\Documents and Settings\rafael.justino\workspace\JSF\WebContent\WEB-INF\lib\validation-api-1.0.0.GA.jar, user.name=rafael.justino, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Arquivos de programas\Java\jre6, hibernate.dialect=org.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://localhost/teste, java.specification.vendor=Sun Microsystems Inc., user.language=pt, awt.toolkit=sun.awt.windows.WToolkit, hibernate.c3p0.max_size=75, java.vm.info=mixed mode, sharing, java.version=1.6.0_21, java.ext.dirs=C:\Arquivos de programas\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Arquivos de programas\Java\jre6\lib\resources.jar;C:\Arquivos de programas\Java\jre6\lib\rt.jar;C:\Arquivos de programas\Java\jre6\lib\sunrsasign.jar;C:\Arquivos de programas\Java\jre6\lib\jsse.jar;C:\Arquivos de programas\Java\jre6\lib\jce.jar;C:\Arquivos de programas\Java\jre6\lib\charsets.jar;C:\Arquivos de programas\Java\jre6\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.connection.provider_class=org.hibernate.connection.C3P0ConnectionProvider, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
 14:31:53,591 DEBUG AbstractEntityPersister:2766 - Static SQL for entity: br.com.model.Funcionario
 14:31:53,591 DEBUG AbstractEntityPersister:2771 -  Version select: select id from Funcionario where id =?
 14:31:53,591 DEBUG AbstractEntityPersister:2774 -  Snapshot select: select funcionari_.id, funcionari_.email as email0_, funcionari_.nome as nome0_, funcionari_.senha as senha0_, funcionari_.usuario as usuario0_ from Funcionario funcionari_ where funcionari_.id=?
 14:31:53,591 DEBUG AbstractEntityPersister:2777 -  Insert 0: insert into Funcionario (email, nome, senha, usuario, id) values (?, ?, ?, ?, ?)
 14:31:53,591 DEBUG AbstractEntityPersister:2778 -  Update 0: update Funcionario set email=?, nome=?, senha=?, usuario=? where id=?
 14:31:53,591 DEBUG AbstractEntityPersister:2779 -  Delete 0: delete from Funcionario where id=?
 14:31:53,591 DEBUG AbstractEntityPersister:2783 -  Identity insert: insert into Funcionario (email, nome, senha, usuario) values (?, ?, ?, ?)
 14:31:53,591 DEBUG AbstractEntityPersister:2766 - Static SQL for entity: br.com.model.Fornecedor
 14:31:53,591 DEBUG AbstractEntityPersister:2771 -  Version select: select id from Fornecedor where id =?
 14:31:53,591 DEBUG AbstractEntityPersister:2774 -  Snapshot select: select fornecedor_.id, fornecedor_.descricao as descricao1_, fornecedor_.nome as nome1_ from Fornecedor fornecedor_ where fornecedor_.id=?
 14:31:53,591 DEBUG AbstractEntityPersister:2777 -  Insert 0: insert into Fornecedor (descricao, nome, id) values (?, ?, ?)
 14:31:53,591 DEBUG AbstractEntityPersister:2778 -  Update 0: update Fornecedor set descricao=?, nome=? where id=?
 14:31:53,591 DEBUG AbstractEntityPersister:2779 -  Delete 0: delete from Fornecedor where id=?
 14:31:53,591 DEBUG AbstractEntityPersister:2783 -  Identity insert: insert into Fornecedor (descricao, nome) values (?, ?)
 14:31:53,607 DEBUG AbstractEntityPersister:2766 - Static SQL for entity: br.com.model.ContaPagar
 14:31:53,607 DEBUG AbstractEntityPersister:2771 -  Version select: select id from ContaPagar where id =?
 14:31:53,607 DEBUG AbstractEntityPersister:2774 -  Snapshot select: select contapagar_.id, contapagar_.data as data2_, contapagar_.descricao as descricao2_, contapagar_.fornecedor_id as fornecedor6_2_, contapagar_.pago as pago2_, contapagar_.valor as valor2_ from ContaPagar contapagar_ where contapagar_.id=?
 14:31:53,607 DEBUG AbstractEntityPersister:2777 -  Insert 0: insert into ContaPagar (data, descricao, fornecedor_id, pago, valor, id) values (?, ?, ?, ?, ?, ?)
 14:31:53,607 DEBUG AbstractEntityPersister:2778 -  Update 0: update ContaPagar set data=?, descricao=?, fornecedor_id=?, pago=?, valor=? where id=?
 14:31:53,607 DEBUG AbstractEntityPersister:2779 -  Delete 0: delete from ContaPagar where id=?
 14:31:53,607 DEBUG AbstractEntityPersister:2783 -  Identity insert: insert into ContaPagar (data, descricao, fornecedor_id, pago, valor) values (?, ?, ?, ?, ?)
 14:31:53,622 DEBUG EntityLoader:102 - Static select for entity br.com.model.Funcionario: select funcionari0_.id as id0_0_, funcionari0_.email as email0_0_, funcionari0_.nome as nome0_0_, funcionari0_.senha as senha0_0_, funcionari0_.usuario as usuario0_0_ from Funcionario funcionari0_ where funcionari0_.id=?
 14:31:53,638 DEBUG EntityLoader:102 - Static select for entity br.com.model.Funcionario: select funcionari0_.id as id0_0_, funcionari0_.email as email0_0_, funcionari0_.nome as nome0_0_, funcionari0_.senha as senha0_0_, funcionari0_.usuario as usuario0_0_ from Funcionario funcionari0_ where funcionari0_.id=?
 14:31:53,638 DEBUG EntityLoader:102 - Static select for entity br.com.model.Funcionario: select funcionari0_.id as id0_0_, funcionari0_.email as email0_0_, funcionari0_.nome as nome0_0_, funcionari0_.senha as senha0_0_, funcionari0_.usuario as usuario0_0_ from Funcionario funcionari0_ where funcionari0_.id=? for update
 14:31:53,638 DEBUG EntityLoader:102 - Static select for entity br.com.model.Funcionario: select funcionari0_.id as id0_0_, funcionari0_.email as email0_0_, funcionari0_.nome as nome0_0_, funcionari0_.senha as senha0_0_, funcionari0_.usuario as usuario0_0_ from Funcionario funcionari0_ where funcionari0_.id=? for update
 14:31:53,638 DEBUG EntityLoader:102 - Static select for entity br.com.model.Funcionario: select funcionari0_.id as id0_0_, funcionari0_.email as email0_0_, funcionari0_.nome as nome0_0_, funcionari0_.senha as senha0_0_, funcionari0_.usuario as usuario0_0_ from Funcionario funcionari0_ where funcionari0_.id=? for update
 14:31:53,653 DEBUG EntityLoader:57 - Static select for action ACTION_MERGE on entity br.com.model.Funcionario: select funcionari0_.id as id0_0_, funcionari0_.email as email0_0_, funcionari0_.nome as nome0_0_, funcionari0_.senha as senha0_0_, funcionari0_.usuario as usuario0_0_ from Funcionario funcionari0_ where funcionari0_.id=?
 14:31:53,653 DEBUG EntityLoader:57 - Static select for action ACTION_REFRESH on entity br.com.model.Funcionario: select funcionari0_.id as id0_0_, funcionari0_.email as email0_0_, funcionari0_.nome as nome0_0_, funcionari0_.senha as senha0_0_, funcionari0_.usuario as usuario0_0_ from Funcionario funcionari0_ where funcionari0_.id=?
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.Fornecedor: select fornecedor0_.id as id1_0_, fornecedor0_.descricao as descricao1_0_, fornecedor0_.nome as nome1_0_ from Fornecedor fornecedor0_ where fornecedor0_.id=?
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.Fornecedor: select fornecedor0_.id as id1_0_, fornecedor0_.descricao as descricao1_0_, fornecedor0_.nome as nome1_0_ from Fornecedor fornecedor0_ where fornecedor0_.id=?
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.Fornecedor: select fornecedor0_.id as id1_0_, fornecedor0_.descricao as descricao1_0_, fornecedor0_.nome as nome1_0_ from Fornecedor fornecedor0_ where fornecedor0_.id=? for update
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.Fornecedor: select fornecedor0_.id as id1_0_, fornecedor0_.descricao as descricao1_0_, fornecedor0_.nome as nome1_0_ from Fornecedor fornecedor0_ where fornecedor0_.id=? for update
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.Fornecedor: select fornecedor0_.id as id1_0_, fornecedor0_.descricao as descricao1_0_, fornecedor0_.nome as nome1_0_ from Fornecedor fornecedor0_ where fornecedor0_.id=? for update
 14:31:53,653 DEBUG EntityLoader:57 - Static select for action ACTION_MERGE on entity br.com.model.Fornecedor: select fornecedor0_.id as id1_0_, fornecedor0_.descricao as descricao1_0_, fornecedor0_.nome as nome1_0_ from Fornecedor fornecedor0_ where fornecedor0_.id=?
 14:31:53,653 DEBUG EntityLoader:57 - Static select for action ACTION_REFRESH on entity br.com.model.Fornecedor: select fornecedor0_.id as id1_0_, fornecedor0_.descricao as descricao1_0_, fornecedor0_.nome as nome1_0_ from Fornecedor fornecedor0_ where fornecedor0_.id=?
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.ContaPagar: select contapagar0_.id as id2_1_, contapagar0_.data as data2_1_, contapagar0_.descricao as descricao2_1_, contapagar0_.fornecedor_id as fornecedor6_2_1_, contapagar0_.pago as pago2_1_, contapagar0_.valor as valor2_1_, fornecedor1_.id as id1_0_, fornecedor1_.descricao as descricao1_0_, fornecedor1_.nome as nome1_0_ from ContaPagar contapagar0_ left outer join Fornecedor fornecedor1_ on contapagar0_.fornecedor_id=fornecedor1_.id where contapagar0_.id=?
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.ContaPagar: select contapagar0_.id as id2_1_, contapagar0_.data as data2_1_, contapagar0_.descricao as descricao2_1_, contapagar0_.fornecedor_id as fornecedor6_2_1_, contapagar0_.pago as pago2_1_, contapagar0_.valor as valor2_1_, fornecedor1_.id as id1_0_, fornecedor1_.descricao as descricao1_0_, fornecedor1_.nome as nome1_0_ from ContaPagar contapagar0_ left outer join Fornecedor fornecedor1_ on contapagar0_.fornecedor_id=fornecedor1_.id where contapagar0_.id=?
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.ContaPagar: select contapagar0_.id as id2_0_, contapagar0_.data as data2_0_, contapagar0_.descricao as descricao2_0_, contapagar0_.fornecedor_id as fornecedor6_2_0_, contapagar0_.pago as pago2_0_, contapagar0_.valor as valor2_0_ from ContaPagar contapagar0_ where contapagar0_.id=? for update
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.ContaPagar: select contapagar0_.id as id2_0_, contapagar0_.data as data2_0_, contapagar0_.descricao as descricao2_0_, contapagar0_.fornecedor_id as fornecedor6_2_0_, contapagar0_.pago as pago2_0_, contapagar0_.valor as valor2_0_ from ContaPagar contapagar0_ where contapagar0_.id=? for update
 14:31:53,653 DEBUG EntityLoader:102 - Static select for entity br.com.model.ContaPagar: select contapagar0_.id as id2_0_, contapagar0_.data as data2_0_, contapagar0_.descricao as descricao2_0_, contapagar0_.fornecedor_id as fornecedor6_2_0_, contapagar0_.pago as pago2_0_, contapagar0_.valor as valor2_0_ from ContaPagar contapagar0_ where contapagar0_.id=? for update
 14:31:53,653 DEBUG EntityLoader:57 - Static select for action ACTION_MERGE on entity br.com.model.ContaPagar: select contapagar0_.id as id2_0_, contapagar0_.data as data2_0_, contapagar0_.descricao as descricao2_0_, contapagar0_.fornecedor_id as fornecedor6_2_0_, contapagar0_.pago as pago2_0_, contapagar0_.valor as valor2_0_ from ContaPagar contapagar0_ where contapagar0_.id=?
 14:31:53,653 DEBUG EntityLoader:57 - Static select for action ACTION_REFRESH on entity br.com.model.ContaPagar: select contapagar0_.id as id2_0_, contapagar0_.data as data2_0_, contapagar0_.descricao as descricao2_0_, contapagar0_.fornecedor_id as fornecedor6_2_0_, contapagar0_.pago as pago2_0_, contapagar0_.valor as valor2_0_ from ContaPagar contapagar0_ where contapagar0_.id=?
 14:31:53,653 DEBUG SessionFactoryObjectFactory:62 - initializing class SessionFactoryObjectFactory
 14:31:53,669 DEBUG SessionFactoryObjectFactory:99 - registered: 4028808c2b3033a8012b3033a9b50000 (unnamed)
 14:31:53,669  INFO SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
 14:31:53,669 DEBUG SessionFactoryImpl:340 - instantiated session factory
 14:31:53,669 DEBUG SessionFactoryImpl:426 - Checking 0 named HQL queries
 14:31:53,669 DEBUG SessionFactoryImpl:446 - Checking 0 named SQL queries
 14:31:53,716 DEBUG SessionImpl:247 - opened session at timestamp: 12850039136
 Exception in thread "main" java.lang.NullPointerException
	at br.com.dao.FuncionarioDao.buscaFuncionario(FuncionarioDao.java:27)
	at br.com.teste.TestaPesquisaILike.main(TestaPesquisaILike.java:19)

aluisiodsv · Setembro 20, 2010, 3:10pm

Segundo a exceção gerada. A linha 27 do Dao está gerando um NullPointerException. Tem alguém null aí. Minha opinião é q o getSession() está vindo null

romarcio · Setembro 20, 2010, 3:13pm

O que vc tem na classe Dao que é extendida no FuncionarioDao?

Cola ela aqui e coloca também a classe HibernateUtil.

Ace · Setembro 20, 2010, 3:51pm

Galera segue as duas classes…


package br.com.hibernateUtil;


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


public class HibernateUtil {
	
	private static SessionFactory factory;
	private static	Session session;
	private static Transaction transaction;
	
	
	static{
		AnnotationConfiguration cfg = new AnnotationConfiguration();		
		factory = cfg.configure().buildSessionFactory();		
	}	
	
	public static void beginTransaction(){
		transaction = getSession().beginTransaction();
	}
	
	public static void commitTransaction(){
		transaction.commit();
	}

	public static Session getSession(){		
		session = factory.openSession(); 
		return session;
	}	
	
	public static void closeSession(){
		session.close();
	}
}


package br.com.dao;

import org.hibernate.Session;
import org.hibernate.Transaction;


public class Dao<T> {

	private static Session session;
	private Class<T> persistentClass;
	private Transaction transaction;
	
	
	public Dao(Session session, Class pesistentClass){
		this.session = session;
		this.persistentClass = pesistentClass;
	}
	
	@SuppressWarnings("unchecked")
	public T load(Long id){
		return (T) session.load(persistentClass, id);
	}
	
	public void save(T u){
		session.save(u);
	}
	
	public void beginTransaction(){
		this.session.beginTransaction().commit();
	}
	
	public void commit(){
		this.transaction.commit();
	}
	
	public void delete(T u){
		session.delete(u);
	}	
	
}

romarcio · Setembro 20, 2010, 7:08pm

Tenta assim, na classe Dao cria esse método:

	protected Session getSession() {
		return HibernateUtil.getSession();
	}

Dai quando vc fazer o extends Dao nas classes …Dao, vc tem a Sessão por herança.
Cria um construtor padrão em FuncionarioDao.

Dai para testar:

public static void main(String[] args) {
        
        //Session s = new HibernateUtil().getSession();
        
        //FuncionarioDao funDao = new FuncionarioDao(s);        

        FuncionarioDao funDao = new FuncionarioDao();
 
        List&lt;Funcionario&gt; listaFun = funDao.buscaFuncionario("k%");
        for (Funcionario f :  listaFun){        
            System.out.println(f.getNome());
        }

Na classe FuncionarioDao, exclui;

protected Session getSession(){       
        return session;  

    }

Dai o getSession no método buscaFuncionario vai vir por herança da classe Dao.

Ace · Setembro 21, 2010, 8:36am

Romarcio,
Valew brother deu certo aki agora está listando normal…

Para quem estiver tendo o mesmo probleminha as alterações foram…

na minha classe genericDao criei uma sessão do HibernateUtil, para quando cada classe extender a mesma já terá uma sessão.!

protected Session getSession(){
		return HibernateUtil.getSession();
	}

em minha classe FuncionarioDao, onde a mesma extende genericDao, criei um conatrutor padão sem argumentos. com o atributo session, estático

private static Session session;

/* Estava Assim
    public FuncionarioDao(Session session){
        super (session, Funcionario.class);
        }    
    */

  //alterado para assim.
  public  FuncionarioDao() {
      super (session, Funcionario.class);
    }

e para a classe de teste, somente estanciei a classe FuncionarioDao sem passar a sessão, que anteriormente estava puxando de hibernate util.


                //Session s = new HibernateUtil().getSession();
		
		//FuncionarioDao funDao = new FuncionarioDao(s);
		
		FuncionarioDao funDao = new FuncionarioDao();
		List<Funcionario> listaFun = funDao.buscaFuncionario("%k%");
		for (Funcionario f :  listaFun){		
			System.out.println(f.getNome());

Valew Pessoal…
Abraços

system · Dezembro 30, 2015, 6:03am

Duvidas com Hibernate.[RESOLVIDO]

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI