Wow - fast answer there Mike - thanks! We'll keep a copy of the RockyLinux8 version around then
On Mon, Jan 16, 2023 at 10:17 AM Michael Jumper <[email protected]> wrote: > On Sun, Jan 15, 2023, 1:04 PM Jason Haar <[email protected]> wrote: > >> ... >> Error querying database. Cause: java.sql.SQLException: No suitable >> driver found for jdbc:mysql://127.0.0.1:3306/guacamole >> ... >> After messing around for some time I thought to try >> replacing mariadb-java-client.jar file with the RockyLinux8 version and >> that fixed the problem. Rocky8 has mariadb-java-client-2.7.1-2.el8 and >> Rocky9 has mariadb-java-client-3.0.3-1.el9 >> > > This is because MariaDB Connector/J 3.x has dropped support for the > "jdbc:mysql:" URI format, now requiring that code using the driver either > use "jdbc:mariadb:" or explicitly specify a "permitMysqlScheme" attribute: > > > https://mariadb.com/kb/en/about-mariadb-connector-j/#jdbcmysql-scheme-compatibility > > The "JDBCHelper" class from MyBatis Guice that we've been using uses > "jdbc:mysql:" for both the MySQL and MariaDB versions of the driver, hence > the failure. Code changes on either our side or within MyBatis would be > needed to be compatible with 3.x. > > The 2.x version of the driver should work perfectly. > > - Mike > > -- Cheers Jason Haar CyberSecurity Manager, Trimble Ltd. Phone: +1 408 481 8171 PGP Fingerprint: 7A2E 0407 C9A6 CAF6 2B9F 8422 C063 5EBB FE1D 66D1
