JDBC drivers 3.70.JC7 and 4.10.JC1 not FULLY compatible with IDS 10.00?

[Gabriel Belingueres]

Hi:

I'm using a tool (dbVisualizer 9.0.8) which relies on a JDBC driver to access the database and get metadata. I'm connecting to an Informix Dynamic Server version 10.00.FC4XD.

There is this screen that shows the table column names, types, etc. that works ok with Informix drivers previous to driver version 3.70.JC7, but with v3.70.JC7 (and more recently 4.10.JC1) it fails since it doesn't find the get_data_type() function. I don't know exaclty which metadata retrieving JDBC method is calling though.

I can't find the get_data_type function in IDS 10.

I do found it in IDS 11.50 like this:

function get_data_type(coltype smallint, xtype integer, is_odbc smallint)
returning smallint
external name '(get_data_type)'
LANGUAGE C;

When connecting to a IDS 11.50 it works with ALL driver versions.

The driver documentation (both 3.70.JC7 and 4.10.JC1) says it supports IDS 10.00 but it seems to me that this part of the JDBC spec implementation has a bug?

Does anyone else has seen this behavior?

TIA,
Gabriel