|
SQLJ
SQLJ was developed by The SQLJ Group, a consortium comprised of database vendors and Sun Microsystems. The SQLJ Group submitted SQLJ in three parts to the NCITS Technical Committee H2 on Database. H2 has adopted the three parts into the SQL standard.
|
|
SQLJ—Part 1: SQL Routines
using the JavaÔ Programming Language
This document is the SQLJ: SQL Routines Using the Java Programming Language specification.
It defines SQL extensions for installing Java classes in an SQL system, for invoking static methods
of Java classes in SQL as SQL functions and stored procedures, for obtaining specified output
values of parameters, and for returning SQL result sets.
|
|
SQLJ—Part 2: SQL Routines
using the JavaÔ Programming Language
|
|
Database Connections and SQLJ Statements
This second column in my Learning SQLJ series explores how to connect to a database and embed SQL statements in your Java programs using SQLJ
|
|
Contexts and Multithreading
There are two important objects used in SQLJ that affect the execution of database operations: connection contexts and execution contexts. Connection contexts are used to connect to a database.
|
|
SQLJ Support in DB2 Universal Database Version 7.1
This page has been replaced by the Java Enablement with DB2 Universal Database page. Platform information, support documentation and links to related information are available there.
|
|
Application Programming
Guide and Reference
FOR JAVA
JDBC is a Java application programming interface (API) that Java applications use to
access any relational database. DB2 for OS/390’s support for JDBC enables you to
write Java applications that access local DB2 data or remote relational data on a server
that supports DRDA.
|
|
SQLJ: The 'open sesame' of Java database applications
Developers programming data-intensive applications in general-purpose languages such as C and COBOL have long had the ability to use SQL. SQL is a data sublanguage with powerful features for querying, maintaining, and managing data, which are key to the vast majority of enterprise applications today.
|
|
Implementing SQLJ
Give your Java applications database access simply and quickly by embedding static SQL statements directly in your Java source files.
|
|
Part I: An Overview of SQLJ
Instead of porting code in time-consuming fashion from one database platform to another, and dealing with proprietary procedural languages, use SQLJ to write Oracle stored procedures with database-independent code that can be easily ported to other Java-enabled database platforms.
|
|
Using SQLJ with application servers
SQLJ is an alternative to using JDBC for providing persistence to the J2EE application server platform. Because SQLJ is built, in part, on JDBC, it shares many of the same issues JDBC has with data conversion. For more information on the SQLJ interface, see the discussion of Part 0 for SQLJ (new window). Also see the discussion of using JDBC with application servers (new window).
|
|
How to connect to database using SQLJ from servlet?
Question of the Week presents answers to key questions posed by the developer community. The intent is to pass this important, but not always easy-to-find, information on to Java Developer ConnectionSM (JDC) members.
|
|
SQLJ: An Easier Way to Access SQL Data
Have you found the long hand-coding required by JDBC tedious and error-prone? Would you like to know when you've misspelled a database column name before runtime? SQLJ provides a solution to overcome these difficulties and others. In much the same way that JSP simplified the creation of Servlets for the Java community, SQLJ can simplify database access that has traditionally been done with JDBC. In this article, Blair Taylor and James Woodger give you the bottom line on SQLJ.
|
|
Oracle9i SQLJ Developer's Guide and Reference
Release 1 (9.0.1)
SQLJ enables applications programmers to embed SQL operations in Java code in a way that is compatible with the Java design philosophy. A SQLJ program is a Java program containing embedded SQL statements that comply with the ISO-standard SQLJ Language Reference syntax. Oracle9i SQLJ supports the SQLJ ISO standard specification.
|
|
Part II: SQLJ Language Elements
SQLJ is the evolving industry standard language that allows you to write Oracle stored procedures with database-independent code that can be easily ported to other Java-enabled database platforms. Get the lowdown on connection contexts, iterators, executable statements, and host expressions so you can put some actual SQLJ to use.
|
|
SQLJ User Guide and Reference
This manual contains information about using Informix Embedded SQLJ. This section discusses the organization of the manual, the intended audience, and the associated software products that you must have to use Informix Embedded SQLJ.
|
|
SQLJ data conversion
When you use SQLJ with existing databases, the data conversion (or mapping) from tables to objects and back must be performed in the application or the application server. This is illustrated in the diagram where you see the mapping layer above the JDBC interface.
|
|
DATA ACCESS WITH SQLJ
EMBEDDING SQL IN JAVA
This chapter covers the use of embedded SQL in Java, known as SQLJ technol-ogy.
The focus of the chapter is on how to use SQLJ rather than JDBC to perform
database operations from a Java application.
|
|
Oracle8i SQLJ Developer's Guide and Reference
Release 8.1.5
SQLJ allows applications programmers to embed static SQL operations in Java code in a way that is compatible with the Java design philosophy. A SQLJ program is a Java program containing embedded static SQL statements that comply with the ANSI-standard SQLJ Language Reference syntax; static SQL operations are predefined.
|
|
SQLJ: Embedded SQL for Java
SQLJ is Structured Query Language (SQL) embedded in the programming language Java. This paper specifies the syntax and semantics of SQL statements and expressions statically embedded in Java. Sections 1 through 4 provide the rationale for SQLJ and a brief tutorial. Section 5 contains its specification. Appendix A: Design Notes contains discussion of some design and implementation issues. Appendix B compares SQLJ with the current ANSI/ISO Embedded SQL standard.
|
|
SQLJ in the Server
SQLJ applications can be stored and run in the server. You have the option of either translating and compiling them on a client and loading the generated classes and resources into the server, or loading SQLJ source code into the server and having it translated and compiled by the server's embedded translator.
|
|
Application Development Guide
DB2 Universal Database implements two standards-based Java programming APIs: Java Database Connectivity (JDBC) and embedded SQL for Java (SQLJ). This chapter provides an overview of JDBC and SQLJ programming, but focuses on the aspects specific to DB2. See the DB2 Universal Database Java website for links to the JDBC and SQLJ specifications.
|