Idera strives to ensure our products provide quality solutions for your SQL Server needs. The following known issues are described in this section. If you need further assistance with any issue, please contact Support (www.idera.com/support).
The SQL Server sqlvariant data type is not currently supported by the Microsoft JDBC driver. If a query is used to retrieve data from a table that contains a column of the sqlvariant data type, an exception will occur. There are two workarounds to fix this issue:
- Use CAST to type cast the sqlvariant columns to the data type you want.
or
- Use the jTDS driver to connect.