Struts/Hibernate [Cannot open connection]

1 resposta
the_negao

Pessoal,

Estou usando:
* Hibernate 3.2
* Struts 1.2.8
* MySQL Connector 3.1.12

[color=red]E ESTÁ DANDO ESSE ERROR:[/color]
[color=gray]type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Cannot open connection
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:386)
org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.hibernate.exception.GenericJDBCException: Cannot open connection
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:118)
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1319)
autenticacao.LogonAction.execute(LogonAction.java:34)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:386)
org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)[/color]

hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?>
	<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

	<hibernate-configuration>
		<!-- a SessionFactory instance listed as /jndi/name -->
		<session-factory>
			<!-- CONEXÃO COM O MYSQL -->
			<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/sistema</property>
			<property name="hibernate.connection.username">root</property>
			<property name="hibernate.connection.password">123</property>
			
			<!-- Condiguração do c3p0 -->
			<property name="hibernate.c3p0.max_size">10</property>
			<property name="hibernate.c3p0.min_size">2</property>
			<property name="hibernate.c3p0.timeout">5000</property>
			<property name="hibernate.c3p0.max_statements">10</property>
			<property name="hibernate.c3p0.idle_test_period">3000</property>
			<property name="hibernate.c3p0.acquire_increment">2</property>
	
			<!-- Configurações de debug -->
			<property name="show_sql">true</property>
			<property name="use_outer_join">true</property>
			<property name="hibernate.generate_statistics">true</property>
			<property name="hibernate.use_sql_comments">true</property>
	
			<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
			
			<mapping resource="autenticacao/Usuario.hbm.xml"/>
			
		</session-factory>
	  
	</hibernate-configuration>

Alguém me ajuda, por favor!

1 Resposta

J

Só para facilitar um pouco a sua vida…
em vez de ver esse erro num abiente web joga dentro de uma class normal
com metodo mais e coloca la um teste com hibernate

Ou criar um TestCase para sua configuracao

funciona bem mais rapido do que
iniciar servidor…
carregar… struts…
etc etc…

[]´s

Criado 19 de maio de 2006
Ultima resposta 19 de mai. de 2006
Respostas 1
Participantes 2