Updating the jdbc connector
Quote from zkiwi34 on 6. January 2025, 23:15I'm running MariaDB and the default/built-in jdbc connector is very much out of date
As far as I can see, the only way to update that is to essentially re-install Jasper Server
I am very much hoping I am wrong.
I'm running MariaDB and the default/built-in jdbc connector is very much out of date
As far as I can see, the only way to update that is to essentially re-install Jasper Server
I am very much hoping I am wrong.
Quote from Gustaf Folger on 7. January 2025, 11:49Hello, it should be possible to simply stop the server, replace the driver and restart it.
Which application server and which versions of Jasperserver and Java you are using? With this information I may be able to give you some precise instructions / advice.
Hello, it should be possible to simply stop the server, replace the driver and restart it.
Which application server and which versions of Jasperserver and Java you are using? With this information I may be able to give you some precise instructions / advice.
Quote from zkiwi34 on 7. January 2025, 17:17I'm running Tomcat 9.0.97, Jasper Server CE 8.2, and JDK 8 (openJDK), with database MariaDB (10.11.6) on Debian (12.8)
I'm running Tomcat 9.0.97, Jasper Server CE 8.2, and JDK 8 (openJDK), with database MariaDB (10.11.6) on Debian (12.8)
Quote from Gustaf Folger on 10. January 2025, 8:50Hello, sorry for the late reply. I've done a bit of testing a system very similar to yours and I believe I've found the fix.
Step 1. Stop your tomcat
Step 2. Go to tomcat/lib and replace the old driver (should be mariadb-java-client-2.5.3.jar if you are using our provided files) with whichever more recent you want.
Step 3. If you are updating to any 2.X version, you can skip this step. If you are updating to a 3.X you will need to edit tomcat/webapps/jasperserver/META-INF/context.xml. Find the line starting with url="jdbc:mysql:// and replace it the "mysql" with "mariadb" so it looks like this: url="jdbc:mariadb://
Step 4. Start tomcat again
Hope this helps!
Hello, sorry for the late reply. I've done a bit of testing a system very similar to yours and I believe I've found the fix.
Step 1. Stop your tomcat
Step 2. Go to tomcat/lib and replace the old driver (should be mariadb-java-client-2.5.3.jar if you are using our provided files) with whichever more recent you want.
Step 3. If you are updating to any 2.X version, you can skip this step. If you are updating to a 3.X you will need to edit tomcat/webapps/jasperserver/META-INF/context.xml. Find the line starting with url="jdbc:mysql:// and replace it the "mysql" with "mariadb" so it looks like this: url="jdbc:mariadb://
Step 4. Start tomcat again
Hope this helps!