Unable to Connect to MemSQL using Katalon 7.3.0

[priyaraj]

I created my project and developed script using Katalon 6.3.3.

I am connecting to MemSQL using below piece of code;
connection_string = jdbc:mysql://localhost:port/DB_NAME
connection = DriverManager.getConnection(connection_string, userID ,password)

It was working perfectly fine and I was able to connect to MemSQL.

Now I have switched to 7.3.0.
I have got below issue after upgrading to 7.3.0.
SQLException.getMessage() = Unknown system variable ‘performance_schema’
SQLException.getCause()= null

Screenshot of connecting database from Katalon ->Settings ->Database:
Same issue exists

Please help.

[duyluong]

@priyaraj
What MemSQL version do you use?

[priyaraj]

MySQL Workbench 6.3

[duyluong]

@priyaraj

You can try with Maria JDBC connector: https://docs.memsql.com/client-downloads/#mariadb-connector-j-jdbc-version-2-4-0-lgplv2-1

Please follow instruction: https://docs.katalon.com/katalon-studio/docs/database-settings.html#example

[priyaraj]

I tried the solution you provided.
Still the same issue exists.

[duyluong]

@priyaraj

Please share the screenshot of your settings using mariadb connector

[priyaraj]

[duyluong]

@priyaraj

Please change:
JDBC driver: org.mariadb.jdbc.Driver
Connection URL: jdbc:mariadb://—

[priyaraj]

@duyluong

jdbc:mariadb

Now new error message popped up

[duyluong]

Please append Connection URL with:
trustServerCertificate=true

Using TLS/SSL with MariaDB Connector/J

[priyaraj]

[duyluong]

@priyaraj
Seem like the workaround solution above doesn’t work.

Let try another,

1. Please download mysql-connector-java-5.1.38.jar (the same version in Katalon Studio v6.3.3)
2. Add the jar above to External Libraries
3. Change Database settings:

• JDBC driver: com.mysql.jdbc.Driver
• Connection URL: the same value as it’s in v6.3.3
  
  

[priyaraj]

Please check. Still getting the same issue for Katalon 7.3