It turns out that I have picked the wrong ResourceType when creating the Pool. It has to be javax.sql.DataSource.
I picked java.sql.ConnectionPoolDataSource and that was causing the PING error. But, isn't this one that supports connection-pooling?
Anyway, the instruction for creating a MySQL Resource in GF is clearly stated in the MySQL Connector/J manual.
[Message sent by forum member 'arthury']
http://forums.java.net/jive/thread.jspa?messageID=483657