Problemas com Hibernate + PostgreSQL [resolvido]

opa galera blz?

to subindo minha primeira aplicação web com jsf2, primefaces3.1.1, tomcat 6, hibernate 3 e uma base de dados em postgresql 9.0 , consigo subir a aplicação sem problemas mas ao entrar em qualquer .xhtml da aplicação ele estoura esse erro no console:

2055425 [http-80-1] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: br.com.merodata.acproject.model.Users 2055425 [http-80-1] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity br.com.merodata.acproject.model.Users on table users 2055434 [http-80-1] INFO org.hibernate.cfg.Configuration - Hibernate Validator not found: ignoring 2055456 [http-80-1] INFO org.hibernate.cfg.search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled. 2055457 [http-80-1] INFO org.hibernate.util.NamingHelper - JNDI InitialContext properties:{} 2055457 [http-80-1] INFO org.hibernate.connection.DatasourceConnectionProvider - Using datasource: java:/comp/env/jdbc/DB 2055458 [http-80-1] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection to query metadata org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.postgresql.Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47) at br.com.merodata.acproject.util.PersistenceUtil.initialize(PersistenceUtil.java:15) at br.com.merodata.acproject.util.PersistenceUtil.getEntityManager(PersistenceUtil.java:22) at br.com.merodata.acproject.filter.JPAFilter.doFilter(JPAFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 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(Unknown Source) Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130) ... 25 more 20/03/2012 16:33:11 org.apache.catalina.core.StandardWrapperValve invoke GRAVE: Servlet.service() for servlet Faces Servlet threw exception org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:106) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:148) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47) at br.com.merodata.acproject.util.PersistenceUtil.initialize(PersistenceUtil.java:15) at br.com.merodata.acproject.util.PersistenceUtil.getEntityManager(PersistenceUtil.java:22) at br.com.merodata.acproject.filter.JPAFilter.doFilter(JPAFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 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(Unknown Source)

OBS a base não está na minha maquina, mas consegui acessar ela perfeitamente tanto em um teste na aplicação (aqui no guj tem varios) quanto no Db Vizualizer
. O teste na aplicação eu consegui fazer retirando o JPA da web.xml
to precisando muito de uma força :roll:

Ta faltando o driver.

1 curtida

é tava faltando mesmo mas o problema era que eu deveria adicionar o .jar a pasta lib do tomcat, vlww @jakefrog