Java Programming with Oracle SQLJ

6.7. Using JDeveloper to Translate and Load SQLJ Programs

Oracle JDeveloper may be used to deploy SQLJ programs directly to the server without you having to use the loadjava command-line utility, and will even create the PL/SQL wrappers for you. As you will see in this section, JDeveloper can significantly reduce the amount of manual labor required to deploy SQLJ classes to the server.

The examples in this section show how to deploy the ServerExample1 class to the fundamental_user schema. If you don't have JDeveloper, don't worry; this section is optional, as you can continue to use the command-line utilities that you've read about so far. If you do have JDeveloper, I have included the following files on this book's web site:

• The workspace file sqlj_workspace.jws

• The project file sqlj_project.jpr

If you want to follow along with the example in this section, start JDeveloper and open the workspace file sqlj_workspace.jws.

To deploy a SQLJ program to the JServer using JDeveloper, you must first perform the following steps:

1. Create a deployment profile that specifies the Java classes and methods you wish to deploy.

2. Create a connection to the database schema into which the Java classes are to be loaded.

The rest of this section guides you through the process of creating a deployment profile for the ServerExample1 class, creating a database connection to the fundamental_user schema, and, finally, deploying the ServerExample1 class to the JServer.

6.7.1. Creating a Deployment ...