Re: how to connect to datasource

2011-11-09 Thread spike@12
No. I am using tomcat 6.0, java 6.0, linux system. Pid * wrote: On 09/11/2011 07:00, spike@12 wrote: Hi, I have setup my application using with tomcat and it is working fine. But when I have restarted my DB machine, my application is not working. If I have restart my tomcat server

Re: how to connect to datasource

2011-11-09 Thread chris derham
may I know, how to connect to datasource automatically if my DB machine is restarted?? Is it having any specific parameter to connect datasource automatically?? How does the existing app connect to the database? Can you show the code please - remove any sensitive passwords Thanks

Re: how to connect to datasource

2011-11-09 Thread Pid
On 09/11/2011 08:34, spike@12 wrote: Please don't top-post. Read: http://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html Pay attention to the paragraph which refers to the 'validationQuery' attribute. No. I am using tomcat 6.0, java 6.0, linux system. Crikey. That changes

Re: how to connect to datasource

2011-11-09 Thread spike@12
now it is working fine, after adding validationQuery,testOnBorrow parameters. Thanks to all. billybob79 wrote: may I know, how to connect to datasource automatically if my DB machine is restarted?? Is it having any specific parameter to connect datasource automatically??

Re: how to connect to datasource

2011-11-09 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 spike@12, On 11/9/11 8:59 PM, spike@12 wrote: now it is working fine, after adding validationQuery,testOnBorrow parameters. Note that testOnBorrow=true is the default, so you don't really need to set it. - -chris -BEGIN PGP SIGNATURE-

Re: how to connect to datasource

2011-11-08 Thread Pid
On 09/11/2011 07:00, spike@12 wrote: Hi, I have setup my application using with tomcat and it is working fine. But when I have restarted my DB machine, my application is not working. If I have restart my tomcat server then it is working fine. may I know, how to connect to datasource