Re: Bringing up DBCP pooling again
Andrew Conrad wrote: You might get more responses if you post it to [EMAIL PROTECTED] If anyone gets an answer to this question, could it be circulated here, as well? Most of us would like to know. A DB server rebooting scenario is not all that impossible. And if it happens on Saturday night, who's gonna fix it and when, unles the pool automagically re-connects? Nix. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Bringing up DBCP pooling again
On Saturday, September 7, 2002, 10:15:04 AM, Nikola Milutinovic wrote: NM Andrew Conrad wrote: You might get more responses if you post it to [EMAIL PROTECTED] I posted my question there. Not a very active list. Only received like 3 e-mails over the past two days. Of course no answer to my question:) NM If anyone gets an answer to this question, could it be circulated here, as well? NM Most of us would like to know. A DB server rebooting scenario is not all that NM impossible. And if it happens on Saturday night, who's gonna fix it and when, NM unles the pool automagically re-connects? Exactly. The problem is compounded more when your DBA doesn't have a clue about the Tomcat server running on a different box, so if even the DBA is called in to make sure the database is all up and ok, it would be nice of any pooling would take care of itself without having to restart the Tomcat server. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Bringing up DBCP pooling again
You might get more responses if you post it to [EMAIL PROTECTED] - Andrew -Original Message- From: Rick Reumann [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 4:38 PM To: Tomcat Users List Subject: Bringing up DBCP pooling again Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Bringing up DBCP pooling again
Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Bringing up DBCP pooling again
I had this same problem and would love to hear a solution. (Sorry to post a me too message, but I've seen several versions of this question go unanswered. I guess it's a little off-topic, but there isn't a DBCP-user list. Here's to hoping a DBCP guru is listening.) Cindy At 04:37 PM 9/5/02 -0400, Rick Reumann wrote: Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Bringing up DBCP pooling again
On Thursday, September 5, 2002, 5:09:00 PM, Cindy wrote: CB I had this same problem and would love to hear a solution. Actually I had the same problem with some other pools I've tried as well. It's very frustrating to say the least. CB At 04:37 PM 9/5/02 -0400, Rick Reumann wrote: Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re[2]: Bringing up DBCP pooling again
On Thursday, September 5, 2002, 5:09:00 PM, Cindy Ballreich wrote: SNIP CB Here's to hoping a DBCP guru is listening.) Guess, no luck so far with the gurus out there:) CB At 04:37 PM 9/5/02 -0400, Rick Reumann wrote: Just bringing up a question I had a while ago since I know how lists go and it's easy to miss/delete messages over time (especially as busy a list as this is:) Anyway... Was wondering if anyone had any further input in the apparent problem using DBCP pooling with Tomcat. If for some reason the connections are killed (whether on purpose or if a DB goes down and comes back up), any applications that use the DBCP pool break and give the error: java.sql.SQLException: ORA-01012: not logged on I even made sure to provide a validation query in my ResourceParams. Has anyone else encountered this? Is there a work around or some other pool that this will not happen with? Thanks for any help. -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] CB -- CB To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] CB For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Rick mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]