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.
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 contact ABIS.
Java programmers who want to access a relational database using SQLJ.
Knowing JDBC is mandatory (see course JDBC).
- 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
The theoretical foundation is illustrated with practical exercises. The participants will work with Java applications accessing IBM Db2 or Oracle databases.
an ABIS instructor.
|SESSION INFO AND ENROLMENT|