JDBC Type DATE instead of TIMESTAMP

, ,
1

Hi there,

We are encountering a very strange issue after installing the latest fixes on our server. When using an adapter service of type SELECT the fields of type DATE in our database are returned without the time (just the date is retrieved). In the JDBCType field we have DATE instead of TIMESTAMP. Do you have any idea how can we manage to get the full date in the adapter service?

Our settings:

WmJDBCAdapter version → 6.5, fix 55 (JDBC_6.5_Fix55)
IS Version: 8.2.2.0
Fix level: IS_8.2_SP2_Core_Fix14

Thank you in advance!

2

what’s the reason you don’t use TIMESTAMP type for JDBC type?
the driver may trim off the time fields if the you use DATE as JDBC type