JDBC SQL Date types

Hello,

I am connecting to a database developed by the Basis company. http://www.basis.com

I am having a problem with dates. When I view a date column in Servoy 6.1.3 (same problem in 5.x), the Type column shows “Unknown Type #9”.

I have reviewed the issue with the Basis DB engineer and he confirmed that he is returning a SQL_TYPE_DATE (91) not a SQL_DATE (9).

Is there something in Servoy that is causing it not to see the correct data type?

Thx for any help.

Lach