Can query SQL tables, but cannot query SQL views, GatewayException: Unknown SQL type: -156

Ignition
1

GatewayException: Unknown SQL type: -156
caused by SQLException: Unknown SQL type: -156

Ignition v8.0.16 (b2020082513)
Java: Azul Systems, Inc. 11.0.7

Other information:SQL version: 13.0.4001.0

2

What version of the JDBC driver is your gateway using?
We had to upgrade the driver when we went to SQL Server 2016

3

Finally it is because in the view I am using the sql variant type for a column, I did a cast in the view, now everything is perfect now. Thanks.

1 Like