I started on some Database development and decided to give the new Version of Oracle SQL Developer 4.0 a try. The first challenge I came across and had to spend more than 5 minutes to complete was adding a working MSQL connector. I did a bit of google action and came across some dead links and silly Oracle Cloud registrations. The only request I had was the supporting mysql .jar connector. So if by chance you have the same need, read on how to get it done…
This is for Oracle SQL Developer 4.0
1. Download the MSQL connector package via the sourceforge Project: JTDS – SQL Server and Sybase JDBC driver by ickzon
2. extract the package somewhere on you harddrive
3. I choose to create a new folder called “connectors” in /Applications/SQLDeveloper.app/Content/ and copied the extracted content here.
4. Open Oracle SQL Developer 4.0 – from the Menu navigate to Oracle SQL Developer –> Preferences
5. Open the section Database and choose Third Party JDBC Driver
- Press Add Entry
- Navigate to the JDBC connector you extracted and highlight “jtds-1.3.1.jar” then Press Select
- Press OK and you done
Now when you create a new Database connection you see the SQLServer and Sybase Tab.