MySQL jdbc server not working with Matlab 2019

Question

Renger van Nieuwkoop 2019-11-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494055-mysql-jdbc-server-not-working-with-matlab-2019

评论： Renger van Nieuwkoop 2019-12-19

Hi

I changed from Matlab 2018 to 2019 and suddenly I have problems with the MySQL JDBC-Driver. Although it is installed, Matlab can't find it, and I get the following error message:

JDBC Driver Error: No suitable driver found for jdbc:mysql:

Any idea why this might be the case?

Cheers

Renger

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Kojiro Saito 2019-12-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494055-mysql-jdbc-server-not-working-with-matlab-2019#answer_404112

You need to copy javaclasspath.txt from prefdir of R2018a (orR2018b) to prefdir of R2019a. In javaclasspath.txt, I suppose you had described the location of MySQL JDBC driver path.

Instead of using javaclasspath.txt, we can use configureJDBCDataSource from R2019a and it's easier to preset MySQL JDBC driver path. Here is a link of documenation.

https://www.mathworks.com/help/database/ug/mysql-jdbc-windows.html

6 个评论
显示 4更早的评论隐藏 4更早的评论

Renger van Nieuwkoop 2019-12-9

在 MATLAB Online 中打开

Sorry for not reacting earlier, but I was on holiday.

I added the path to my javaclasspath.txt and Matlab finds the driver, but now I get the following error running the command

fetch(conn,'SELECT * FROM scenarios;');
Error using database.jdbc.connection/fetch>errorhandling (line 573)
JDBC Driver Error: No database selected

If I display the connection information from "conn", I get

  connection with properties:
                  DataSource: 'nexus_5country_agg_euloads'
                    UserName: 'renger'
                      Driver: 'com.mysql.cj.jdbc.Driver'
                         URL: 'jdbc:mysql://localhost:33 ...'
                     Message: ''
                        Type: 'JDBC Connection Object'
  Database Properties:
                  AutoCommit: 'on'
                    ReadOnly: 'off'
                LoginTimeout: 0
      MaxDatabaseConnections: 0
  Catalog and Schema Information:
              DefaultCatalog: ''
                    Catalogs: {'cge', 'em', 'information_schema' ... and 18 more}
                     Schemas: {}

So there is a datadriver and a database..., but a problem with the fetch command.

Cheers

Renger

Renger van Nieuwkoop 2019-12-10

在 MATLAB Online 中打开

back again: I am running the same script on our university server using 2018a and have now the default catalogue also defined -> no problem:

conn = 
  connection with properties:
                  DataSource: 'nexus'
                    UserName: 'jared'
                      Driver: 'com.mysql.jdbc.Driver'
                         URL: 'jdbc:mysql://itet-psl-s02 ...'
                     Message: ''
                        Type: 'JDBC Connection Object'
  Database Properties:
                  AutoCommit: 'on'
                    ReadOnly: 'off'
                LoginTimeout: 0
      MaxDatabaseConnections: 0
  Catalog and Schema Information:
              DefaultCatalog: 'nexus'
                    Catalogs: {'cge', 'em', 'information_schema' ... and 22 more}
                     Schemas: {}
  Database and Driver Information:
         DatabaseProductName: 'MySQL'
      DatabaseProductVersion: '8.0.18'
                  DriverName: 'MySQL Connector/J'
               DriverVersion: 'mysql-connector-java-8.0. ...'

Using 2019a-Update 5 makes the connection but the default catalogue in the connection is empty. Is this a bug that has been solved in 2019b (I couldn't find it in the documentation)?

                  DataSource: 'nexus'
                    UserName: 'jared'
                      Driver: 'com.mysql.cj.jdbc.Driver'
                         URL: 'jdbc:mysql://itet-psl-s02 ...'
                     Message: ''
                        Type: 'JDBC Connection Object'
  Database Properties:
                  AutoCommit: 'on'
                    ReadOnly: 'off'
                LoginTimeout: 0
      MaxDatabaseConnections: 0
  Catalog and Schema Information:
              DefaultCatalog: ''
                    Catalogs: {'cge', 'em', 'information_schema' ... and 22 more}
                     Schemas: {}
  Database and Driver Information:
         DatabaseProductName: 'MySQL'
      DatabaseProductVersion: '8.0.18'
                  DriverName: 'MySQL Connector/J'
               DriverVersion: 'mysql-connector-java-8.0. ...'

Cheers

Renger

Kojiro Saito 2019-12-19

编辑：Kojiro Saito 2019-12-19

I've discussed with developers of Database Toolbox and this issue seems to be the same as reported in this URL. So, they think it is fixed in R2019a Update 2 and R2019b. I'm wondering why you have this issue in R2019a Update 5.

Renger van Nieuwkoop 2019-12-19

Hi Kojiro

The version R2019a Update 5 is running on the university server (Unix/Linux). Might that be an explanation?

Cheers

Renger

请先登录，再进行评论。

MySQL jdbc server not working with Matlab 2019

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

6 个评论
显示 4更早的评论隐藏 4更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

MySQL jdbc server not working with Matlab 2019

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

6 个评论 显示 4更早的评论隐藏 4更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

6 个评论
显示 4更早的评论隐藏 4更早的评论