News, views, tips and tricks on Oracle and other fun stuff

When Versioning Support Interferes With Saving Your Relational Model

Oracle SQL Developer Data Modeler icon To reverse engineer an existing database into a relational model, I used SQL Developer Data Modeler, a free data modeling and database design tool from Oracle.

I had a problem with the tool. I could not save the model. It appeared to be saved but when I reopened the .dmd file, the relational model was nowhere to be found.

I tried all kinds of combinations on my Windows 7 64-bit laptop, like using JDK 6 vs. JDK 7, 32 bit vs. 64 bit versions, etc. No luck.

Then I stumbled upon this Oracle Forum thread while searching for a solution online. The poster suggested that enabling support for version control in the tool solved the issue.

I have TortoiseSVN installed on my laptop and use it to interface with a subversion repository.

I had versioning support disabled in SQLdev Data Modeler.

Following the hints in the forum post, I enabled it (Tools > Preferences > Extensions > toggle Versioning Support). Restarted SQLdev Data Modeler, and voila! I can now save my relational models!

There was no way I could have guessed that versioning support was interfering with saving relational models. I am guessing this is a bug.

Comments Off on When Versioning Support Interferes With Saving Your Relational Model | Filed in Oracle, Tips | Tags: ,

SQL Developer/APEX Listener Bug and The Power of Social Networking in Action

Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise.

The surprise is that you’ll get a “500 – Internal Server Error” whenever you upload a file via any of your APEX apps or import files via the APEX Application Builder.

Kris Rice responded to my tweet almost immediately.

The problem was a bug in the way SQL Developer uploads APEX Listener settings to the server.

This Oracle forum post describes how to reproduce the bug and the workaround to fix it.

Kris quickly put a fix together and checked it in for the next patch.



If you are still hesitant to join Twitter, I hope that this post has given you an incentive to join this growing social network. Many Oracle employees, like Kris, are active on Twitter and listening to people like you and me who use their products on a daily basis.

To make it easier for you to follow Oracle people on Twitter, I have created this Oracle list. The list occupies a permanent column on my Tweetdeck stack.

1 Comment | Filed in Oracle | Tags: ,

Oracle SQL Developer 2.1 EA1 Released

Oracle SQL Developer 2.1 Early Access 1 is available for download. Please review the Release Notes before you start. For all other supporting documents, please visit SQL Developer on OTN.

Here’s the new feature list :

Here’s the OBE for the new Unit Testing:

Download it from

Comments Off on Oracle SQL Developer 2.1 EA1 Released | Filed in Oracle | Tags:

Control When Oracle SQL Developer Completes Your Code

In the SQL Developer group on, both Chris and Chen complained about the new SQL Developer’s automatic code completion and how it could freeze the entire editor while waiting for the popup to appear.

I have experienced this behavior too. It is really frustrating when it happens. The solution, however, is really simple. In SQL Developer, go to Tools > Preferences > Code Insight and uncheck both “Enable Auto-Popup” check boxes as seen in the following screenshot:


Now, instead of letting it load automatically, you control when the context sensitive code completion insight popup appears. Simply press Ctrl+Space and voila.

By the way, Vadim Tropashko has a great article about getting most of code completion in SQL Developer.

Comments Off on Control When Oracle SQL Developer Completes Your Code | Filed in Oracle | Tags:

Better SQL Formatter in Oracle SQL Developer, Finally a Reality

As mentioned on, Oracle SQL Developer 1.5 Early Adopter 1 (EA1) is now available for download. As with any new release, there are new features and bug fixes. But, they are not yet detailed in the release notes.

However, I know that the one feature that I have been eagerly waiting for is finally here, it is the brand new and enhanced SQL Formatter (screenshots below). Not bad at all!

I’ll be using SQL Developer 1.5 as my main SQL and PL/SQL development tool for the next few days and weeks. Let’s see if this release will convince me to ditch Quest’s SQL Navigator.






5 Comments | Filed in Oracle | Tags: , , ,

Oracle SQL Developer 1.2 Released

Oracle SQL Developer, the free graphical tool for database development, has just been upgraded from 1.1 to 1.2. Here is the list of bug fixes and here is the release notes document including new features and known issues.

If you are already running production release 1.1 (v or above, you can use Help > Check for Updates to update your SQL Developer environment. Otherwise, you can download Oracle SQL Developer 1.2 from here.

1 Comment | Filed in Oracle | Tags:

The Case of Better Readable Code

When you code, you write your programs either in all lower case, all upper case, or a combination of the two. Let’s take PL/SQL for example, almost all PL/SQL programming best practices and coding styles that I’ve come across recommend using upper and lower. The following is an excerpt from the book Oracle PL/SQL Best Practices By Steven Feuerstein: Continue reading…

7 Comments | Filed in Interesting, Oracle | Tags: , , , , ,

Oracle SQL Developer 1.1 New Features

Sue mentioned two SQL Developer 1.1 new features today. 1) Sort on column headers, available on any grid of data. 2) Display a single record on a form layout. Cool.

6 Comments | Filed in Oracle | Tags:

SQL Developer and UTF8

In this global economy the need for software globalization is increasing. As a result of this globalization, localization is becoming an important part of software development. And as a result of this localization, software developers like myself will have to work with multiple languages. So, it is becoming more crucial to have development tools that support multi-byte in addition to single-byte characters, like Chinese versus English for example.

As an Oracle database developer I have been using Quest Software Inc.’s SQL Navigator for years. We are currently involved in the implementation of Oracle E-Business Suite in our new plant in China. So, now we have the Chinese characters to worry about. It turns out that SQL Navigator does not support multi-byte characters and UTF8 encoding (which is needed to display Chinese characters), however, Oracle’s SQL developer does 🙂

Here is how SQL Navigator displays a query result that returns Chinese characters: Continue reading…

23 Comments | Filed in Oracle, Tips | Tags: , , , ,

Oracle SQL Developer Graduated

Following up on my last post: Oracle SQL Developer Updated, it was finally decided to release SQL Developer to production. So, go ahead and get your fresh copy from OTN.

Oracle Database 10g XE has this:

It would be nice to have a similar one for SQL Developer as well, would it?

Comments Off on Oracle SQL Developer Graduated | Filed in Oracle | Tags: , ,