<< Back to previous view

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

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

Type: Bug Priority: Blocker
Reporter: ajeh Assignee: sfelts
Resolution: Works as designed Votes: 0
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


Tags:
Participants: ajeh and sfelts

 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 09:01 PM ]

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 11:39 PM ]

Originator fixed problem in configuration.

Generated at Fri Apr 18 16:24:56 UTC 2014 using JIRA 4.0.2#472.