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

Stored procedure with parameters defined as FLOAT will be changed to a LongInteger in the Spotfire object.

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

Problem:

Stored procedure with parameters defined as FLOAT will be changed to a LongInteger in the Spotfire object.


Solution:

You have a stored procedure with input parameters defined as FLOAT. When you create the procedure object in the Information Designer, you see that the input parameters are set to a LongInteger and will only take an integer value.

Only a Longinteger will be added to the procedure object in the Information Designer. The datasource for the procedure is using the Direct Driver. In the URL you see: Jdbc:tibcosoftwareinc...

The drivers supplied with the software have known limitation. This driver is only meant for simple testing purposes and is not meant for production use.

You will need to use the vendor's database data driver. This will accept the FLOAT as a REAL data type.