Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Postgres JDBC driver is converting the numeric (Real) column data type to Integer for stored procedure.

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Postgres JDBC driver is converting the numeric (Real) column data type to Integer for stored procedure.


Solution:

If you are facing above mentioned behavior i.e. while pulling the data from the Postgres data source through Stored Procedure inside Spotfire Analyst, the columns having numeric data type are converted to Integer data type, then follow the resolution section. To stop this numeric data type conversion, follow the below steps:

1) For Spotfire 10.0 and older version, open Spotfire Analyst >> Tools Menu >> Information Designer.
    For Spotfire 10.0 and above, open Spotfire Analyst >> Data Menu >> Information Designer.

2) Now, open the stored procedure and inside result columns section, uncheck the option-> "Include all result columns"

3) Add the output/resultant columns one by one as per your requirement. https://community.tibco.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details

Related articles