BINARY_DOUBLE not read by spotfire

[prashchoudhary]

Hi,

I am getting below error while creating information link having BINARY_DOUBLE data type in Oracle.Is BINARY_DOUBLE not supported by spotfire.Is there an alternate solution.

Spotfire version : 14.1.0 2007-2023 Cloud software Group

InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: Unsupported JDBC data type in query result: BINARY_DOUBLE (HRESULT: 80131500).Thanks You.

 

[Niko Maresco]

hello prashchoudhary

hm, i've looked in our support database and Spotfire supports BINARY_DOUBLE since version 3.1. one other cause for this error could be the Oracle client: the instant client may not support BINARY_DOUBLE. you can try to use a different Oracle client and see if the error resolves.

another thing you can try is to change the data type in the query. example:

SELECT
  CAST(my_binary_double_column AS NUMBER)
...