I’ve been using Oracle SQL Developer I think since the very first initial betas.  I could never stand the TOAD interface and the few bugs I encountered with SQL Developer were never bothersome enough to stop using the tool.

Over the years SQL Developer has matured very nicely and now is very stable and feature rich.

When someone from Packt contacted me and let me know there was a book on the way I was very excited.  Oracle SQL Developer 2.1 by Sue Harper covers the latest release for SQL Developer – 2.1.  This release brought a lot of stability to the project and also introduced the new Data Modeler from Oracle.

I’ve been skimming through the book for the last week or so.  I honestly thought since I’ve been using SQL Developer for so long there would be very little new to me in the book but I’ve been pleasantly surprised and have picked up a lot of small tips that have helped me work smarter and more efficiently with SQL Developer.

The book covers quite a bit:

• Install, configure, customize, and manage your SQL Developer environment
• Includes the latest features to enhance productivity and simplify database development
• Covers reporting, testing, and debugging concepts
• Meet the new powerful Data Modeling tool – Oracle SQL Developer Data Modeler
• Detailed code examples and screenshots for easy learning

A few useful tips I’ve picked up since reading the book have been:

• The ability to highlight and filter data in the grids.  This is really useful when you are trying to dig through some complicated data looking for very particular information.
• Using bind variables in the worksheet.
• The code formatter – cleaning up my mess!

What else does the book cover?   There are chapters devoted to PL/SQL, dubugging and tuning, extending SQL Developer, source control integration (using Subversion) and a large chapter on the Data Modeler which I’m just waiting for a new project to start to begin exploring that particular tool.

If you are just getting started using SQL Developer I’d highly recommend the book.  It will get you up to speed quickly and seems useful as a quick reference.   If you are an experienced SQL Developer user I still think the added section on the new Data Modeler will be quite useful.

Working on some Ant scripts and Oracle today and out of the blue I get this error:

ORA-12638 credential retrieval failed

Everything was working yesterday!  I restarted Oracle and my workstation – no luck!  Argh.

A quick Google however turned up a simple solution – simply modify your sqlnet.ora file. On my machine running Oracle XE this is located:

C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN

And change one line:

Original Entry – SQLNET.AUTHENTICATION_SERVICES= (NTS)
Modified Entry – SQLNET.AUTHENTICATION_SERVICES= (NONE)

After I changed this I tried it and it worked – no reboot, restart required!  Reading on the Oracle forums – apparently the “NTS” option tries to use your Windows credentials to authenticate with Oracle.  So unless your Oracle logins match your Windows login – this may fail.

I’ve been a big fan of Oracle’s SQL Developer for quite awhile.  When I first started using Oracle everyone at work was using TOAD but I just couldn’t get used to TOAD’s sometimes overwhelming interface.  Digging around I went looking for a free tool and stumbled across an early version of SQL Developer.  While a bit buggy it did what I needed and has since matured into a very robust tool.  The only thing it was lacking was a good diagram tool when I needed to generate an ERD.

That is now about to change as Oracle has released an Early Adopter Release of SQL Developer Data Modeling.  This is currently a standalone product but Oracle has said at some point it will be integrated with SQL Developer.

Read the rest of this entry »

I am working on a new application at work and having some database issues and wanted to diagram some things out – I like pictures! :)

I dug around on the web looking for an Oracle friendly ERD (entity-relationship diagram) tool. There were lots out there but most were in the $300+ range. The few free ones I found were limited in some way, no printing, no saving, etc. Finally I stumbled upon a Google Groups post that mentioned that JDeveloper would do this. I had heard of JDeveloper but for some reason always assumed it was a commercial product. A quick check on the Oracle site however proved me wrong. JDeveloper is a free download! (free since 2005!)

Oracle JDeveloper is a free integrated development environment with end-to-end support for modeling, developing, debugging, optimizing, and deploying Java applications and Web services.

It’s a huge download, 500MB for the whole package. Installation was just a matter of unzipping the download. After watching a brief tutorial I was quickly able to connect to, and reverse engineer my database into a beautiful diagram. It will also generate DDL scripts from a diagram. I haven’t dug into it much and probably won’t use it for more than generating my ERDs but it also appears it will do UML as well which I have been meaning to check out.

At work I’ve been using Oracle’s SQL Developer lately to do my database work. It has been working great until this week when we started working on migrating to Oracle 10g. I installed the new 10g client on my workstation and while I could still use SQL Developer to connect to my old 9x schemas – trying to connect to 10g would result in a horrible crash.

After I dug around I found what seems to be the solution on the SQL Developer Forum.

Turns out there may be an issue with the JDBC drivers shipping with the latest SQL Developer. The ‘fix’ is to copy two .jar files from your 10g client install to the SQL Developer directories.

On my machine I copied these two files from my Oracle installation:

C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14.jar
C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14dms.jar

To SQL Developer:

C:\Program Files\sqldeveloper\jdbc\lib\ojdbc14.jar
C:\Program Files\sqldeveloper\jdbc\lib\ojdbc14dms.jar

Overwriting the existing files.

While this isn’t an official fix – it worked for me as well as others on the forum.

FWIW – SQL Developer can also connect to MSSQL, MySQL and Access and it’s free!