New POOL connection in Glassfish is giving error

Asked

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: inserir a descrição da imagem aqui

The configured properties: inserir a descrição da imagem aqui inserir a descrição da imagem aqui

Someone can help us out?

glassfish

  • 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).

  • I added the properties to the question, Flávio

  • 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.

1 answer

1


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 !

Browser other questions tagged glassfish

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