Sunday, July 10, 2011

Setup SQL Developer to Connect to a MySQL database!!!

1. Download sql developer from oracle site
2. Copy sql developer to drive C:\
3. Copy msvcr71.dll to %WinDir%\System32 [reference: http://gisbiz.com/2011/05/fixing-the-sql-developer-msvcr71-dll-error/]
msvcr71.dll is located in: [sqldeveloper\jdk\jre\bin\msvcr71.dll]
4. Download mysql-connector-java-5.0.8-bin.jar zip file from this site: Download MySQL connector Java
5. Extract mysql-connector-java-5.0.8-bin.jar in sql developer lib folder: C:\Users\gnesguerra\Downloads\sqldeveloper-3.0.04.34\sqldeveloper\lib
6. Setup sql developer to connect to mysql database using the tutorial from this site: Starting from Setting it Up Paragraph: Configuring SQL Developer for MySQL
   6.1 Click Choose Database button below Port label.
   6.2 Beside the Choose Database button, select the database you want to connect to
from the dropdown control.
   6.3 Zero Date Handling should be set to null
   6.4 Click Connect
7. (Increase Operation Timeout)
   7.1 Tools
   7.2 preferences
   7.3 versioning
      7.3.1 general
      7.3.2 set operation timeout to 1 hour or greater
8. Finished.
You should be able to connect to root username or your mysql db instance
NOTE: I found a small bug running MySQL queries in SQL Developer
When you finished executing a query and you want to execute another query,
the editor returns error message (Query execution was interrupted)
The solution is to delete the persisted settings then switch to Query Builder everytime you create a new query. Then wait for a couple of seconds..Sucks!!!
Regards

1 comments:

  1. Great article! That is the type of information that are supposed to be shared across the internet.
    Shame on the search engines for not positioning this submit upper!
    Come on over and consult with my web site . Thanks =)
    Also see my site :: Wood Stoves For Sale

    ReplyDelete