The SQLJ consortium of SQL vendors develops specifications for using Java with SQL. The consortium submits these specifications to ANSI for formal processing as standards. The standards can be found on the Web at http://www.ansi.org. In this document, SQLJ refers to capabilities compliant with SQLJ Part 1 of the standard specifications
Compliance with SQLJ standards ensures that Sybase functionality ports to all third-party, standards-compliant relational databases.The standard specifications are in three parts:
Part 0 – “Database Language SQL—Part 10: Object Language Bindings (SQL/OLB),” ANSI X3.135.10-1998.
Specifications for embedding SQL statements in Java methods. Similar to the traditional SQL facilities for embedded SQL in COBOL and C and other languages. The Java classes containing embedded SQL statements are precompiled to pure Java classes with JDBC calls.
Part 1 – “SQLJ—Part 1: SQL Routines using the Java Programming Language,” ANSI NCITS N331.1.
Specifications for installing Java classes in a SQL system, and for invoking Java static methods as SQL stored procedures and functions.
Part 2 – “SQLJ—Part 2: SQL Types using the Java Programming Language,” ANSI NCITS N331.2.
Specifications for using Java classes as SQL datatypes.
Sybase supports Part 1 of the specification. In addition, Sybase extends the capabilities provided in the standard. For example, Adaptive Server allows you to reference Java methods and classes directly in SQL, whereas SQLJ Parts 1 and 2 require that you use SQL aliases.