Yep, I found this in the manual... Sorry for the premature email. 

Thanks,

Randall 

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel
Cecchet
Sent: Wednesday, May 02, 2007 8:58 AM
To: Sequoia general mailing list
Subject: Re: [Sequoia] MySQL / Sequoia Driver Compliant

Randall,

> Here's the backend setup:
>
> <DatabaseBackend name="myDB" driver="com.mysql.jdbc.Driver"
>
> url="jdbc:mysql://10.1.1.8:3306/myDB"
>
> connectionTestStatement="call now()">
>
Your connection test statement is not correct. It should be "SELECT 1" 
for MySQL instead of "call now()".
Check the documentation for the appropriate test statement corresponding to
your database.

Hope this helps,
Emmanuel

--
Emmanuel Cecchet
Chief Scientific Officer, Continuent

Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685


_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
BEGIN:VCARD
VERSION:2.1
N:Fidler;Randall
FN:Randall Fidler
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20050926T075331Z
END:VCARD

Attachment: smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to