Issue after upgrade to confluence 7.2

Issue #93 resolved
Former user created an issue

After the upgrade i'm getting the following error on pages where the macro is placed.

Error rendering macro 'database-query-compact'

java/sql/Driver

The mssql driver is installed, and showing green on the config screen

Comments (10)

  1. Scott Selberg

    Hi, the indicator on the config page is not very intelligent. It simply indicates that a file with the right name is present - it does not test to make sure the driver is correct. The two primary reasons for the driver to be wrong are 1) you are running 64 bit java and have downloaded a 32 bit driver or vice versa. 2) you have a driver for a different version of than the one presently running.

    I think Confluence 7.1 or 7.2 upgraded to a new version of the jvm. The Confluence 7.1 notes indicate that java 11 support was introduced, but they were shipping with AdoptOpenJDK 8. There is a comment in the 7.2 release notes that they reverted back to bundling the Java 8 JRE.

    Which version ofthe mysql driver are you using? Have you tried upgrading to the latest driver?

  2. Scott Selberg

    Hi, I found an issue with the database driver loading and Java 11. I’ve released version 1.4.6 with the fix. Give that a try and see if that fixes the issue.

  3. Derek Greene

    i installed the update today, and now we have a new issue…and actually we’re using confluence 7.3.2 - i mis typed.

    not sure thats related to the driver which is “mssql-jdbc-6.1.0.jre8.jar”.

  4. Scott Selberg

    Which version of Java is your confluence running on? If you open the Database Profile configuration page or the Database app configuration page, the current version of java will be printed in the gray box where I identify which drivers were detected on the file system.

  5. Scott Selberg

    from the name, “mssql-jsdb-6.1.0.jre8.jar”, that is targeting java 8 and the last upgrade to Confluence brought you to java 11. Can you check if there is a driver for java11?

  6. Derek Greene

    Downloaded mssql-jdbc-8.2.0.jre11.jar and didn’t solve the problem. Still shows green as the driver is installed, but same message on macros

  7. Log in to comment