Main Content

Database Explorer App Error Messages

This table describes how to address common errors you can encounter while working with theDatabase Explorerapp. For Database Toolbox™ connection errors, seeDatabase Connection Error Messages.

Error Category Error Message Probable Causes Resolution
Database connection No data sources found. Configure a data source before creating a new query.

You clickedNew Querybefore configuring any data sources.

Configure at least one ODBC or JDBC data source. For details, seeConfigure Driver and Data Source.
Configure JDBC data source Unable to find the JDBC driver file on the MATLAB Java class path.

disp JDBC数据源配置对话框lays this message at the bottom of the dialog box. This message is displayed when the JDBC driver for the database, or the driver specified for theDriveroption when theVendoroption is set toOTHER, is not found on the MATLAB®Java®class path.

Specify the full path to the JDBC driver file in theDriver Locationbox of the JDBC Data Source Configuration dialog box. For details, see thedatabaseConnectionOptionsfunction.
SQL statements Database Explorer supports one SELECT SQL statement only.

You entered an incompatible SQL query.

The Database Explorer app accepts a singleSELECTstatement only. Other SQL statements are not supported.

Create one valid SQLSELECTstatement in theSQL Querypane.
Data preview Received the following message from the database:

If an error occurs on the database server when it executes the SQL query, an error message appears in theData Previewpane.

This text precedes the exact error message from the database server.

Refer to the error message to determine the issue.

Consult your database administrator for further details.
Data preview Error occurred while executing the query on the database. The Database Explorer app returned a MATLAB error while trying to execute the SQL query.

Click the button to view the stack trace. For questions, contact technical support.
Data preview No data was returned for this SQL Query.

The SQL query executed successfully but did not return any data.

The Database Explorer app displays this error message in theData Previewpane when previewing data or in a dialog box when importing data.

Use the Database Explorer app to modify the SQL query.

Ensure that the selected table contains data by clicking it in theData Browserpane.
Data import variablenot a valid MATLAB variable name.

You entered an invalid MATLAB variable name.

Enter a valid MATLAB variable name, such asdata.

See Also

Apps

Related Topics