Connect to MariaDB

Classic Servoy
1

I am trying to connect to a MariaDB instance on a Synology NAS. For this I have downloaded a JDBC driver from mariadb.com and installed it in Developer.
So now in developer I can succesfully connect to the database on my NAS. Now I have deployed Servoy to a tomcat instance and I have included the drivers in the WAR file. But when I try to start the instance it will not start in the logs it says the driver cannot be found:

Caused by: java.sql.SQLException: JDBC Driver ‘org.mariadb.jdbc’ not found in classpath or drivers directory : java.lang.ClassNotFoundException: org.mariadb.jdbc or url ‘jdbc:mariadb://192.168.178.4/repository’ is not valid/accepted by the driver (if no suiteable driver found message): org.mariadb.jdbc

However I can see the mariadb.jar file in the deployed WEB-INF\lib folder.
As this is the first time I try to deploy using a different db as the default Postgresql I am mostlikely missing something, but what? Any ideas?

2

Check earlier in the logs and see if you see something like “Unsupported major.minor version”. You might be running an older version of java on the server, but the mariadb driver you are using might be only for java 8, so the jar won’t be seen.

3

After I created the WAR file, the invalid driver error was gone. However it still does not create the repository, I can see that 1 table is created but after that it seems the repository creation failed because of an incorrect SQL statement:

Caused by: com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLSyntaxErrorException: (conn=143) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘CLOB not null, revision INTEGER not null, sequence INTEGER not null, primary key’ at line 1

Is there anybody that has used MariaDB?