MATLAB: Does a SQL query returns {No Data} with a JDBC complaint database when using MATLAB R2015b

datadatabaseDatabase Toolboxjdbcnor2015b

Why does a SQL query returns {No Data} with a JDBC complaint database when using MATLAB R2015b?

This was observed with the JayBird database.

Best Answer

This is because of a known bug in MATLAB R2015b which is fixed in MATLAB R2016a.

To workaround this issue, please execute the following command before performing an 'exec' operation:

>>set(conn, ‘AutoCommit’, ‘off’)

>>curs = exec(conn, ‘…’)

>>curs = fetch(curs);

>>curs.Data

Related Solutions

MATLAB: Do I get a “JDBC Driver Error: CLIENT_PLUGIN_AUTH is required” error when connecting to a remote MySQL database

This appears to be a server-side authentication issue with the MySQL database.

1) Please ensure the driver version for the JDBC connection is compatible with the version of the MySQL database you are trying to connect to.

2) Please specify the parameter "useSSL=false" in the URL of JDBC connection:

>> driverpath = 'C:\xxxxxx\mysql-connector-java-X.X.XX.jar';
>> opts = configureJDBCDataSource('Vendor','Other');
>> opts = setConnectionOptions(opts,'DataSourceName','SQLServerDataSource',...
'URL','jdbc:mysql://<hostname or ip address>/<database-name>?useSSL=false&',...
'Driver','com.mysql.cj.jdbc.Driver',...
'JDBCDriverLocation',driverpath);
username = 'exampleUsername';
password = 'examplePassword';
[status, error] = testConnection(opts,username,password)

3) If these steps fail, please contact your database administrator to troubleshoot authentication and connectivity issues.

MATLAB: Does MATLAB crash when I run EXEC on a closed database connection using the Database Toolbox 3.0.2 (R14SP2)

There is a bug in the Database Toolbox 3.0.2 (R14SP2) in the way that EXEC handles a closed connection. To work around this issue, change line 27 of EXEC.M from:

if ~(isempty(class(connect.Handle)))

to:

if isconnection(connect)

You can do this by typing:

edit exec

Best Answer

Related Solutions

MATLAB: Do I get a “JDBC Driver Error: CLIENT_PLUGIN_AUTH is required” error when connecting to a remote MySQL database

MATLAB: Does MATLAB crash when I run EXEC on a closed database connection using the Database Toolbox 3.0.2 (R14SP2)

Related Question