Here's my validation query...
<parameter>
<name>validationQuery</name>
<value>SELECT MAX(id) FROM Users</value>
</parameter>
The Database being used is Oracle 8i
Hope that helps.
Jake
At 07:59 PM 1/17/2003 -0800, you wrote:
I got a tip here from Craig about using a query in server.xml to make sure the
connection was good before executing a statement, but I lost it.
Is this correct?
<parameter>
<name>validationQuery</name>
<value>SELECT 0;</value>
</parameter>
Also, should I use ";" or not? an extra ";" will cause an error.
Garrett
=====
http://dhtmlkitchen.com/
JSP | Servlets | DHTML
Garrett Needs A Job
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
