SQL/JRT, or ''SQL Routines and Types for the Java Programming Language'', is an extension to the
SQL standard first published as
ISO
ISO is the most common abbreviation for the International Organization for Standardization.
ISO or Iso may also refer to: Business and finance
* Iso (supermarket), a chain of Danish supermarkets incorporated into the SuperBest chain in 2007
* Iso ...
/IEC 9075-13:2002 (part 13 of
SQL:1999). SQL/JRT specifies the ability to invoke static
Java
Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's mos ...
methods as routines from within SQL applications, commonly referred to as "Java
stored procedures". SQL/JRT also calls for the ability to use Java classes as SQL
structured user-defined types. The two parts of the extension originate from the earlier
ANSI
The American National Standards Institute (ANSI ) is a private non-profit organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States. The organi ...
SQLJ part 1 and 2 standards (not to be confused with SQLJ part 0, which defined an embedding of SQL into Java, later standardized by ISO as
SQL/OLB SQL/OLB, or ''Object Language Bindings'', is a standard for embedding SQL in Java, commonly known by its prior name as SQLJ (part 0). Besides describing the syntax and semantics of SQLJ, which are typically given relative to JDBC, the standard als ...
.)
Example
SQL/JRT allows a Java function to be called from SQL code like this:
SQL/JRT also allows Java code to dynamically generate tables using a
java.sql.ResultSet object. The result sets returned are converted to SQL tables and can be used anywhere a table or view can be used.
Implementations
SQL/JRT stored procedures are implemented in
HSQLDB
HSQLDB (''Hyper SQL Database'') is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92, SQL:2008, SQL:2011, and SQL:2016 standards. It offers a fast, small (around 1300 kilobyte ...
.
[HSQLDB manual](_blank)
/ref> Java stored procedures have also been implemented in Oracle's JServer (or Aurora JVM), which was introduced in the Oracle Database version 8i in 1999;
Oracle Corp. it is now called
Oracle JVM.
also supported Java stored procedures since about 1998, although using an external JVM (at that time).
See also
*
SQL:2003
References
External links
SQL:2003 SQL/JRT draft
from the Farrago documentation
SQL
{{database-stub