Skip to main content
S
Surekha1-Visitor
1-Visitor
December 27, 2018
Solved

local oracle database connectivity

  • December 27, 2018
  • 1 reply
  • 11231 views

Hi everyone,

 

I'm unable to connect my local oracle db in thingworx platform.Please find the attachment of connection string for connection.Could please anyone help me out on this...

    Best answer by hchanana

    Hi @Surekha,

     

    Please validate the below points:

    • Make sure that Thing Template is of OracleDBServer type on your thing.
    • Oracle Database server is accessible from your thingworx instance. You can validate it by making ping to database server.

    If you still face issue please share your error screenshot also. Also let us know to which version of oracle database you are making connection.

     

    Thanks,

    Himanshu

     

    1 reply

    H
    hchanana16-Pearl
    16-Pearl
    December 27, 2018

    Hi @Surekha,

     

    It seems to be an issue in the configuration. Can you please provide the configuration as below and validate :

     

    JDBC Driver Class Name : oracle.jdbc.OracleDriver
    JDBC Connection String : jdbc:oracle:thin:@localhost:1521:orcl
    connectionValidationString : SELECT sysdate FROM dual

     

    You need to change the localhost and orcl as per IP and SID of your oracle database.

     

    Thanks,

    Himanshu

     

    S
    Surekha1-VisitorAuthor
    1-Visitor
    December 27, 2018

    Hi @hchanana,

        Thank you for your response.I made changes which you have mentioned,but still it doesn't working.

    H
    hchanana16-PearlAnswer
    16-Pearl
    December 27, 2018

    Hi @Surekha,

     

    Please validate the below points:

    • Make sure that Thing Template is of OracleDBServer type on your thing.
    • Oracle Database server is accessible from your thingworx instance. You can validate it by making ping to database server.

    If you still face issue please share your error screenshot also. Also let us know to which version of oracle database you are making connection.

     

    Thanks,

    Himanshu

     

    Terms & ConditionsAccessibility statement