MySQL with Oracle SQL Developer

Issue

Trying to connect to MySQL database using Oracle's SQL-Developer receiving the
following error message:

Status: Failure -com.mysql.jdbc.Driver
or
Status: Failure -Unable to find driver: com.mysql.jdbc.Driver

Solution

Download mysql JDBC connector from:
http://dev.mysql.com/downloads/connector/j/5.1.html

extract it on your PC and take the following file:
mysql-connector-java-5.1.5-bin.jar

... place it into sqldeveloper\sqldeveloper\extensions

then go to sqldeveloper -> Tools -> Preferences
Database -> Third Party JDBC Drivers
click "Add Entry" and select mysql-connector-java-5.1.5-bin.jar

restart sqldeveloper and you should be able to connect to mysql at this point.





-----Error---------communications link failure last packet sent successfully----



$ sudo vi /etc/mysql/hosts.allow

And add a line:
mysqld : 127.0.0.1 : allow

Connect Sql Server in SqlDeveloper Tool

1) download net.sourceforge.jtds.jdbc.Driver
http://sourceforge.net/projects/jtds/files/jtds/1.2.1/jtds-1.2.1-src.zip/download

2) In Oracle SQL Developer open Tools -> Preferences Database -> Third Party JDBC Drivers
Add Entry
Browse the unzipped driver and add the jtds-1.2.jar file

3) Error
I/O Error SSO failed Native SSPI library not loaded
check the java.library.path.system property


Copy the file 'jtds-1.2.2-dist\x86\SSO\ntlmauth.dll' from the unzipped JTDS --> \jdk\jre\bin.


4) Then restart SQL Developer.