DBCP connection problem

[max leung]

Hi all,

When I connect MySQL 5.1.37 with GlassfishV2,

I create a new connection pool datasource,

And I fail to ping the MySQL server in the Glassfish admin console.

The error message is "unknown command".

In addition, I cannot connect to the MYSQL 5.1.37 through Glassfish.

And below show a log,

[#|2010-03-31T10:31:12.069+0800|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8181-3;KnowledgePool;Unknown command;_RequestID=3f4c1503-5d96-41e0-86f3-d5f94c35e5de;|RAR5038:Unexpected exception while creating resource for pool KnowledgePool. Exception : Unknown command|#]

[#|2010-03-31T10:31:12.069+0800|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8181-3;KnowledgePool;Unknown command;_RequestID=3f4c1503-5d96-41e0-86f3-d5f94c35e5de;|RAR5117 : Failed to obtain/create connection from connection pool [ KnowledgePool ]. Reason : Unknown command|#]

[#|2010-03-31T10:31:12.070+0800|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8181-3;Error in allocating a connection. Cause: Unknown command;_RequestID=3f4c1503-5d96-41e0-86f3-d5f94c35e5de;|RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Unknown command]|#]

[#|2010-03-31T10:31:12.070+0800|SEVERE|sun-appserver9.1|com.iconventure.sql.SqlFactory$PlainSelectSqlFactory|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8181-3;java.sql.SQLException: Error in allocating a connection. Cause: Unknown command......

Everything is ok before upgrade to MySQL 5.1.37

Please help

Max