Experimental Physics and
Industrial Control System

> I try to use binary SNS version of Phoebus and I checked the product/lib folder and found that the file mysql-connector-java-8.0.30.jar is present.

 

Right, should look something like this :

 

/jdk/…

/lib/…

/lib/product-sns-4.7.3-SNAPSHOT/lib/mysql-connector-java-8.0.30.jar

 

When you start it, it’s using the jdk/… that’s included in the download, so the menu Help, About shows java version 17, which should work with that mysql jar file.

 

When I then try to read data from say jdbc:mysql://localhost/archive, that either works, or it fails with a meaningful error message because there is a connection issue (network, no MySQL running, …) like this :

 

WARNING [org.csstudio.trends.databrowser3] No archived data for xxx

…

java.lang.Exception: Cannot connect to jdbc:mysql://localhost/archive as archive

…

Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

 

 

What you see is this :

1. the connection issue: Cannot connect to jdbc://mysql://192.168.1.230/archive as root  
2. Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive