SQL/JRT
SQL/JRT,orSQL Routines and Types for the Java Programming Language,is an extension to theSQLstandard first published asISO/IEC 9075-13:2002 (part 13 ofSQL:1999). SQL/JRT specifies the ability to invoke staticJavamethods as routines from within SQL applications, commonly referred to as "Javastored procedures".SQL/JRT also calls for the ability to use Java classes as SQLstructured user-defined types.The two parts of the extension originate from the earlierANSISQLJpart 1 and 2 standards (not to be confused with SQLJ part 0, which defined an embedding of SQL into Java, later standardized by ISO asSQL/OLB.)
Example[edit]
SQL/JRT allows a Java function to be called from SQL code like this:[1]
CREATEFUNCTIONsinh(vDOUBLE)RETURNSDOUBLE
LANGUAGEJAVADETERMINISTICNOSQL
EXTERNALNAME'CLASSPATH:java.lang.Math.sinh'
SELECTsinh(doublecolumn)FROMmytable
SQL/JRT also allows Java code to dynamically generate tables using ajava.sql.ResultSet
object. The result sets returned are converted to SQL tables and can be used anywhere a table or view can be used.[1]
Implementations[edit]
![]() | This sectionneeds expansion.You can help byadding to it.(November 2012) |
SQL/JRT stored procedures are implemented inHSQLDB.[1]Java stored procedures have also been implemented in Oracle'sJServer(or Aurora JVM), which was introduced in theOracle Databaseversion 8i in 1999;[2][3]it is now calledOracle JVM.[4]IBM DB2also supported Java stored procedures since about 1998, although using an external JVM (at that time).[5]
See also[edit]
References[edit]
- ^abcHSQLDB manual
- ^Bulusu Lakshman (2002).Oracle & Java Development.Sams Publishing. p. 6.ISBN978-0-672-32117-7.
- ^The Aurora JVM and Its Components,Oracle Corp.
- ^Rick Greenwald; Robert Stackowiak; Jonathan Stern (2008).Oracle Essentials: Oracle Database 11g.O'Reilly Media, Inc. p.323.ISBN978-0-596-51454-9.
- ^Don Chamberlin (1998).A Complete Guide to DB2 Universal Database.Morgan Kaufmann. p. 565.ISBN978-1-55860-482-7.Retrieved16 November2012.
External links[edit]
- SQL:2003 SQL/JRT draft
- SQL:2003 SQL Standard User Defined Types and Routinesfrom theFarragodocumentation