I also use this approach, something else you could also do is the SQL that is being executed can explicitly use a fully-qualified name of the table. I.E. authTest.table_name instead of just table_name in your SQL statement
Alex Sherwin
alex.sherwin_at_acadiasoft.com
-----Original Message-----
From: glassfish_at_javadesktop.org [mailto:glassfish_at_javadesktop.org]
Sent: Monday, August 04, 2008 4:45 PM
To: users_at_glassfish.dev.java.net
Subject: Re: mysql connection pool wont validate
Can you try adding another property from connection pool properties (those previously defined can stay):
URL:jdbc:mysql://localhost:3306/authTest
I had the same problem. Somehow it didn't understand databaseName property so i added it to the end of url and it worked.
Bilgehan
[Message sent by forum member 'bilgehan' (bilgehan)]
http://forums.java.net/jive/thread.jspa?messageID=291426
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net