[hibernate-dev] TransactionException

[Xinsheng Chen]

Hi,

 

I am using 

 

hibernate-3.2.6.ga

mysql-connector-java-5.1.5

spring-framework-2.5.1

liferay-portal-tomcat-6.0-4.3.6

 

My portlet application runs fine for most of the time.
However, in the morning when I run the Web application
and save user input into the database at the first
try, it throws exception. I got the following from
Tomcat Catalina.out.

 

2008-05-06 14:41:17,461 WARN
[org.springframework.web.portlet.DispatcherPortlet] -
Handler execution resulted in exception - forwarding
to resolved error view

org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction;
nested exception is
org.hibernate.TransactionException: JDBC begin failed:

        at
org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:521)

 

        at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

        at java.lang.Thread.run(Thread.java:619)

Caused by: org.hibernate.TransactionException: JDBC
begin failed:

        at
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)

        at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)

        at
org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:490)

        ... 110 more

Caused by:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure

 

I have browsed some Web sites. It is said that the
problem is stale database connection. Following the
advice I have added the following lines in my
hibernate configuration file:

 

                                                <prop
key="hibernate.c3p0.acquire_increment">3</prop>

                                                <prop
key="hibernate.c3p0.idle_test_period">30</prop>

                                                <prop
key="hibernate.c3p0.timeout">60</prop>

                                                <prop
key="hibernate.c3p0.max_size">15</prop>

                                                <prop
key="hibernate.c3p0.max_statements">0</prop>

                                                <prop
key="hibernate.c3p0.min_size">3</prop>

 

 

But it does not help.

 

Any help would be appreciated!

 

Regards,

Robert Chen

 



      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ