Re: Why do I need to restart my server
This works with most except for oracle which uses select 1 from dual parameter namevalidationQuery/name valueselect 1/value /parameter On Wed, 10 Mar 2004 [EMAIL PROTECTED] wrote: Date: Wed, 10 Mar 2004 16:49:21 +0530 From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Why do I need to restart my server Hi, Every time my database server connection goes down, I need to restart my Tomcat 5.0.19 to re-establish the connection. Why is this so? Is this a bug? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Why do I need to restart my server
Sent this a little too early. The reason for the validation query is that if it fails, it will restablish the connection. On Wed, 10 Mar 2004, Alex wrote: Date: Wed, 10 Mar 2004 07:26:26 -0500 (EST) From: Alex [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: Why do I need to restart my server This works with most except for oracle which uses select 1 from dual parameter namevalidationQuery/name valueselect 1/value /parameter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Why do I need to restart my server
Hi, I'm having the same problem, I want to ask which file should I edit according to the changes below? Thanks All. ---Original Message--- From: Tomcat Users List Date: 03/10/04 19:41:47 To: Tomcat Users List Subject: Re: Why do I need to restart my server This works with most except for oracle which uses select 1 from dual parameter namevalidationQuery/name valueselect 1/value /parameter On Wed, 10 Mar 2004 [EMAIL PROTECTED] wrote: Date: Wed, 10 Mar 2004 16:49:21 +0530 From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Why do I need to restart my server Hi, Every time my database server connection goes down, I need to restart my Tomcat 5.0.19 to re-establish the connection. Why is this so? Is this a bug? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] IncrediMail - Email has finally evolved - Click Here
RE: Why do I need to restart my server
Hi, The validation query parameter is for DBCP, which would be in server.xml or in your context's context.xml file if you're using the DBCP connection pooling as outlined in the JNDI DataSources How-To document. As an aside: the database server going down is a serious event. You need to carefully code your application for that case if it's likely to happen frequently. The validation query will prevent the pool from handing out bad connections, but it won't: - Magically make valid those connections used by your app at the moment the server goes down, - Necessarily prevent the pool from hanging or waiting for the server to come back up, potentially indefinitely (or throw a SQLException after a timeout, depending on your configuration). So I'm just saying it's not the complete solution ;) Yoav Shapira Millennium ChemInformatics -Original Message- From: Adrian Kristiawan [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 7:58 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Why do I need to restart my server Hi, I'm having the same problem, I want to ask which file should I edit according to the changes below? Thanks All. ---Original Message--- From: Tomcat Users List Date: 03/10/04 19:41:47 To: Tomcat Users List Subject: Re: Why do I need to restart my server This works with most except for oracle which uses select 1 from dual parameter namevalidationQuery/name valueselect 1/value /parameter On Wed, 10 Mar 2004 [EMAIL PROTECTED] wrote: Date: Wed, 10 Mar 2004 16:49:21 +0530 From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Why do I need to restart my server Hi, Every time my database server connection goes down, I need to restart my Tomcat 5.0.19 to re-establish the connection. Why is this so? Is this a bug? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] IncrediMail - Email has finally evolved - Click Here This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Why do I need to restart my server
Hi Alex, Where shold I specify the parameters? i.e in which .xml file Thank you, Best Regards, Uma - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Why do I need to restart my server
Shapira, I am using my own connection pooling concenpt. The server isn't going down because of my query executions but due to some other reason. If incase it goes down, I need to restart my tomcat. This is a big problem for me. How can I prevent this. Will using the parameters tag in server.xml file solve the problem? Thank you, Best Regards, Uma - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Why do I need to restart my server
Hi, I am using my own connection pooling concenpt. The server isn't going down because of my query executions but due to some other reason. If incase it goes down, I need to restart my tomcat. This is a big problem for me. How can I prevent this. Will using the parameters tag in server.xml file solve the problem? As I said previously, the validation query is for DBCP. If you're using your own connection pooling nothing you put in server.xml can help: you have to account for the server going down yourself. That's one of the reasons most people don't choose to use their own connection pooling concept. Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]