SQL exception thrown by the Active Objects library when using incompatible JDBC driver
症状
The error occurs generally doing a database operations, for example upon modifying the sprint date, JIRA triggers the operation to database which throw the following error in atlassian-jira.log
:
2012-10-09 11:07:26,950 http-443-23 ERROR [500ErrorPage.jsp] Exception caught in 500 page There was a SQL exception thrown by the Active Objects library:
Database:
- name:Microsoft SQL Server
- version:10.50.1600
- minor version:50
- major version:10
Driver:
- name:Microsoft JDBC Driver 4.0 for SQL Server
- version:4.0.2206.100
com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
診断
Check if you are using the correct driver for Database, which is located under <JIRA install>
/WEB-INF/lib
and must be jTDS.
原因
JIRA does not fully work with the Microsoft JDBC driver.
ソリューション
- Jira をシャットダウンします。
- Remove Microsoft JDBC driver from your
<JIRA install>
/WEB-INF/lib
- Follow the documentation instructions on how to add a JTDS driver
You can see the supported database drivers here: JIRA Supported Platforms
最終更新日 2018 年 11 月 1 日
Powered by Confluence and Scroll Viewport.