Adapter service is throwing below error when DateTimeOffset fields like StartDateTime and EndDateTime when they are not passed

Error message:

Could not run ‘test2’

com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Test.jdbc.adapter.localTransaction:test2.

[ADA.1.316] Cannot execute the SQL statement "INSERT INTO table

(0) The JDBC type -155 is unknown."

The JDBC type -155 is unknown.

Can some help us to fix this issue?

Hi,

Are you converting your date objects into java.sql.timestamp before inserting (or using another type conversion)?

Best Regards,

Hi Sastry,

please provide the version of your adapter as well as the fixes applied to it.

Which one is your database vendor?

Regards,
Holger

Yes we are converting into java.sql.Timestamp before inserting but here the issue is if null is passed to that dateTimeOffset field the error(JDBC type -155 is unknown) is thrown if value(java.sql.Timestamp) is passed the error is not throwing.

Regarding WmJDBCAdapter vesion we are using 9.0.0.0 with Fix “JDBC_9.0_Fix10”

Database Verndor : SQL server 2014.

Regards,
Sastry

Hi,

The latest is JDBC_9.0_Fix12.

You should try to apply it.

Also check that you have a recent JDBC driver from Microsoft.

Best Regards,

All,

Now the issue got fixed after upgrading the 3.0 sql jar file.

Thanks a lot for your guidance.

Regards,
Sastry