Skip to main content
BSUN_RO1-Visitor
1-Visitor
Jan 8, 2021 8:01 AM UTC
Solved

Connection to mysql database

I am trying to connect to a database but it's not working. I downloaded the mysql connector (sqljdbc42.jar) and I put it in the tomcat/lib folder. The configuration is like this:

 

com.mysql.jdbc.Driver

jdbc:mysql:/ip:3306/thingworx?user=x&password=x

 

Do you know how to fix this? Thankyou!

anarwalAnswer
5-Regular Member
Jan 8, 2021 9:20 AM UTC

HI @BSUN_RO , Which documentation you are following ?. Have you tried https://www.ptc.com/en/support/article/CS243088 

View in thread

10 replies

anarwal5-Regular Member
5-Regular Member
Jan 8, 2021 8:51 AM UTC

Hi @BSUN_RO , First you need to check the connectivity between platform and the database server . Try ping to database ip from platform server . If that got success check for error logs in Application.logs in ThingworxStorage/logs folder

Translate
    BSUN_RO1-VisitorAuthor
    1-Visitor
    Jan 8, 2021 9:12 AM UTC

    Thankyou, I didnt knew about this logs. I found this error:

    ERROR starting: JDBC Driver Class Not Found: com.mysql.jdbc.Driver

    Do I need to rename the jar file to "com.mysql.jdbc.Driver" ?

    Translate
    anarwal5-Regular MemberAnswer
    5-Regular Member
    Jan 8, 2021 9:20 AM UTC

    HI @BSUN_RO , Which documentation you are following ?. Have you tried https://www.ptc.com/en/support/article/CS243088 

    Translate
      Terms & ConditionsAccessibility statement