You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Bryan Hunt <ad...@revoltingdigits.com> on 2004/07/30 12:08:19 UTC
Re: OT/ Tomcat, Hibernate and MYSQL problem ( byte to blob )
My app is able to do it no problem, back and forth.
You can get the source code from http://jestate.revoltingdigits.com/
ie.jestate.struts.action.ImageUploadAction
My code is a mess at the moment but that code is working.
--b
Mark Lowe wrote:
> I've had the same thing happen using DBCP and C3PO, I believe its the
> driver rather than the pooling. As I said we've a app thats live, and
> i haven't touched it in months using DBCP.
>
> [OT] subject change.. Have you had any joy with byte[] to blob mapping
> for file uploads with hibernate 2.1.4? I created a custom usertype,
> but i get a npe. 2.0 delbt with life, but things appear to have taken
> a step backwards. (please dont make me go the the scary hibernate
> forum :) )
>
>
> On 30 Jul 2004, at 11:34, Joe Hertz wrote:
>
>> I noticed this behavior with 3.0.14.
>>
>> This _really_ sounds like this entry in the Hibernate FAQ to me:
>>
>> http://www.hibernate.org/117.html#A13
>>
>> I wouldn't use DBCP though as Gavin King is apparently fed up with it,
>> and built-in support for it is being yanked in the next major version of
>> Hibernate.
>>
>>> -----Original Message-----
>>> From: Marco Mistroni [mailto:mmistroni@waersystems.com]
>>> Sent: Friday, July 30, 2004 5:08 AM
>>> To: 'Struts Users Mailing List'
>>> Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem
>>>
>>>
>>> Hello,
>>> If I remember correct, mysql connector 3.0.11
>>>
>>> Regards
>>> marco
>>>
>>> -----Original Message-----
>>> From: Mark Lowe [mailto:mark.lowe@boxstuff.com]
>>> 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:mmistroni@waersystems.com]
>>>>> 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: user-help@struts.apache.org
>>>>>
>>>>>
>>>>>
>>> ---------------------------------------------------------------------
>>>
>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>> ---------------------------------------------------------------------
>>>
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: OT/ Tomcat, Hibernate and MYSQL problem ( byte to blob )
Posted by Mark Lowe <ma...@boxstuff.com>.
Solved it but its a bit of a pain..
You need to set the column type to blob (in mysql) but the hibernate
type to binary.. So if you're generating the the sql from the mapping
files then its a bit of a mess.
/**
* @hibernate.property column="image" type="binary"
*/
this generates a column of type varchar length 255 with the binary
option, i changed the column type to blob and it seems to deal with
life.. I guess i'll need to write a correction script or something.
But in terms of programming everything behaves as one who expect of a
OM framework (i.e makes life easier rather than adding addition
complication)
To be fair the hibernate docs do say that blob support is patchy
between vendors.
mark
On 30 Jul 2004, at 12:30, Mark Lowe wrote:
> Hi Bryan
>
> Just downloaded the latest, but the action just prints a test message..
>
> System.out.println("at least i managed to get called");
>
> The problem isn't with form file, thats fine.. Its when I try and save
> to the db
>
>
> //hibernate stuff
>
> /**
> * @hibernate.property column="image" type="blob"
> */
> public byte[] getImage() {
> return image;
> }
>
> public void setImage(byte[] image) {
> this.image = image;
> }
>
> Now i created a custom user type like were required with older
> versions of hibernate..
>
> /**
> * @hibernate.property column="image"
> type="com.sparrow.hibernate.type.Image"
> */
>
> http://www.hibernate.org/73.html
>
> but when i try and save now i get a null pointer exception with not
> much else to go on (before it was a class cast exception). I'd have
> thought that creating a custom user type was a bit old hat as 2.0
> loved it..
>
> The only other thing i can think its down to is the jdbc driver..
> Which i'm investigating now.
>
>
> On 30 Jul 2004, at 12:08, Bryan Hunt wrote:
>
>> My app is able to do it no problem, back and forth.
>>
>> You can get the source code from http://jestate.revoltingdigits.com/
>>
>> ie.jestate.struts.action.ImageUploadAction
>>
>> My code is a mess at the moment but that code is working.
>>
>> --b
>>
>>
>> Mark Lowe wrote:
>>
>>> I've had the same thing happen using DBCP and C3PO, I believe its
>>> the driver rather than the pooling. As I said we've a app thats
>>> live, and i haven't touched it in months using DBCP.
>>>
>>> [OT] subject change.. Have you had any joy with byte[] to blob
>>> mapping for file uploads with hibernate 2.1.4? I created a custom
>>> usertype, but i get a npe. 2.0 delbt with life, but things appear to
>>> have taken a step backwards. (please dont make me go the the scary
>>> hibernate forum :) )
>>>
>>>
>>> On 30 Jul 2004, at 11:34, Joe Hertz wrote:
>>>
>>>> I noticed this behavior with 3.0.14.
>>>>
>>>> This _really_ sounds like this entry in the Hibernate FAQ to me:
>>>>
>>>> http://www.hibernate.org/117.html#A13
>>>>
>>>> I wouldn't use DBCP though as Gavin King is apparently fed up with
>>>> it,
>>>> and built-in support for it is being yanked in the next major
>>>> version of
>>>> Hibernate.
>>>>
>>>>> -----Original Message-----
>>>>> From: Marco Mistroni [mailto:mmistroni@waersystems.com]
>>>>> Sent: Friday, July 30, 2004 5:08 AM
>>>>> To: 'Struts Users Mailing List'
>>>>> Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem
>>>>>
>>>>>
>>>>> Hello,
>>>>> If I remember correct, mysql connector 3.0.11
>>>>>
>>>>> Regards
>>>>> marco
>>>>>
>>>>> -----Original Message-----
>>>>> From: Mark Lowe [mailto:mark.lowe@boxstuff.com]
>>>>> 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:mmistroni@waersystems.com]
>>>>>>> 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: user-help@struts.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>> -------------------------------------------------------------------
>>>>> --
>>>>>
>>>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>> -------------------------------------------------------------------
>>>>> --
>>>>>
>>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>
>>>>>
>>>>>
>>>>> -------------------------------------------------------------------
>>>>> --
>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>
>>>>>
>>>>> -------------------------------------------------------------------
>>>>> --
>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --------------------------------------------------------------------
>>>> -
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: OT/ Tomcat, Hibernate and MYSQL problem ( byte to blob )
Posted by Mark Lowe <ma...@boxstuff.com>.
On 30 Jul 2004, at 14:19, bryan wrote:
> I am using the following mysql driver
>
> -rwxr-xr-x 1 Administ Aucun 321671 Jul 2 13:47
> /c/bryan-website/jakarta
> -tomcat-5.0.14/common/lib/mysql-connector-java-3.1.1-alpha-bin.jar
>
> and it has worked fine for me previously .
>
> I would carry out some checks on the struts action to verify the size
> of the data.
Sure that stuff works.. Its when i attempt to save the object that has
a property or type byte[] (class cast exception) and a trusty old NPE
when i use my own custom type. Its really annoying, given that it works
with 2.0.. Perhaps those crazy hibernate kids thought it was too easy.
>
> Also check for the following
> <form enctype="multipart/form-data"
>
> --b
>
> On Fri, 30 Jul 2004 12:30:45 +0200, Mark Lowe <ma...@boxstuff.com>
> wrote:
>> Hi Bryan
>>
>> Just downloaded the latest, but the action just prints a test
>> message..
>>
>> System.out.println("at least i managed to get called");
>>
>> The problem isn't with form file, thats fine.. Its when I try and save
>> to the db
>>
>> //hibernate stuff
>>
>> /**
>> * @hibernate.property column="image" type="blob"
>> */
>> public byte[] getImage() {
>> return image;
>> }
>>
>> public void setImage(byte[] image) {
>> this.image = image;
>> }
>>
>> Now i created a custom user type like were required with older
>> versions
>> of hibernate..
>>
>> /**
>> * @hibernate.property column="image"
>> type="com.sparrow.hibernate.type.Image"
>> */
>>
>> http://www.hibernate.org/73.html
>>
>> but when i try and save now i get a null pointer exception with not
>> much else to go on (before it was a class cast exception). I'd have
>> thought that creating a custom user type was a bit old hat as 2.0
>> loved
>> it..
>>
>> The only other thing i can think its down to is the jdbc driver..
>> Which
>> i'm investigating now.
>>
>>
>>
>>
>> On 30 Jul 2004, at 12:08, Bryan Hunt wrote:
>>
>>> My app is able to do it no problem, back and forth.
>>>
>>> You can get the source code from http://jestate.revoltingdigits.com/
>>>
>>> ie.jestate.struts.action.ImageUploadAction
>>>
>>> My code is a mess at the moment but that code is working.
>>>
>>> --b
>>>
>>>
>>> Mark Lowe wrote:
>>>
>>>> I've had the same thing happen using DBCP and C3PO, I believe its
>>>> the
>>>> driver rather than the pooling. As I said we've a app thats live,
>>>> and
>>>> i haven't touched it in months using DBCP.
>>>>
>>>> [OT] subject change.. Have you had any joy with byte[] to blob
>>>> mapping for file uploads with hibernate 2.1.4? I created a custom
>>>> usertype, but i get a npe. 2.0 delbt with life, but things appear to
>>>> have taken a step backwards. (please dont make me go the the scary
>>>> hibernate forum :) )
>>>>
>>>>
>>>> On 30 Jul 2004, at 11:34, Joe Hertz wrote:
>>>>
>>>>> I noticed this behavior with 3.0.14.
>>>>>
>>>>> This _really_ sounds like this entry in the Hibernate FAQ to me:
>>>>>
>>>>> http://www.hibernate.org/117.html#A13
>>>>>
>>>>> I wouldn't use DBCP though as Gavin King is apparently fed up with
>>>>> it,
>>>>> and built-in support for it is being yanked in the next major
>>>>> version of
>>>>> Hibernate.
>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Marco Mistroni [mailto:mmistroni@waersystems.com]
>>>>>> Sent: Friday, July 30, 2004 5:08 AM
>>>>>> To: 'Struts Users Mailing List'
>>>>>> Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem
>>>>>>
>>>>>>
>>>>>> Hello,
>>>>>> If I remember correct, mysql connector 3.0.11
>>>>>>
>>>>>> Regards
>>>>>> marco
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Mark Lowe [mailto:mark.lowe@boxstuff.com]
>>>>>> 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:mmistroni@waersystems.com]
>>>>>>>> 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: user-help@struts.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>> ------------------------------------------------------------------
>>>>>> --
>>>>>> -
>>>>>>
>>>>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> ------------------------------------------------------------------
>>>>>> --
>>>>>> -
>>>>>>
>>>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------
>>>>>> --
>>>>>> -
>>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------
>>>>>> --
>>>>>> -
>>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -------------------------------------------------------------------
>>>>> --
>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>> --------------------------------------------------------------------
>>>> -
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: OT/ Tomcat, Hibernate and MYSQL problem ( byte to blob )
Posted by bryan <ni...@gmail.com>.
I am using the following mysql driver
-rwxr-xr-x 1 Administ Aucun 321671 Jul 2 13:47 /c/bryan-website/jakarta
-tomcat-5.0.14/common/lib/mysql-connector-java-3.1.1-alpha-bin.jar
and it has worked fine for me previously .
I would carry out some checks on the struts action to verify the size
of the data.
Also check for the following
<form enctype="multipart/form-data"
--b
On Fri, 30 Jul 2004 12:30:45 +0200, Mark Lowe <ma...@boxstuff.com> wrote:
> Hi Bryan
>
> Just downloaded the latest, but the action just prints a test message..
>
> System.out.println("at least i managed to get called");
>
> The problem isn't with form file, thats fine.. Its when I try and save
> to the db
>
> //hibernate stuff
>
> /**
> * @hibernate.property column="image" type="blob"
> */
> public byte[] getImage() {
> return image;
> }
>
> public void setImage(byte[] image) {
> this.image = image;
> }
>
> Now i created a custom user type like were required with older versions
> of hibernate..
>
> /**
> * @hibernate.property column="image"
> type="com.sparrow.hibernate.type.Image"
> */
>
> http://www.hibernate.org/73.html
>
> but when i try and save now i get a null pointer exception with not
> much else to go on (before it was a class cast exception). I'd have
> thought that creating a custom user type was a bit old hat as 2.0 loved
> it..
>
> The only other thing i can think its down to is the jdbc driver.. Which
> i'm investigating now.
>
>
>
>
> On 30 Jul 2004, at 12:08, Bryan Hunt wrote:
>
> > My app is able to do it no problem, back and forth.
> >
> > You can get the source code from http://jestate.revoltingdigits.com/
> >
> > ie.jestate.struts.action.ImageUploadAction
> >
> > My code is a mess at the moment but that code is working.
> >
> > --b
> >
> >
> > Mark Lowe wrote:
> >
> >> I've had the same thing happen using DBCP and C3PO, I believe its the
> >> driver rather than the pooling. As I said we've a app thats live, and
> >> i haven't touched it in months using DBCP.
> >>
> >> [OT] subject change.. Have you had any joy with byte[] to blob
> >> mapping for file uploads with hibernate 2.1.4? I created a custom
> >> usertype, but i get a npe. 2.0 delbt with life, but things appear to
> >> have taken a step backwards. (please dont make me go the the scary
> >> hibernate forum :) )
> >>
> >>
> >> On 30 Jul 2004, at 11:34, Joe Hertz wrote:
> >>
> >>> I noticed this behavior with 3.0.14.
> >>>
> >>> This _really_ sounds like this entry in the Hibernate FAQ to me:
> >>>
> >>> http://www.hibernate.org/117.html#A13
> >>>
> >>> I wouldn't use DBCP though as Gavin King is apparently fed up with
> >>> it,
> >>> and built-in support for it is being yanked in the next major
> >>> version of
> >>> Hibernate.
> >>>
> >>>> -----Original Message-----
> >>>> From: Marco Mistroni [mailto:mmistroni@waersystems.com]
> >>>> Sent: Friday, July 30, 2004 5:08 AM
> >>>> To: 'Struts Users Mailing List'
> >>>> Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem
> >>>>
> >>>>
> >>>> Hello,
> >>>> If I remember correct, mysql connector 3.0.11
> >>>>
> >>>> Regards
> >>>> marco
> >>>>
> >>>> -----Original Message-----
> >>>> From: Mark Lowe [mailto:mark.lowe@boxstuff.com]
> >>>> 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:mmistroni@waersystems.com]
> >>>>>> 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: user-help@struts.apache.org
> >>>>>>
> >>>>>>
> >>>>>>
> >>>> --------------------------------------------------------------------
> >>>> -
> >>>>
> >>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> >>>>>> For additional commands, e-mail: user-help@struts.apache.org
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>> --------------------------------------------------------------------
> >>>> -
> >>>>
> >>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> >>>>> For additional commands, e-mail: user-help@struts.apache.org
> >>>>
> >>>>
> >>>>
> >>>> --------------------------------------------------------------------
> >>>> -
> >>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> >>>> For additional commands, e-mail: user-help@struts.apache.org
> >>>>
> >>>>
> >>>> --------------------------------------------------------------------
> >>>> -
> >>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> >>>> For additional commands, e-mail: user-help@struts.apache.org
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> >>> For additional commands, e-mail: user-help@struts.apache.org
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> >> For additional commands, e-mail: user-help@struts.apache.org
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: OT/ Tomcat, Hibernate and MYSQL problem ( byte to blob )
Posted by Mark Lowe <ma...@boxstuff.com>.
Hi Bryan
Just downloaded the latest, but the action just prints a test message..
System.out.println("at least i managed to get called");
The problem isn't with form file, thats fine.. Its when I try and save
to the db
//hibernate stuff
/**
* @hibernate.property column="image" type="blob"
*/
public byte[] getImage() {
return image;
}
public void setImage(byte[] image) {
this.image = image;
}
Now i created a custom user type like were required with older versions
of hibernate..
/**
* @hibernate.property column="image"
type="com.sparrow.hibernate.type.Image"
*/
http://www.hibernate.org/73.html
but when i try and save now i get a null pointer exception with not
much else to go on (before it was a class cast exception). I'd have
thought that creating a custom user type was a bit old hat as 2.0 loved
it..
The only other thing i can think its down to is the jdbc driver.. Which
i'm investigating now.
On 30 Jul 2004, at 12:08, Bryan Hunt wrote:
> My app is able to do it no problem, back and forth.
>
> You can get the source code from http://jestate.revoltingdigits.com/
>
> ie.jestate.struts.action.ImageUploadAction
>
> My code is a mess at the moment but that code is working.
>
> --b
>
>
> Mark Lowe wrote:
>
>> I've had the same thing happen using DBCP and C3PO, I believe its the
>> driver rather than the pooling. As I said we've a app thats live, and
>> i haven't touched it in months using DBCP.
>>
>> [OT] subject change.. Have you had any joy with byte[] to blob
>> mapping for file uploads with hibernate 2.1.4? I created a custom
>> usertype, but i get a npe. 2.0 delbt with life, but things appear to
>> have taken a step backwards. (please dont make me go the the scary
>> hibernate forum :) )
>>
>>
>> On 30 Jul 2004, at 11:34, Joe Hertz wrote:
>>
>>> I noticed this behavior with 3.0.14.
>>>
>>> This _really_ sounds like this entry in the Hibernate FAQ to me:
>>>
>>> http://www.hibernate.org/117.html#A13
>>>
>>> I wouldn't use DBCP though as Gavin King is apparently fed up with
>>> it,
>>> and built-in support for it is being yanked in the next major
>>> version of
>>> Hibernate.
>>>
>>>> -----Original Message-----
>>>> From: Marco Mistroni [mailto:mmistroni@waersystems.com]
>>>> Sent: Friday, July 30, 2004 5:08 AM
>>>> To: 'Struts Users Mailing List'
>>>> Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem
>>>>
>>>>
>>>> Hello,
>>>> If I remember correct, mysql connector 3.0.11
>>>>
>>>> Regards
>>>> marco
>>>>
>>>> -----Original Message-----
>>>> From: Mark Lowe [mailto:mark.lowe@boxstuff.com]
>>>> 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:mmistroni@waersystems.com]
>>>>>> 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: user-help@struts.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>> --------------------------------------------------------------------
>>>> -
>>>>
>>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> --------------------------------------------------------------------
>>>> -
>>>>
>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>> --------------------------------------------------------------------
>>>> -
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>> --------------------------------------------------------------------
>>>> -
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org