Direct to Database Testing : The "variant" data type is not supported

Document created by B-F-F08DRX Employee on Jul 19, 2017Last modified by B-F-F08DRX Employee on Jan 2, 2018
Version 3Show Document
  • View in full screen mode

The SQL Server sqlvariant data type is not currently supported by the 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.


JDBC driver of SQL Server will return an error:   The "variant" data type is not supported.


CloudTest relies on the JDBC driver of SQL Server for Direct to Database Testing. The user has to avoid the “variant” data type when using the Direct to Database Testing feature on CLoudTest.


More information can be found on  the following Microsoft page