Re: OT/ Tomcat, Hibernate and MYSQL problem

[Mark Lowe]

Marco

What jdbc driver are you using?

They was a shady version 3 behaving like this.

On 30 Jul 2004, at 10:05, Joe Hertz wrote:

Hibernate's internal connection pooling isn't meant for production
because it does things just like that.

Suggest you use c3p0 for the pooling.

From my hibernate.cfg.xml, I only had to add this:

       <property name="c3p0.minPoolSize">5</property>
       <property name="c3p0.maxPoolSize">20</property>
       <property name="c3p0.timeout">1800</property>
       <property name="c3p0.max_statement">50</property>

HTH

-Joe

-----Original Message-----
From: Marco Mistroni [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 3:58 AM
To: 'Struts Users Mailing List'
Subject: OT/ Tomcat, Hibernate and MYSQL problem

Hello,

        First of all, I apologize for the off topic issue..
I know this is not the list, but I tried hibernate forums,
and Searched the web with no solution.. hopefully some of u
had the Same problem and solved it..

I m experiencing problems with Hibernate in tomcat, talking to mysql.

My situation is that I didn't define any connection pools in
tomcat, but left it to Hibernate to handle that...

After leaving the application running for 11 hours, I got
following exception

hi all,
i have a webapp taht uses Hibernate and MYSQL, running on top
of tomcat.

i am letting Hibernate handle the connections to mysql db,
since i have no connection pools defined in tomcat.
after running the application for nearly 9 hours, when i
tried to use my app to connect to the database i got
following exception:

Caused by: net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1476)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:45)
at
com.myapp.hibernate.HibernatePersistenceManager.query(Hibernat
ePersisten
ceManager.java:205)
... 31 more
Caused by: java.sql.SQLException: Communication link failure:
java.net.SocketException, underlying cause: Software caused connection
abort: recv failed

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort:
recv failed

now i have searched the web and found two possible
alternatives.. one was to add following problems to hibernate
config file.. <property
name="connection.autoReconnect">true</property>
<property name="connection.autoReconnectForPools">true</property>
<property
name="connection.is-connection-validation-required">true</property>

but this does not work, as ihave added thos eproperties to
hibernate properties file and i am still getting same exception

then I tried to add ?autoReconnect=true  to JBDC URL, but
that didn't work either coz I left application running for 11
hours and after that I got same exception...

can anyone help me out?

THANX in advance and regards
        marco

l: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]