Thanks everyone that has replied has been most helpful. I'm not going to argue with someone that knows alot about databases, as i'm just getting into oracle. thanks again, Rob (i'll use the select sysdate from dual command) Geeta Ramani <[EMAIL PROTECTED]> wrote: > Rob: > > Sanjesh Pathak suggested earlier (in response to my earlier email) the query: > "select sysdate from dual". I checked with our local database expert who also > concurred that that was probably the best (least expensive?) call to make.. Did > you miss that note? Or maybe you dont agree? > > As for why your query failed, I am afraid I am not a database expert by *any* > means, so you want to take the following opinion with the scorn it deserves(!): > Try instead "select 0 from aTable" where "aTable" is the name of a table/view in > your database. > > Geeta > > Rob Hazlewood wrote: > > > 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 > > ___________________________________________________________________________ > 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
