Skip to main content
T
thakkelk7-Bedrock
7-Bedrock
October 6, 2019
Solved

Few Columns are blank Thingworx Oracle Connection

  • October 6, 2019
  • 1 reply
  • 1746 views

Hi All,

 

I am trying to connect to an Oracle 9i database through thingworx.connection seems successful and when I run a service to get the records I am getting the data but few columns are blank. The datatype for those columns which are blank is varchar2

clipboard_image_0.png

clipboard_image_1.png

Best answer by thakkelk

Thanks for pointing in the right direction the issue was with the OJDBC jar on the apache/lib folder on the Thingworx server. I have replaced with OJDBC5.jar and I am able to see the columns

1 reply

R
rjanardan16-Pearl
16-Pearl
October 7, 2019

It seems only numeric data is being displayed. Could you please check if the Datashape linked to the result Infotable has the appropriate base types for the field definitions?

T
thakkelk7-BedrockAuthor
7-Bedrock
October 7, 2019

I have checked the Data Shape looks good and i have removed the DS and checked still the same issue. I have the same table in Oracle 11.2 which works fine but in oracle 9i has issue. Checked permissions for the user connecting to DB and it has same access.

 

C
Constantine18-Opal
18-Opal
October 8, 2019

Hello,

 

I don't know what exactly the issue is, but I would suggest checking those three things:

 

  1. Make sure you use correct Oracle JDBC driver in your DB extension;
  2. Check your CLASSPATH for any other Oracle drivers (search in JARs, etc.);
  3. Try to cast VARCHAR2 to something else in your query, e.g. using something like to_clob or cast(puid as char(20))

 

Regards,
Constantine

Terms & ConditionsCookie settingsAccessibility statement