SQL/OLB: Difference between revisions

Revision as of 19:16, 14 October 2009

Latest revision as of 03:30, 11 May 2022

(21 intermediate revisions by 10 users not shown)

Line 1:

The '''SQL/OLB''', or ''Object Language Bindings'', extensionis toa thestandard for embedding [[SQL]] standardin is[[Java defined(programming language)|Java]], commonly known by its prior name as [[ISOSQLJ]]/IEC 9075-10:2003(part 0). SQL/OLBBesides definesdescribing the syntax and symanticssemantics of [[SQLJ]], which isare SQLtypically embeddedgiven inrelative to [[Java (programming language)|JavaJDBC]]., Thethe standard also describes mechanisms to ensure binary portability of SQLJ applications, and specifies various Java packages and their contained classes.

SQL/OLB was informally known as "[[SQLJ]] part 0" before standardization, which first occurred under the aegis of [[ANSI]] in 1998 and then ISO in 2000. Although the latter was published after the bulk of [[SQL:1999]], officially it was "part 10" of that standard—a convention that was maintained for subsequent ISO SQL standards, including the current one, [[SQL:2011]].

== Examples ==

{{expand section|date=November 2012}}

For some (possibly outdated) examples, see the article on [[SQLJ]].

== Implementations ==

{{expand section|date=November 2012}}

Both [[Oracle database|Oracle 8i]] and [[IBM DB2]] introduced support around 1999.<ref name="MeltonEisenberg2000">{{cite book|author1=Jim Melton|author2=Jim Melton Andrew Eisenberg|title=Understanding SQL and Java Together: A Guide to Sqlj, Jdbc, and Related Technologies|url=https://archive.org/details/understandingsql00melt|url-access=registration|year=2000|publisher=Morgan Kaufmann|isbn=978-1-55860-562-6|page=[https://archive.org/details/understandingsql00melt/page/173 173]}}</ref> Oracle 12c claims conformance with SQL/OLB:1999, but not with the newer SQL/OLB:2008.<ref>{{cite web | url=http://docs.oracle.com/cd/E16655_01/server.121/e17209/ap_standard_sql008.htm | title=Page Moved }}</ref>

==See also==

*[[SQL]]

*[[SQLJ]] (an outdated term for SQL/OLB)

*[[SQL:2003]]

*[[Language Integrated Query]]

==External linksReferences==

{{reflist}}

* [http://www.jcc.com/sql.htm Short description]

{{database-stubSQL}}

{{DEFAULTSORT:SQL OLB}}

[[Category:SQL]]

[[ru:SQL/OLB]]

{{database-stub}}