MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Scaricare il pdf (Pagina 165)

MySQL JDBC for Linux

2-139

MySQL JDBC for Linux

This tutorial shows how to set up a data source and connect to your MySQL database.

This tutorial uses the MySQL Connector/J 5.1.17 driver to connect to the MySQL Version

5.5.16 database.

In this section...

“Step 1. Verify the driver installation.” on page 2-139

“Step 2. Add the JDBC driver to the MATLAB static Java class path.” on page 2-139

“Step 3. Set up the data source using Database Explorer.” on page 2-140

“Step 4. Connect using Database Explorer or the command line.” on page 2-142

Step 1. Verify the driver installation.

If the JDBC driver for MySQL is not installed on your computer, find the link on the

Driver Installation page to install the driver. Follow the instructions to download and

install this driver on your computer.

Step 2. Add the JDBC driver to the MATLAB static Java class path.

1

Run the prefdir command in the Command Window. The output is a file path to a

folder on your computer.

2

Close MATLAB if it is running.

3

Navigate to the folder and create a file called javaclasspath.txt in the folder.

4

Open javaclasspath.txt. Add the full path to the database driver JAR file in

javaclasspath.txt. The full path includes the path to the folder where you

downloaded the JAR file from the database provider and the JAR file name. For

example, /home/user/DB_Drivers/mysql-connector-java-5.1.17-bin.jar.

Save and close javaclasspath.txt.

5

Restart MATLAB.

Alternatively, you can use javaaddpath to add your JDBC driver to the dynamic Java

class path. For details about static and dynamic class paths, see “Bringing Java Classes

into MATLAB Workspace”.

1 2 ... 160 161 162 163 164 165 166 167 168 169 170 ... 683 684

Commenti su questo manuale

Nessun commento

More products and manuals for CD players Sony

Models	Document Type
CDX-V58MP	User Manual Sony CDX-V58MP User's Manual, 4 pages
D-VJ85	User Manual Sony D-VJ85 User manual, 36 pages
MDX-C8900R	User Manual Sony MDX-C8900R Manual de usuario, 186 pages
HDX266/HDX267W	User Manual Sony HDX266/HDX267W User's Manual, 104 pages
CDX-M10	Operations Instructions Sony CDX-M10 Operating Instructions, 116 pages
MEX-BT2700	User Manual Sony MEX-BT2700 User's Manual, 56 pages
CDP-M555ES	User Manual Sony CDP-M555ES User's Manual, 48 pages
CDX-M30	User Manual Sony CDX-M30 User's Manual, 144 pages
D-E660	User Manual Sony D-E660 User's Manual, 32 pages
D-MJ95	User Manual Sony D-MJ95 User manual, 28 pages
D-F21	User Manual Sony D-F21 User manual, 24 pages
D-E561	User Manual Sony D-E561 User's Manual, 2 pages
CDX-434RF	User Manual Sony CDX-434RF User manual, 4 pages
CDP-CX335	User Manual Sony CDP-CX335 User manual, 68 pages
D-E551	User Manual Sony D-E555 User manual, 2 pages
CDX-C910	User Manual Sony CDX-C910 User manual, 62 pages
HAR-D1000	User Manual Sony HAR-D1000 User's Manual, 36 pages
CFD-360	User Manual Sony CFD-360 User manual, 60 pages
D-SJ01	User Manual Sony D-SJ01 User manual, 24 pages
CFD-577	User Manual Sony CFD-577 User manual, 36 pages