O'Reilly logo

Java Programming with Oracle SQLJ by Jason Price

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required