SQLServerException: Incorrect syntax near '$' - when used Microsoft SQL Server 2008 as DB backend for BRMS

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In