JDBC SQL Date types

Questions and answers regarding general SQL and backend databases

JDBC SQL Date types

Postby Lachness » Thu May 16, 2013 3:11 pm

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
Lachlan Dunlop
LachNet, Inc
Mac OS 10.6, Windows 7 64bit, Gentoo Linux 64bit
Servoy 5.2x, 6.0x
Lachness
 
Posts: 51
Joined: Tue Feb 12, 2008 10:39 pm
Location: Saint Paul, MN USA

Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 2 guests