Database-outbound JDBC Insert Failed: nvarchar is incompatible with image

[Dustin Schreader]

I am receiving the follow message in the error database:

BADDATA caught exception trying to processMessageFromCloverleaf: Failed to write message to database: Operand type clash: nvarchar is incompatible with image

I reviewed the database schema and the column in question does have image as the Database Data Type and String as the Schema Data Type.  This does match the datatype of the column in the database.

How can I insert the value for this column into the database using the data type image instead of nvarchar to avoid causing the message to route to the error database?

 

Database configurations

Database: sql server

Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Driver: sqljdbc4.jar

 

Java Version: 1.7.0_25

Cloverleaf version: 6.1.2.0P

Topic