Unable to add comments due to unsupported driver
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
- Shutdown Confluence
- Remove Microsoft JDBC driver from your
<confluence_install>
/WEB-INF/lib
- Follow the following instructions on how to add a JTDS driver:
You can see the supported database drivers here: Database JDBC Drivers