Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Jdeveloper as PL/SQL IDE as well

dbibeauOct 4 2005 — edited Oct 7 2005
We are evaluating whether we should keep SQLNavigator, switch to TOAD, or switch to JDeveloper as our standard IDE in our department. I'm working with the 10.1.3 early release. We are mostly a pl/sql shop, but will be moving in the Java direction over the next few years. Some of us are doing Java now, and moving towards Jdev seems like the best option.

But I have a couple of questions to help me get started:

We use Starteam as our Version Control System with files maintained in directories. We never allow direct editing of stored code in the database. Developers are (supposed) to edit code on disk under VCS control, and then compile to the database. We also have a naming convention that may be different from other folks, such as
.PKS for package spec,
.PKB for package body etc

This would be the way we would work until a Starteam integration was developed for Jdeveloper.

I have managed to get Jdev to do code highlighting of disk files by going to "Preferences/File Types" and changing .PKB to SQL (there is no PL/SQL option). But it does not display the structure of the package body in the lower right. If I open the same package directly from the database, I do get structure breakdown. Is there some magic to getting it to show the structure? If it can do it from database source, then it should it be able to do it from a disk source file as well, right?

Also, One other feature that would be desirable is the ability to edit text in a column oriented mode. Currently we use a text editor called UltraEdit that does an amazing job in this regards. I know Jdev does mostly everything else, but when you are working large lists of columns and values as you do when editing Select statements and DML this is very useful for keeping things neat, tidy and uniform.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2005
Added on Oct 4 2005
8 comments
799 views