Be careful if you use Hibernate with C3P0. If you're not using the latest Hibernate, the C3P0 connection pools may never be closed if you shut down only your webapp (not your whole Application Server). In early Betas of Hibernate v2.1.3 I had problems where my C3P0 pools weren't closing down when I shut down my individual webapp. I tracked it down to the Hibernate C3P0ConnecitonProvider class: the close() method was empty / did nothing! The CVS repository shows that code was added to the C3P0 related close() as of June 4th, 2004, which I'm guessing means it is not in v2.1.3 but in the v2.1.4 beta.
Regards, David -----Original Message----- From: Joe Hertz [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 6:11 AM To: 'Struts Users Mailing List' Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem > 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. Interesting. Going to C3P0 totally fixed this for me, and I'm using the supposedly stable 3.0 driver. I was getting the *exact* same message. I'm guessing it's a combination of the 2.0 drivers having a longer timeout than the 3.0 drivers do and bad^H^H^H questionable DBCP support in hibernate :-) Marco, please tell us what winds up happening with your app. I'm now very curious. > > [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 > :) ) Haven't done it myself. 2.1.x fought with old version of JBuilder, so it's only recently I moved to 2.1.4 Personally I don't trust the database to store my uploaded file data for me, but that's a very uninformed opinion. I trust Hibernate to do most things...but I'm not going to put it into the position of needing to be smarter than I think it can be either. What happens if it inner joins into the table with a blob column in it? How long does it take to retrieve a row with a large blob? I don't know any of this, and it could be no big deal, but it's I've managed to deftly avoid needing the answer :-) That being said...I put the uploaded file onto disk some place and store the location of said file in a VARCHAR. While I hate the forum myself, I strongly suspect if you post a stack trace of an NPE, youre real likely to get an answer from someone on the dev team :-) -Joe > > > 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:[EMAIL PROTECTED] > >> 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:[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] > >> > >> > >> > > > > > > > > > --------------------------------------------------------------------- > > 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]
