Java and SQLJ

Accessing existing or new relational databases from Java applications can be done using the native JDBC API. However, people experienced in SQL can use the complementary technique offered by SQLJ. SQLJ offers database access from Java with a similar feeling as the usage of embedded SQL in other environments.

This Java extension for SQL can be more efficient for creating database applications due to the fact that 'static SQL' can be created.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

Java programmers who want to access a relational database using SQLJ.

Background

Knowing JDBC is mandatory (see course JDBC).

Main topics

  • SQLJ vs. JDBC
  • Using static SQL:
  • Development cycle • packages • bind options
  • Using SQLJ:
  • Singleton select • cursor select
  • Processing results
  • Exception handling
  • Scrollable cursors • select for update
  • Non-select statements

Training method

The theoretical foundation is illustrated with practical exercises. The participants will work with Java applications accessing IBM Db2 or Oracle databases.

Duration

1/2 day.

Course leader

an ABIS instructor.


SESSION INFO AND ENROLMENT