New POOL connection in Glassfish is giving error

Question

Asked 9 years ago

Viewed 153 times

2

I’m trying to make a new Connection POOL on Glassfish, but when I try it on "Ping" it shows the following error:

The configured properties:

Someone can help us out?

this admin@locahost is weird. How are the properties of the pool connection? To not expose your information you put fake password and ip (if you have it).

– Flavio Andrade

2015/12/15 at 15:59
I added the properties to the question, Flávio

– Victor Hugo

2015/12/15 at 16:09
Cool, come on, do you really use all these rs properties? If you do not use and were already like this for something basic you only need the User, Password and URL properties, you can delete all the others. In the URL you place the IP of the database or localhost if applicable jdbc:mysql://locahost:3306/umariadb.

– Flavio Andrade

2015/12/15 at 16:48

1 answer

Browser other questions tagged glassfish

You are not signed in. Login or sign up in order to post.

by pmreis • 26 points · Answer 1 · 2016-02-12T15:41:25+00:00

You don’t need all these settings.

Create a JDBC Connection pool in glassfish with the configs below:

datasource-classname: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
res-type=javax.sql.ConnectionPoolDataSource

Then click on aditional properties and place these properties

> name="User" value="NameUSER" 
> name="Password" value="yourpass"
> name="serverName" value="localhost" 
> name="databaseName" value="databasename"

This should work !