Sanjesh, thanks! I really was looking for something like this from someone who knows
databases. Thanks again!
Geeta
Sanjesh Pathak wrote:
> Hi,
>
> I didn't know about this. I always thought java.sql.Connection.isClosed() told you
> whether the connection to the database still exists or not. If what you all mention
> is indeed the case, then in my opinion the most inexpensive SQL statement would be to
> use "select sysdate from dual" to check whether the connection is still alive.
>
> Sanjesh
>
> Geeta Ramani wrote:
>
> > Rob, we had the same problem and while waiting for a more brilliant idea(!!),
> > wrote a function which returned true or false depending on whether the connection
> > could execute a simple query like "select user_name from user_tables". Throw the
> > execution of the query within a try/catch block, and ..well, I'm sure you can
> > fill in the rest.
> >
> > Good luck and if you come up with a better solution please do let me know!
> > Geeya
> >
> > Rob Hazlewood wrote:
> >
> > > java.sql.Connection.isClosed()
> > > doesn't achieve the purpose that i want it for.
> > > isClosed() only checks to see if the client has closed the connection, not if
> > > the connection with the server has been lost. What is the best alternative??
> > > (so if the connection is lost, a function will return true)
> > >
> > > thanks
> > > Rob
> > >
> > > ____________________________________________________________________
> > > Get free email and a permanent address at http://www.netaddress.com/?N=1
> > >
> > > ___________________________________________________________________________
> > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > > Resources: http://java.sun.com/products/servlet/external-resources.html
> > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> > ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
