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:
Do you know how to fix this? Thankyou!
Solved! Go to Solution.
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
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" ?
Hello @BSUN_RO ,
Maybe the extension has not been updated in a while and the driver is old.
There is a thread about packaging a new jdbc driver.
Hope it helps,