SQLServerException: Incorrect syntax near '$' - when used Microsoft SQL Server 2008 as DB backend for BRMS
Issue
We have received the following error when used MSSQL 2008 as db repository:
ERROR [org.apache.jackrabbit.core.util.db.ConnectionHelper] (main) Failed to execute SQL (stacktrace on DEBUG log level)
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '$'
Environment
- Red Hat JBoss Business Rules Management System (BRMS) - 5.3.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.