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

local oracle database connectivity

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...

    hchananaAnswer
    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

     

    View in thread

    9 replies

    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

     

    Translate
    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.

    Translate
    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

     

    Translate
    Terms & ConditionsAccessibility statement