MATLAB: Java exception using runsqlscript function

Question

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.

Answer 1

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