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.2. Designing Server-Based SQLJ Programs

The JServer JVM is integrated with the Oracle8i database, and as you might imagine, developing a SQLJ program to be run by the JServer JVM is somewhat different from developing the SQLJ programs you have seen so far. The following list highlights the issues unique to SQLJ programs designed to run within the JServer JVM:

  • The SQLJ runtime packages are available to the JServer JVM.

  • A connection to the database does not have to be made by your program because the JServer JVM already has a connection to the database.

  • The connection between your program and the database is permanent and therefore cannot be closed: attempts to close the connection are ignored.

  • There is no auto-commit functionality, so your program should commit or roll back the results of your SQL DML statements explicitly.

  • By default, Java programs running in the JServer JVM send their output to the database trace file. However, this output can be routed to the screen.

In the following sections, I discuss each of these issues in detail.

6.2.1. SQLJ Runtime Packages

SQLJ programming depends on a number of Java packages. When you write a SQLJ program for a JVM that is external to the database, you usually import SQLJ runtime packages such as oracle.sqlj.runtime.Oracle. However, when your target is the JServer JVM, which is integrated with the database, these packages are already available.

6.2.2. Database Connections

When your programs run in the JServer JVM, you do not ...

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