Unable to Connect to MemSQL using Katalon 7.3.0

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.

@priyaraj
What MemSQL version do you use?

MySQL Workbench 6.3

@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

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

@priyaraj

Please share the screenshot of your settings using mariadb connector

@priyaraj

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

Now new error message popped up

Please append Connection URL with:
trustServerCertificate=true

@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:

Please check. Still getting the same issue for Katalon 7.3