Answer my own question. Although it will not tell you, runsqlscript has been replaced by executeSQLscript.
Java exception using runsqlscript function
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Allan Brett
el 17 de Oct. de 2019
Respondida: Allan Brett
el 21 de Oct. de 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 comentarios
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!