Re: [Hibernate] DBCP Connection Pooling (OT)

2003-08-30 Thread Patrick Burleson
At 08:40 AM 8/29/2003 -0400, Serge Knystautas wrote: Put the other shoe on... jakarta developers have the same set of bosses/wives/children who don't accept explanations of needing to write docs. Actually, my boss gets quite irate if I don't document things so that someone can come in and use ou

Re: [Hibernate] DBCP Connection Pooling (OT)

2003-08-29 Thread Gavin King
I know I am a broken record on this: Documenting your work is a part of writing code, just like writing unit tests. Code without documentation is useless. :) > At 05:16 AM 8/29/2003 +1000, Gavin King wrote: >>I think its better to direct these questions to the dbcp guys; dbcp is, >> as >>is u

Re: [Hibernate] DBCP Connection Pooling (OT)

2003-08-29 Thread Serge Knystautas
Patrick Burleson wrote: At 05:16 AM 8/29/2003 +1000, Gavin King wrote: I think its better to direct these questions to the dbcp guys; dbcp is, as is usual for Jakarta stuff, extremely undocumented - but _someone_ must know the answers to these questions. So you to have noticed how most Jakarta pr

Re: [Hibernate] DBCP Connection Pooling (OT)

2003-08-29 Thread Patrick Burleson
At 05:16 AM 8/29/2003 +1000, Gavin King wrote: I think its better to direct these questions to the dbcp guys; dbcp is, as is usual for Jakarta stuff, extremely undocumented - but _someone_ must know the answers to these questions. So you to have noticed how most Jakarta projects aren't documented

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Steven Citron-Pousty
I think this is a mysql issue. Two clues as to how you should set things up 1) you need to set autoreconnect to true for MySQL in the url. Please see http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations and look a

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Travis Reeder
Ya, c3p0 is better anyways. And Steve is always ready to help. Travis Gavin King wrote: I think its better to direct these questions to the dbcp guys; dbcp is, as is usual for Jakarta stuff, extremely undocumented - but _someone_ must know the answers to these questions. I *don't*; I've ALWAYS

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Serge Knystautas
Gavin King wrote: I think its better to direct these questions to the dbcp guys; dbcp is, as is usual for Jakarta stuff, extremely undocumented - but _someone_ must know the answers to these questions. I *don't*; I've ALWAYS used an appserver datasource in production. If you can't get definitive a

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Dave Tilley
Mark Woon, Mucho Gracias! I will give this a try! Thank you muchly!! Gavin - thanks for your help and comments. I will ask the DBCP folks for more details per your suggestion, since their online doc is pretty thin. I guess I was under the impression that lots of Hibernate users make use of

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Mark Woon
Dave Tilley wrote: I would *really* appreciate some guidance with this -- i will be happy to summarize what i learn and submit it for a FAQ or something if that will help so others will have this well-documented online somewhere. Dave, Here's a list of all the extra params I have to configure DBC

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Gavin King
I think its better to direct these questions to the dbcp guys; dbcp is, as is usual for Jakarta stuff, extremely undocumented - but _someone_ must know the answers to these questions. I *don't*; I've ALWAYS used an appserver datasource in production. If you can't get definitive answers from dbcp

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Juozas Baliuka
Looks like your settings are ok. But do not trust this feature too mutch. I prefer no workarounds in pools and to dissable all of this kind of "features". BTW it is verry trivial to implement a pool and to do it right way. You need to validate connection before the first operation in transaction o

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Dave Tilley
Connections only time out late at night or over the weekend when the web app in question is not being used. Normally, the web app is used heavily during the day until about 9pm and then no more until the next day. I want to take advantage of pooling with Hibernate when the app is being used he

Re: [Hibernate] DBCP Connection Pooling

2003-08-28 Thread Juozas Baliuka
Why do you need pooling if connections are time out. Close connection after transaction and open a new one before transaction without any kind of pooling. It must be very trivial to implement this kind of DataSource, a few lines of code. > > Ok, I am trying to get DBCP connection pooling working

[Hibernate] DBCP Connection Pooling

2003-08-28 Thread Dave Tilley
Ok, I am trying to get DBCP connection pooling working reliably (and not dropping connections)...so far i am not having much success. After a period of several hours of non-use, Hibernate will generate the familiar ioExcpetion when the connections are timed out. With that in mind, can someone g