topic Generic Database query plugin & MariaDB in Extensions

Generic Database query plugin & MariaDB

DanielS — Tue, 20 Aug 2024 10:07:25 GMT

Hello, I am using Generic DB Query Plugin (version 3.5.0) and MariaDB version below:

I don't see support for MariaDB but I do see support for MySQL, does anyone have this working? If yes, which version of JDBC are you using? Thanks

Re: Generic DB Query Plugin & MariaDB

david_lopes — Wed, 06 Sep 2023 17:23:21 GMT

This is not possible, both the driver class name and the connection string are built for MySQL. So we don't support MariaDB at this time.

You do have the option to edit the extension code and add this driver and connection string (making the extension unsupported), or get in touch with us (extensions team) for a paid engagement where we can add that support for you. You can get in touch with us via your account manager

Re: Generic DB Query Plugin & MariaDB

DanielS — Wed, 06 Sep 2023 17:35:43 GMT

Thanks @david_lopes

Re: Generic DB Query Plugin & MariaDB

andre_vdveen — Wed, 06 Sep 2023 19:46:26 GMT

Hi @DanielS, I know of one case where they successfully connected to MariaDB using the standard MySQL option. Instead of using jdbc:mariadb://localhost:3306/mydatabase for the connection string (which failed, by the way), they tried jdbc:mysql://localhost:3306/mydatabase and it worked.

It's worth a shot, but if it fails, pick an option that David suggested 😉