SQL/OLB, or ''Object Language Bindings'', is a standard for embedding
SQL in
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 ...
, 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
Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. I ...
, 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
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 ...
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
For some (possibly outdated) examples, see the article on
SQLJ.
Implementations
Both
Oracle 8i and
IBM DB2 introduced support around 1999.
Oracle 12c claims conformance with SQL/OLB:1999, but not with the newer SQL/OLB:2008.
See also
*
SQL
*
SQLJ (an outdated term for SQL/OLB)
*
SQL:2003
*
Language Integrated Query
Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, originally released as a major part of .NET Framework 3.5 in 2007.
LINQ extends the langua ...
References
SQL
{{database-stub