Using SQLJ

Course Number:  554-JK
Recommended Duration:  2 days

Intended Audience
Experienced Java developers who need to use SQLJ to access an SQL database from Java.

Course Overview
Java programmers learn to use SQLJ to work with SQL database data (principally DB2 and Oracle) in Java programs.  There are eight machine exercises.  Exercises use text editor, Sun Java J2SE JDK and the locally available database.  IDEs such as Eclipse, WSAD, JDeveloper, JBuilder, etc... may be used upon request.

Course appropriate for Java 5.0 (Java 1.5).  Course covers Java 2 (aka. Java 1.4) with some new Java 5.0 features being introduced.  Most topics and examples also apply to Java 1.1, Java 1.2, Java 1.3, and Java 1.4.

Objectives
Participants will enhance existing Java skills by learning to develop, test, and deploy Java database programs using SQLJ.  Hands-on exercises reinforce new concepts.

Prerequisites
Students must have Java experience or have completed "Java Client-Side Programming I", "Java Server-Side Programming I" or equivalent.  Knowledge of SQL is very useful, but, not required.

Topics

• Introduction to SQLJ

• Overview of JDBC

• SQLJ and SQL

• Introduction to SQLJ

• Connection clause

• Iteration clause

• Executable clause

• Oher SQLJ clauses

• Host expressions

• Connection drivers

• Connection pools

• Connection property files

• Single-row queries

• Multiple-row queries, iterators

• Updating database data

• Stored procedures

• SQL exception handling

• Servlets/JSPs and SQLJ

• DB2 and/or Oracle features