Friday, March 20, 2009

SQL Developer Connecting to MySQL

We introduced Oracle SQL Developer to our developers about a year ago. They seem to like it for querying Oracle, but the MySQL connectivity was quirky in previous releases.

Now that Oracle SQL Developer 1.5.4 has been released, I figured I'd give it a try again. I downloaded the software and it started right away with no problem (although I wasn't paying attention and I forgot to migrate over my settings).

Once the software starts, go to Tools > Preferences > Database > Third Party JDBC Drivers and choose the appropriate JAR file.

Then I added a connection with the correct parameters and Voila! I was querying MySQL data from an Oracle tool!

Monday, March 02, 2009

My Oracle Support

Did everybody get the notice that the HTML version of MetaLink is going away?

If you've got a hot duo2 box and your IT Department allows you to install Flash, you've probably already been experimenting with the new version. I tried using it when it first came out but it was so slow on my 2.2Ghz Laptop with only 512Mb of RAM that I had to go back to "MetaLink Classic".

Well, now I have no choice now that my days are numbered. I've got to figure out how to tell my IT group that all my people need new computers because Oracle upgraded their website. Maybe the government can bail us out?