Fetch command no longer works with Matlab 2016b

Question

Jean Dupin 2016-11-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/314523-fetch-command-no-longer-works-with-matlab-2016b

评论： Jean Dupin 2016-12-13

Part of my code uses the fetch function to retrieve data in Matlab from an SQL query to an external database. This works fine with Matlab 2014b but doesn't execute anymore with Matlab 2016b. The command will cause Matlab to freeze.

The database connection is set up as following

dbConnection = database.ODBCConnection(dbInstance,dbUsername,dbPassword);

The query is then executed thanks to:

cursor = exec(dbConnection,sqlQuery);

Data is retrieved after with:

cursor = fetch(cursor);

The last command here causes Matlab to freeze whereas no issues happen with 2013a or 2014b.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Nirav Sharda 2016-12-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/314523-fetch-command-no-longer-works-with-matlab-2016b#answer_246935

The problem seems to be due to a bug in the native ODBC driver. As a workaround, you can use JDBC drivers. Addtionally, JDBC driver are recommended over ODBC drivers for 64 bit machines.