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

Document created by Dave Murphy Employee on Jul 19, 2017Last modified by Dave Murphy Employee on Jul 19, 2017
Version 2Show 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

http://msdn.microsoft.com/en-us/library/ms378878(v=sql.110).aspx

Attachments

    Outcomes