Java Database Connectivity

Overview/Description
To describe database connectivity issues in the context of the J2EE platform and to outline how to use the core and extension JDBC APIs

Target Audience
Java developers who wish to gain an understanding of J2EE's support technologies, including JDBC, RMI, JMS, JNDI and CORBA; business analysts, system architects, technical managers, and technology evaluators who are interested in gaining an overview of enterprise development technologies

Prerequisites
A good working knowledge of the Java language, specifically the Java 2 Standard Edition development kit APIs; familiarity with distributed component development concepts and relational database technology would be an advantage

Expected Duration
320 Minutes

Objectives:

Java Database Connectivity

  • describe JBDC concepts and features.
  • describe the JDBC architecture.
  • describe the issues involved in selecting a JDBC driver to suit a particular application architecture.
  • describe the core and extension JDBC API packages.
  • describe the methods available to connect to a database using JDBC.
  • issue database requests.
  • describe how to handle SQL exceptions and warnings when issuing database requests.
  • use JDBC to execute statements on a database to insert and update information and to run a query to obtain a result set.
  • outline useful techniques for working with result sets.
  • outline how to use prepared statements to improve database efficiency.
  • describe how to code prepared statements.
  • describe how to use stored procedures to increase database performance.
  • describe transaction properties and explain how to manage transactions.
  • code a transactional update.
  • outline how to use the JTA in a distributed transaction system.
  • describe the issues involved in using connection pooling to improve database performance.


    • Course Number: 66651_eng