cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Few Columns are blank Thingworx Oracle Connection

SOLVED
Regular Member

Few Columns are blank Thingworx Oracle Connection

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Columns are blank Thingworx Oracle Connection

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

View solution in original post

4 REPLIES 4

Re: Columns are blank Thingworx Oracle Connection

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?

Re: Columns are blank Thingworx Oracle Connection

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.

 

Re: Columns are blank Thingworx Oracle Connection

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

Highlighted

Re: Columns are blank Thingworx Oracle Connection

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

View solution in original post

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________