Unable to add comments due to unsupported driver

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When using a custom database driver for Microsoft SQL Server that is not the default jTDS Driver, adding comments may not work and the atlassian-confluence.log will contain the following error:

2012-10-05 09:41:14,923 WARN [http-443-14] [spi.container.servlet.WebComponent] filterFormParameters A servlet POST request, to the URI https://confluence_url/rest/tinymce/1/content/13304109/comment?actions=true, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.
 -- url: /rest/tinymce/1/content/13304109/comment | userName: xxxxx | referer: https://confluence_url/display/webservices/Web+Services+Members
2012-10-05 09:41:15,486 ERROR [http-443-14] [atlassian.event.internal.EventPublisherImpl] invokeListeners There was an exception thrown trying to dispatch event 'com.atlassian.confluence.event.events.content.comment.CommentCreateEvent[source=com.atlassian.confluence.pages.DefaultCommentManager@22492eb4]' from the invoker 'com.atlassian.event.internal.SingleParameterMethodListenerInvoker@1d56ac0'.
 -- url: /rest/tinymce/1/content/13304109/comment | userName: xxxxx | referer: https://confluence_url/display/webservices/Web+Services+Members
java.lang.RuntimeException: java.lang.reflect.UndeclaredThrowableException
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.

Diagnosis

Check if you are using the correct driver for Database, which is located under <confluence_install>/WEB-INF/lib and must be jTDS.

The correct SQL Server JDBC driver is bundled with Confluence, as documented on this page: Database JDBC Drivers.

Cause

Confluence does not fully works with the Microsoft JDBC driver.

Resolution

  1. Shutdown Confluence
  2. Remove Microsoft JDBC driver from your  <confluence_install>/WEB-INF/lib
  3. Follow the following instructions on how to add a JTDS driver:
    1. Install Confluence and the SQL Server database driver

You can see the supported database drivers here: Database JDBC Drivers

Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.