Geeta,
I've been looking at a few different ideas
i'm using the "select 0" sql command, however when I tried typing that command
using the oracle odbc test program, it gave me an error. Is this a database
error, or just a problem with the small program??
is there a noop (no operation) type command?? because if there is that would
be the best solution. (not that it matters because i'm using alpha servers!)
thanks
let me know if you find a better way (wouldn't be hard!)
Rob
Geeta Ramani <[EMAIL PROTECTED]> 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
____________________________________________________________________
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
