Few Columns are blank Thingworx Oracle Connection

[thakkelk]

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

[rjanardan]

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?

[thakkelk]

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.

[Constantine]

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

[thakkelk · Accepted solution]

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