connecting to a remote mysql database using jdbc connector (Mac)

9 次查看（过去 30 天）
Ronald Funderburk
Ronald Funderburk 2017-1-27
回答： Piyush Kumar 2024-10-27，7:07
I'm having difficulty configuring my environment to connect to a remote mySql database. I'm able to use the GUI, but not a script to connect / query my remote database.
Here's the scrip that I'm using to execute ... masked of course ... do I need to point to the jdbc connector? url? how to update the javaclasspath.txt file?
conn = database(‘db_Name’,’db_User_name’,’dbpassword’, 'Vendor','MySQL','Server’,’ip.address.xx.xxx.xx’, 'PortNumber', 3306);
myQuery='select * from RETURNS';
curs=exec(conn,myQuery);
mycurs=fetch(curs);
curs.Data;

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

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-10-27，7:07
Hi,
Database Toolbox connects to any relational ODBC-compliant or JDBC-compliant database using ANSI SQL. To connect to Database Toolbox, you need the database-specific ODBC or JDBC driver installed on your computer.
If the issue is related to the JDBC driver, download it from this link and add it to the MATLAB search path.
To add the downloaded jar file to the path, Go the location where you have downloaded the jar file, right click and select "Add to Path" => "Selected Folders and Subfolders".
OR
You can use the javaaddpath function.

类别

在 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