The JDBC type -155 is unknown.

, ,
1

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?

2

Hi,

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

Best Regards,

3

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

4

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

5

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,

1 Like
6

All,

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

Thanks a lot for your guidance.

Regards,
Sastry