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

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

This was observed with the JayBird database.

Answer 1

[MathWorks Support Team]

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