How to make a MariaDB SSH Connection in Katalon Studio?

Asked Jun 04 '19 at 18:40

Active May 04 '20 at 12:30

Viewed 253 times

My host does not allow direct database access and so I need to SSH into the MariaDB instance.

Has anyone had success with this approach in Katalon Studio?

The recommended JDBC connection will not suffice

@Keyword
def connectDB(String url, String dbname, String port, String username, String password){

    //Load driver class for your specific database type

    String conn = "jdbc:mysql://" + url + ":" + port + "/" + dbname

    //Class.forName("org.sqlite.JDBC")

    //String connectionString = "jdbc:sqlite:" + dataFile

    if(connection != null && !connection.isClosed()){

        connection.close()

    }
}

edited May 04 '20 at 12:30

Daemon Painter

3,208
3
29
44

asked Jun 04 '19 at 18:40

Josh Young

I don't know if there is something specific to MariaDB. What happens when you try the above code? – Mate Mrše Jun 06 '19 at 11:26
I've edited your code, in order to format `@keyword` in the snippet, and added a closing `}` at the end. – Daemon Painter May 04 '20 at 07:51
Might be helpful https://forum.katalon.com/t/unable-to-connect-to-memsql-using-katalon-7-3-0/42261/12 – Mate Mrše Mar 09 '21 at 15:09

How to make a MariaDB SSH Connection in Katalon Studio?

0 Answers0