Answer my own question. Although it will not tell you, runsqlscript has been replaced by executeSQLscript.
Java exception using runsqlscript function
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Allan Brett
il 17 Ott 2019
Risposto: Allan Brett
il 21 Ott 2019
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.
0 Commenti
Risposta accettata
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!