Using SQLJ

Recommended Duration:
2 Days
Version
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.
Benefits
Participants will enhance existing Java skills by learning to develop, test, and deploy Java database programs using SQLJ. Hands-on exercises reinforce new concepts.
Audience
Experienced Java developers who need to use SQLJ to access an SQL database from Java.
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.
Major 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
Exercises
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.