Java exception using runsqlscript function

1 次查看（过去 30 天）
Allan Brett
Allan Brett 2019-10-17
回答： Allan Brett 2019-10-21
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
Answer my own question. Although it will not tell you, runsqlscript has been replaced by executeSQLscript.
results = executeSQLScript(conn,scriptfile)
https://www.mathworks.com/help/database/ug/database.odbc.connection.executesqlscript.html

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by