EPICS Home EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

Format page
for printing


Search Tech-talk
1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024 
<== Date ==> <== Thread ==>
Subject: Re: Question about fetching history data from MySQL by using phoebus
From: Han Lee via Tech-talk <tech-talk at aps.anl.gov>
To: "Kasemir, Kay" <kasemirk at ornl.gov>
Cc: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Date: Wed, 28 Jun 2023 08:30:35 -0700
Hi Kay,

Can we access MySQL directly?

Best,
Han

On Wed, Jun 28, 2023 at 6:12 AM Kasemir, Kay via Tech-talk <tech-talk at aps.anl.gov> wrote:

> org.csstudio.trends.databrowser3/urls=jdbc:mysql://192.168.1.230/archive

> org.csstudio.trends.databrowser3/archives=jdbc:mysql://192.168.1.230/archive

> …

> Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive

 

If there was a connection issue, you’d see an error like

 

        Cannot connect to jdbc:mysql://192.168.1.230/archive

 

“No suitable driver found”  suggests that your product simply doesn’t include the MySQL library.

In your_product/lib, there should be a file mysql-connector-java-8.0.30.jar

Is that not present?

Try a binary like the one from https://controlssoftware.sns.ornl.gov/css_phoebus/ which should include it.

 

-Kay

 

 

 

 



--
Jeong Han Lee, Dr.rer.nat.
Staff Scientist and Engineer
Cell: +1 510 384 3868
Replies:
Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
References:
Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
Navigate by Date:
Prev: Re: [EXTERNAL] Re: starting IOC with systemd Hu, Yong via Tech-talk
Next: Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024 
Navigate by Thread:
Prev: Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
Next: Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024 
ANJ, 28 Jun 2023 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·