About SQL in Java Programs

SQLJ is a standard way to embed static SQL statements in Java programs. The standard is being developed by a number of software vendors, including IBM, Tandem, Sybase, and Sun Microsystems, along with Oracle. SQLJ applications are portable and can communicate with databases from multiple vendors using standard JDBC drivers.

JDBC provides Java programs with low-level access to databases.

SQLJ provides a way to develop applications both on the client side and on the middle-tier that access databases using Java. Developing in SQLJ is fast and efficient, and JDeveloper completely supports SQLJ development. You can create or include SQLJ files in your JDeveloper projects. When you compile a project that contains SQLJ source files, JDeveloper automatically calls the SQLJ translator, or precompiler. The translator produces completely standard Java source code, with calls to JDBC methods to provide the database support. JDeveloper then compiles the Java that the SQLJ translator generates.

For more information, see the Oracle Database SQLJ Developer's Guide and Reference, available from the Oracle Database 10g Documentation Library on the Oracle Technology Network (OTN) at http://www.oracle.com/pls/db92/db92.homepage.