NCHAR AND NVARCHAR(MAX) on Java 1.6 = UNKNOWN TYPE

Classic Servoy
1

Hello,

I use Servoy 5.2.7 on Java 1.6 and the JDBC Driver 3.0 “Type 4”. The OS is Windows 7 32 bits and the database is SQL Server 2005.

In my database, I have fields NCHAR(X) and NVARCHAR(MAX).

In Servoy, these field types are not recognized : in Table, NCHAR type is displayed as “UNKNOWN TYPE #-15” and NVARCHAR(MAX) are “UNKNOWN TYPE #-16”.

When I switch from JDBC driver to jTDS driver I works fine but that don’t fit the prerequisites of the project. So jTDS is OK to develop temporarily but no for the deployment.

When I was on Java 1.5 and JDBC 3.0, there was no problem.

Do you know this issue and how to get rid off ?

Thanks !

2

William,

The types -15 and -16 are jdbc4 types which are added in java 1.6
Servoy is based on java 1.5, so natively it does not recognize these types.

We will add support for these new types in a future 5.2 release.

Rob

3

Hi Rob,

OK, so we will wait for the next version of Servoy with this feature.

Thank you.