Java exception using runsqlscript function

I am trying to run a mysql query using the Matlab "runsqlscript" function. I am calling it as follows:
results = runsqlscript(connL,'Query3.sql');
When I do so I receive the error:
Error using database.jdbc.connection/runsqlscript (line 168)
Java exception occurred:
java.lang.NullPointerException
at com.mysql.cj.jdbc.result.ResultSetImpl.getMetaData(ResultSetImpl.java:1074)
at com.mathworks.toolbox.database.fetchTheData.getTheMetaData(fetchTheData.java:177)
I am able to connect to the database through the Database Explorer, and running "isopen" on the connection "connL" returns 1. I am running Matlab2019b. This code returned no error in Matlab2016b.

 採用された回答

Allan Brett
Allan Brett 2019 年 10 月 21 日

0 投票

Answer my own question. Although it will not tell you, runsqlscript has been replaced by executeSQLscript.

その他の回答 (0 件)

カテゴリ

製品

リリース

R2019b

質問済み:

2019 年 10 月 17 日

回答済み:

2019 年 10 月 21 日

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by