Hello,
If I remember correct, mysql connector 3.0.11
Regards
marco
-----Original Message-----
From: Mark Lowe [mailto:[EMAIL PROTECTED]
Sent: 30 July 2004 09:36
To: Struts Users Mailing List
Subject: Re: OT/ Tomcat, Hibernate and MYSQL problem
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
