SQL/JRT, or ''SQL Routines and Types for the Java Programming Language'', is an extension to the
SQL standard first published as
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 mo ...
methods as routines from within SQL applications, commonly referred to as "Java
stored procedure
A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS). Such procedures are stored in the database data di ...
s". 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 organ ...
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.)
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 manual](_blank)
/ref> Java stored procedures have also been implemented in Oracle's JServer (or Aurora JVM), which was introduced in the Oracle Database
Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.
It is a database commonly used for running online ...
version 8i in 1999;
Oracle Corp. it is now called
Oracle JVM.
IBM DB2
Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and ...
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
Farrago is a Latin word, meaning "mixed cattle fodder", used to refer to a confused variety of miscellaneous things. As a name, it may refer to:
* ''Farrago'' (plant), a genus of plants in the family Poaceae
* ''Farrago'' (magazine), student newsp ...
documentation
SQL
{{database-stub