How to connect payara and MySQL?

Question

I want to connect payara server with MySQL server.

What I did?

I downloaded connector/J for MySQL.

I placed it in C:\Users\someUser\Desktop\payara5\glassfish\domains\domain1\lib\ext

I started payara server.

I created Connection Pool on localhost:4848.

I tried to ping but I had errors each time.

Details:

• Payara version: 5.182
• Connector: I tried mysql-connector-java-8.0.17.jar and after that mysql-connector-java-5.1.48-bin.jar because I have read that there is some problem with the newest version.
• I tried to place both of connectors in different places:
  C:\Users\someUser\Desktop\payara5\glassfish\domains\domain1\lib\ext, C:\Users\someUser\Desktop\payara5\glassfish\domains\domain1\lib,
  C:\Users\someUser\Desktop\payara5\glassfish\lib.
• I also tried to remove sun folder from grizzly-npn-bootstrap.jar.
• Connection Pool: ResourceType I tried DataSource, XADataSource, Connection Pool DataSource.

• DataSource Classname I tried to change it from
  com.mysql.jdbc.jdbc2.optional.MysqlDataSource to
  com.mysql.jdbc.MysqlDataSource to follow someones advice.

• Properties: password, user/username (the same I use in MySQL Workbench), serverName: localhost, databaseName (the same I created in MySQL Workbench), portNumber: 3306 (I haven't changed), url:jdbc:mysql://localhost:3306/name_db.

Errors that occured:

• Class name is wrong or classpath is not set for : com.mysql.jdbc.Driver
• java.lang.NoSuchMethodError: sun.security.ssl.SSLSessionImpl.(Lsun/security/ssl/ProtocolVersion;Lsun/security/ssl/CipherSuite;Ljava/util/Collection;Lsun/security/ssl/SessionId;Ljava/lang/String;I)V
• Communication Link Failure

After trying to ping each time error occured. Each time I changed something I restarted server. I also downloaded payara again and tried. I also checked and MySQL server is running. What I did wrong or what else can I try?

Answer 1

https://dev.mysql.com/downloads/connector/j/ download mysql driver jar through the following command add jar to payara asadmin add-library /path/to/mysql-connector-java-bin.jar delete before pool,and restart payara build new pool this is work for me

Answer 2

I tried to configure MySql using the GUI, but I wasn't successful. I tried many ways (as described in other thread within stack overflow) to fix the issue, but was never successful using the GUI. But I tried creating the connection pool from the command prompt and was successful in the first attempt.

create-jdbc-connection-pool --ping --restype javax.sql.DataSource --datasourceclassname com.mysql.cj.jdbc.MysqlDataSource --property user=root:password=password:DatabaseName=test:ServerName=127.0.0.1:port=3306:useSSL=false:zeroDateTimeBehavior=CONVERT_TO_NULL:useUnicode=true:serverTimezone=UTC:characterEncoding=UTF-8:useInformationSchema=true:nullCatalogMeansCurrent=true:nullNamePatternMatchesAll=false MySqlPool

I would suggest others facing problem while creating connection pool via GUI, to try from the command prompt using 'asadmin'

Answer 3

Try this with asadmin

create-jdbc-connection-pool --ping --restype javax.sql.DataSource --datasourceclassname com.mysql.cj.jdbc.MysqlDataSource --property user=root:password=password:DatabaseName=dbname:ServerName=127.0.0.1:port=3306:useSSL=false:zeroDateTimeBehavior=CONVERT_TO_NULL:useUnicode=true:serverTimezone=UTC:characterEncoding=UTF-8:useInformationSchema=true:nullCatalogMeansCurrent=true:nullNamePatternMatchesAll=false MySqlPool