Version: 14.0.14-4
Build #: 38034
Build Date: 2014-May-21 12:49:42 PM
err gets displayed in informix for INT8 and SERIAL8
To reproduce:
###
### Repro INT8 and SERIAL8 ADS V14 display-problem
###
DATABASE test;
DROP TABLE tst_tab;
CREATE TABLE tst_tab (c_serial serial, c_serial8 serial8, c_int int, c_int8 int8, c_char char);
INSERT INTO tst_tab VALUES (0,0,1,1,'1');
INSERT INTO tst_tab VALUES (0,0,2,2,'2');
INSERT INTO tst_tab VALUES (0,0,3,3,'3');
SELECT * FROM tst_tab;
c_serial c_serial8 c_int c_int8 c_char
----------- ------------ -------- --------- ---------
1 (err) 1 65536 1
2 (err) 2 65536 2
3 (err) 3 65536 3
Error Log has below contents
5/26 15:04:11.707 q????.oO Error: .getObject(): Type not supported Column Name: c_serial8 DataTypeName: serial8 DataType: -5
5/26 15:04:11.707 q????.oO Error: .getString(): Type not supported Column Name: c_serial8 DataTypeName: serial8 DataType: -5
5/26 15:05:42.763 q????.oO Error: .getObject(): Type not supported Column Name: c_serial8 DataTypeName: serial8 DataType: -5
5/26 15:05:42.763 q????.oO Error: .getString(): Type not supported Column Name: c_serial8 DataTypeName: serial8 DataType: -5
5/26 15:05:42.763 q????.oO Error: .getObject(): Type not supported Column Name: c_serial8 DataTypeName: serial8 DataType: -5
5/26 15:05:42.779 q????.oO Error: .getString(): Type not supported Column Name: c_serial8 DataTypeName: serial8 DataType: -5
This error is been thrown by the jdbc driver. Will look into seen if there is a new jdbc driver and if there is the customer can try using that driver to see if this corrects his issue.