DBCP connection problem
Posted by: max leung
Date: April 01, 2010 01:49AM

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


Options: ReplyQuote

Written By
DBCP connection problem
April 01, 2010 01:49AM
April 01, 2010 02:01AM
April 15, 2010 03:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.