What's New in 11g Release 1 (11.1)

The following new SQLJ-related features have been introduced in Oracle Database 11g Release 1 (11.1):

• Support for JDK 1.5 and JDK 1.6

• Enhanced Profile Print Option

• Outline Generation

• Support for Global Transactions

Support for JDK 1.5 and JDK 1.6

In Oracle Database 11g Release 1 (11.1) SQLJ programs, the following JDK1.5 specific language structures are allowed outside the #SQL region:

JDK 1.5

• strictfp

• Assert

• Generics

• Enhanced for Loop

• Autoboxing/Unboxing

• Typesafe Enums

• Varargs

• Static Import

• Annotation

http://java.sun.com/j2se/1.5.0/docs/relnotes/features.html

JDK 1.6

Starting from Oracle Database 11g Release 1 (11.1), SQLJ programs are supported in JDK 1.6.x environment. Refer to Chapter 1, "Getting Started" for more information.

Enhanced Profile Print Option

The SQLJ profile print option has been enhanced to output all the options set on the customizer. This feature is discussed in detail in "Profile Customization (ISO Code Generation)".

Outline Generation

You can use the outline feature of Oracle to support plan stability. This feature is discussed in detail in "Execution Plan Fixing".

Support for Global Transactions

The X/Open Distributed Transaction Processing coordinates the work between application programs and resource managers into global transactions. This feature is discussed in detail in"SQLJ Support for Global Transactions" .