Database Connectivity in MATLAB 2010B picks up only one row from Oracle

3 次查看（过去 30 天）
Dude
Dude 2011-3-14
There are two problems I'm experiencing with the Database Toolbox:
I'm using the 11g client on Win 7 64 bit.
1.) When it does work, it only pulls one row. 2.) It only works once each time MATLAB is opened.
clear all
% create a database connection object
conn = database('mydb','user','pass')
pingconn = ping(conn)
% define a query
disp('Executing query...') tic; sqlQuery = 'SELECT ALL * FROM MY_TABLE';
%setdbprefs('DataReturnFormat','structure')
setdbprefs('DataReturnFormat','cellarray')
curs = exec(conn, sqlQuery)
fetch = (conn, sqlQuery)
toc;
disp('Completed.')
The strange thing is that is communicates with the database and the query times match up with Oracle PLSQL developer exactly, but after the first run with MATLAB open, MATLAB will not store any variables. Also, it only stroes one row when it does work. I've tried many modifications of the same code with no solutions. This is using ODBC connectivity and the connection was tested successfully.

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

采纳的回答

Martijn
Martijn 2011-3-14
Please consider using JDBC drivers instead of ODBC:
  1. They are more reliable on 64-bit Windows.
  2. They should perform better than the ODBC drivers.
  2 个评论
Dude
Dude 2011-3-15
This worked.
You must include the ocijdbc11.dll in the Java path for MATLAB.
Check the output of:
>> java.lang.System.getProperty('java.library.path')
and put the ocijdbc11.dll in there.

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2011-3-14
The line
fetch = (conn, sqlQuery)
has no syntactic meaning.
With regard to it only working once: do you perhaps need to do something to "close" the connection after use?
  4 个评论
显示 2更早的评论
Dude
Dude 2011-3-15
Yes Oleg that is correct. I typed that line in manually in the forum and didn't double check myself. That's why it didn't throw errors in the code.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by