Sept 15,  2004
John Garmany

If you are developing your application using J2EE then Oracle's JDeveloper is the tool for you!  Oracle has put a lot of effort into creating and improving JDeveloper, to include using it for internal Oracle development.  As one Oracle developer told me, "When you eat the food you cook, you tend to do a better job at cooking."

If you want to check out JDeveloper you can download it from otn.oracle.com

J2EE applications are normally deployed into an application server as war or ear files.  You can manually deploy the files however placing them in archives (war, ear) is less complicated and less error prone.  You can deploy archives using the application server's Enterprise Manager Application Server Control or you can deploy then directly from JDeveloper

First you need to create a connection from JDeveloper to the OC4J container in AS10g.

A wizard will start that walks you through the connection creation.

Enter a name for this connection and select the version (or brand) of Application Server you are using.

It will next ask for the username and password for the AS instance.  For AS10g this is ias_admin/your password.  Now you need to tell JDeveloper where within the AS to connect to.  I created a new OC4J instance in my AS10g Portal instance called AppDev.  Don't forget to start the container.  In step 3 I entered my host name, the port used to connect to Application Server Control, the ORACLE_HOME for that instance and the name of my container.

Step 4 ask for the connection password for JMI and step 5 allows you to test the connection.

This connection allows you to deploy your application directly into the Application Server from JDeveloper.

Get the Complete Oracle SQL Tuning Information  The landmark book "Advanced Oracle SQL Tuning  The Definitive Reference"  is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.