Oracle SQL Developer 串連 MySQL

標籤：解壓   strong   3.1.1   mysql   oracle   第三方   reference   images   tor   

1. 在ORACLE官網下載Oracle SQL Developer第三方資料庫驅動

下載頁面:http://www.oracle.com/technetwork/developer-tools/sql-developer/thirdparty-095608.html

Download the MySQL Drivers from the MySQL Site. There are two drivers here:

 

1) MySQL Connector/j 5.0

Unzip the zip file and take the mysql-connector-java-5.0.4-bin.jar as your driver.jar

下載連結 http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.4.zip/from/http:/mysql.he.net/ 

2) MySQL Connector/J 3.1

Unzip the zip file and take the mysql-connector-java-3.1.14-bin.jar as your driver.jar

下載連結:http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.14.zip/from/http:/mysql.he.net/

 

2. 解壓出檔案mysql-connector-java-5.0.4-bin.jar

 

3. 開啟Oracle SQL Developer ,選擇Tools > Preferences > Database > Third Party JDBC Drivers, 增加mysql-connector-java-5.0.4-bin.jar, 點OK.

 

 4. 在Oracle SQL Developer點,增加一個串連,即可看到MYSQL選項, 填入必要資訊即可使用.

 

Oracle SQL Developer 串連 MySQL