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 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 | Filed in Oracle, Tips | Tags: data-modeler, sql-developer
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.
@eddieawad Fixed checked in for the patch.In the meantime, just remove that line in the config— krisrice (@krisrice) December 27, 2012
@eddieawad Now it’ll just put a log entry saying bad config param for anything non-numeric in that spot and ignore empty values— krisrice (@krisrice) December 27, 2012
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.1 Comment | Filed in Oracle | Tags: apex, sql-developer
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 :
http://www.oracle.com/technology/products/database/sql_developer/files/NewFeatureList21.htm Here’s the OBE for the new Unit Testing:
In the SQL Developer group on OracleCommunity.net, 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 | Filed in Oracle | Tags: sql-developer
As mentioned on OracleCommunity.net, 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: formatter, pl/sql, sql, sql-developer
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 220.127.116.11.64) 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: sql-developer
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: formatter, keywords, pl/sql, reserved, sql-developer, sql-navigator
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
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: sql-developer, sql-navigator, toad, tool, utf8
Oracle Database 10g XE has this:
It would be nice to have a similar one for SQL Developer as well, would it?Comments Off | Filed in Oracle | Tags: software, sql-developer, tool