com.microsoft.sqlserver .jdbc.SQLServerException: Incorrect syntax near the keyword 'null'.

com.microsoft.sqlserver .jdbc.SQLServerException: Incorrect syntax near the keyword 'null'.

book

Article ID: KB0093992

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
==========
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'null'.

Environment:
==========
All OS

Symptoms:
=========
Error [ClusterCacheRecoveryManager.Thread.1] - [root] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'null'.

Cause:
======
Configuring Oracle as backingstore in the cdd file instead of sqlserver. And also using the same backingstore database schema for two different applications.

Resolution:
==========
Use the correct database type and a different database schema for the different applications.

Issue/Introduction

com.microsoft.sqlserver .jdbc.SQLServerException: Incorrect syntax near the keyword 'null'.