Olá galera, estou com um problema, ja dei uma pesquisada mais não consegui resolver
está dando esse erro:
0 [http-8080-1] INFO annotations.Version - Hibernate Annotations 3.2.0.GA
17 [http-8080-1] INFO cfg.Environment - Hibernate 3.2.1
19 [http-8080-1] INFO cfg.Environment - hibernate.properties not found
21 [http-8080-1] INFO cfg.Environment - Bytecode provider name : cglib
24 [http-8080-1] INFO cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
174 [http-8080-1] INFO cfg.AnnotationBinder - Binding entity from annotated class: br.com.canix.sysnail.beans.CadastroBeans
206 [http-8080-1] INFO annotations.EntityBinder - Bind entity br.com.canix.sysnail.beans.CadastroBeans on table cadastro
353 [http-8080-1] INFO connection.C3P0ConnectionProvider - C3P0 using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/sysnail
353 [http-8080-1] INFO connection.C3P0ConnectionProvider - Connection properties: {user=postgres, password=****}
353 [http-8080-1] INFO connection.C3P0ConnectionProvider - autocommit mode: false
372 [http-8080-1] INFO log.MLog - MLog clients using log4j logging.
783 [http-8080-1] INFO c3p0.C3P0Registry - Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
895 [http-8080-1] INFO impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@6e766dd3 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@29a57fce [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kflt88j4cao45b89bq|1292738, idleConnectionTestPeriod -> 100, initialPoolSize -> 10, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@248d613f [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> z8kflt88j4cao45b89bq|157b39f, jdbcUrl -> jdbc:postgresql://localhost:5432/sysnail, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> z8kflt88j4cao45b89bq|8e7f54, numHelperThreads -> 3 ]
1027 [http-8080-1] INFO cfg.SettingsFactory - RDBMS: PostgreSQL, version: 8.4.3
1028 [http-8080-1] INFO cfg.SettingsFactory - JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.2devel JDBC3 with SSL (build 501)
1043 [http-8080-1] INFO dialect.Dialect - Using dialect: org.hibernate.dialect.PostgreSQLDialect
1048 [http-8080-1] INFO transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
1050 [http-8080-1] INFO transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1050 [http-8080-1] INFO cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
1050 [http-8080-1] INFO cfg.SettingsFactory - Automatic session close at end of transaction: disabled
1050 [http-8080-1] INFO cfg.SettingsFactory - JDBC batch size: 15
1050 [http-8080-1] INFO cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
1051 [http-8080-1] INFO cfg.SettingsFactory - Scrollable result sets: enabled
1051 [http-8080-1] INFO cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
1052 [http-8080-1] INFO cfg.SettingsFactory - Connection release mode: auto
1053 [http-8080-1] INFO cfg.SettingsFactory - Default batch fetch size: 1
1053 [http-8080-1] INFO cfg.SettingsFactory - Generate SQL with comments: disabled
1053 [http-8080-1] INFO cfg.SettingsFactory - Order SQL updates by primary key: disabled
1054 [http-8080-1] INFO cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1056 [http-8080-1] INFO ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
1056 [http-8080-1] INFO cfg.SettingsFactory - Query language substitutions: {}
1056 [http-8080-1] INFO cfg.SettingsFactory - JPA-QL strict compliance: disabled
1056 [http-8080-1] INFO cfg.SettingsFactory - Second-level cache: enabled
1056 [http-8080-1] INFO cfg.SettingsFactory - Query cache: disabled
1056 [http-8080-1] INFO cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
1056 [http-8080-1] INFO cfg.SettingsFactory - Optimize cache for minimal puts: disabled
1056 [http-8080-1] INFO cfg.SettingsFactory - Structured second-level cache entries: disabled
1119 [http-8080-1] INFO cfg.SettingsFactory - Statistics: disabled
1119 [http-8080-1] INFO cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
1120 [http-8080-1] INFO cfg.SettingsFactory - Default entity-mode: pojo
1157 [http-8080-1] INFO impl.SessionFactoryImpl - building session factory
1491 [http-8080-1] INFO impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
1540 [http-8080-1] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42P01
1540 [http-8080-1] ERROR util.JDBCExceptionReporter - ERRO: relação "hibernate_sequence" não existe
org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:100)
at br.com.canix.sysnail.DAO.CadastroUsuarioDAO.cadastrarUsuario(CadastroUsuarioDAO.java:30)
at org.apache.jsp.ajax.ajaxCadastroUsuario_jsp._jspService(ajaxCadastroUsuario_jsp.java:102)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:191)
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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:636)
28/04/2010 11:54:30 org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:100)
at br.com.canix.sysnail.DAO.CadastroUsuarioDAO.cadastrarUsuario(CadastroUsuarioDAO.java:30)
at org.apache.jsp.ajax.ajaxCadastroUsuario_jsp._jspService(ajaxCadastroUsuario_jsp.java:102)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:191)
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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:636)
package sysnail.beans;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
public class SessaoUtil {
private static final SessionFactory sessionFactory;
private static ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
static {
try{
Configuration configuration = new AnnotationConfiguration()
.addAnnotatedClass(br.com.canix.sysnail.beans.HibernateSessionRequestFilter.class)
.addAnnotatedClass(br.com.canix.sysnail.beans.CadastroBeans.class);
configuration.setProperty("hibernate.connection.url","jdbc:postgresql://localhost:5432/sysnail");
configuration.setProperty("hibernate.connection.driver_class", "org.postgresql.Driver");
configuration.setProperty("hibernate.connection.username", "postgres");
configuration.setProperty("hibernate.connection.password","1q2w3e");
configuration.setProperty("hibernate.dialect","org.hibernate.dialect.PostgreSQLDialect");
configuration.setProperty("hibernate.c3p0.acquire_increment","1");
configuration.setProperty("hibernate.c3p0.idle_test_period","100");
configuration.setProperty("hibernate.c3p0.max_statements","0");
configuration.setProperty("hibernate.c3p0.min_size","10");
configuration.setProperty("hibernate.c3p0.max_size","100");
configuration.setProperty("hibernate.c3p0.timeout","1800");
sessionFactory = configuration.buildSessionFactory();
}catch (Throwable t){
throw new ExceptionInInitializerError(t);
}
}