users@glassfish.java.net

Re: Re: What are GF requirements for creating JDBC connection ...

From: NBW <emailnbw_at_gmail.com>
Date: Sat, 5 Oct 2013 14:25:42 -0400

It sounds like your connection pool properties are misconfigured for your
environment or you haven't got MySQL setup correctly.

Have you created the DB with the correct user and password in MySQL prior
to pinging it from the connection pool? Can you access the DB using that
user name and password from the mysql cmd line tool from the mysql distro?

If you can get that far check your connection pool properties to make sure
they are also in good shape.

Those are in the In the "Additional properties" tab of the JDBC Connection
Pools area in the admin GUI for your blankeyBuilderDBPool.

Also, if you open $GF_HOME/glassfish/domains1/domain1/config/domain.xml and
find the <jdbc-resource> with the pool-name attr of your pool and the
<jdbc-connection-pool> with the name attr of the associated jdbc-resource
and copy/paste them to the list and we can help verify your settings.

-Noah


On Sat, Oct 5, 2013 at 9:22 AM, <forums_at_java.net> wrote:

> New error: Ping Connection Pool failed for blanketBuilderDBPool. Connection
> could not be allocated because: Access denied for user 'jdbcGB'@
> 'localhost'
> (using password: YES) Please check the server.log for more details. GF is
> appending @'localhost' to the user name and that fails the logins. What
> now?
>
>
> --
>
> [Message sent by forum member 'ajeh']
>
> View Post: http://forums.java.net/node/**899077<http://forums.java.net/node/899077>
>
>
>