SQL Developer to connect to MySQL Database

Tip: Use SQL Developer to connect to MySQL database

Most of the people use Oracle SQL Developer to connect to Oracle database only.

We can use SQL Developer to connect to MySQL and SQL Server databases also.

To connect to different types of databases, we have to use appropriate drivers in SQL Developer.

Here I am showing configuring SQL Developer to connect to MySQL Database

Step 1: Download the driver file from the below URL

http://cdn.mysql.com/Downloads/Connector-J/mysql-connector-java-5.0.8.zip

Step 2: Extract .zip file and get "mysql-connector-java-5.0.8-bin.jar" file.

Step 3: Now open SQL Developer navigate to the below path to add the above jar file.

Tools -> Preferences -> Database(expand it) -> Third Party JDBC Drivers

Step 4: Click "Add entry" button and browse previously extracted .jar file.

Step 5: We are almost done. Now try to create new connection in SQL Developer.

Step 6: Now you will see new tab for MySQL Database in connection creation window.

Similarly we can find other jdbc drivers to connect to other database types. 

CHEERS :)

Creating folders in Oracle SQL Developer

Issue: 

People who works on Oracle development, they create many connections for DEV, TEST, PROD instances using several user ID's. But sometimes, maintaining these many connections little annoying.

Solution: SQL Developer is having one decent feature to maintain many connections. i.e FOLDER.

Here is the way to create folders and arranging the multiple connections.

Step 1: Create folder in the SQL Devloper.

a) Right click on any connection which are created already, then "Add Folder" and select "New Folder".

 b) Give some meaningful name to the folder. I am giving the folder name as DEV to put all Dev related connections.

 c) Once after creating the folder, drag and drop all your Dev related connection to the folder. 

d) Repeat the same steps for other instances.

e) Nice feature right...!!!! Observe the above image, how all connections are arranged to different folders.

CHEERS :)

MSVCR71.dll is missing from your computer

1) Many people faced the below error while starting SQL Developer for the first time.

Error:
--------

The program can't start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this problem.

Solution:

------------

1) Copy msvcr71.dll file from E:\sqldeveloper-3.2.20.09.87\jdk\jre\bin, and paste it in the main directory.

 i.e E:\sqldeveloper-3.2.20.09.87

2) Now try starting SQLDeveloper.exe from the main directory.

3) You don't see the missing .dll file error again.

CHEERS