Add: title. Changed bare reference to CS1/2. | Use this bot. Report bugs. | Suggested by BrownHairedGirl | Linked from User:BrownHairedGirl/Articles_with_bare_links | #UCB_webform_linked 1225/2847
(9 intermediate revisions by 8 users not shown)
Line 1:
The '''SQL/OLB''', or ''Object Language Bindings'', is a standard for embedding [[SQL]] in [[Java (programming language)|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 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;. althoughAlthough 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 ==
Line 9:
== Implementations ==
{{expand section|date=November 2012}}
Both [[Oracle database|Oracle 8i]] and [[IBM DB2]] introduced support 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=httphttps://booksarchive.google.comorg/books?id=phbh1EK2aNMC&pgdetails/understandingsql00melt|url-access=PA173registration|year=2000|publisher=Morgan Kaufmann|isbn=978-1-55860-562-6|page=[https://archive.org/details/understandingsql00melt/page/173 173]}}</ref> Oracle 11gR212c claims conformance with SQL/OLB:1999, but not with the newer SQL/OLB:2008.<ref>{{cite web | url=http://docs.oracle.com/cd/E14072_01E16655_01/server.112121/e10592e17209/ap_standard_sql008.htm | title=Page Moved }}</ref>
