[GLASSFISH-20846] MySQL connection pool is not working Created: 05/Oct/13  Updated: 20/Dec/16  Resolved: 19/Oct/13

Status: Closed
Project: glassfish
Component/s: jdbc
Affects Version/s: 4.0_dev
Fix Version/s: None

Type: Bug Priority: Blocker
Reporter: ajeh Assignee: sfelts
Resolution: Works as designed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

GlassFish Server Open Source Edition 4.0 (build 89)
Linux 2.6.35.14-96.fc14.x86_64 #6 SMP PREEMPT Mon Jan 16 14:47:34 EST 2012 x86_64 x86_64 x86_64 GNU/Linux



 Description   

GF adds @localhost to any value of MySQL 'user' additional property of jdbc connection pool and that fails connection.
Error:

An error has occurred Ping Connection Pool failed for BuilderDBPool. Connection could not be allocated because: Access denied for user 'jdbcGB'@'localhost' (using password: YES) Please check the server.log for more details. An error has occurred
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.



 Comments   
Comment by ajeh [ 09/Oct/13 ]

This can be closed. The issue was that undocumented, but recommended to me 'URL' additional property overrode the documented additional properties.

Comment by sfelts [ 19/Oct/13 ]

Originator fixed problem in configuration.

Generated at Sun Jan 22 17:31:34 UTC 2017 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.