Replaced by set of courses 86115-86123

Course Code NGE86009

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This final course in the series teaches how to use the new features in the JDBC 2.0 core API. It also covers using the optional API, which includes the ability to connect to a database with datasource objects that work with JNDI, and using rowsets.

Audience

The targeted audience for this course are system administrators, database administrators, programmers/analysts, software engineers, application developers, and system analysts. Learners should be able to design applications using object-oriented analysis and design, develop applications using the Java programming language, and use SQL to retrieve and manipulate data in a relational database.

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify new features in JDBC 2.0 Core API and JDBC 2.0 Optional Package API.
• Identify the rowset implementations, CachedRowSets, and RowSetReader and RowSetWriter.
• Identify how to use rowsets with EJB.

Topics Include

Unit 1: JDBC 2.0 API

• Identify the new functionality supported by JDBC 2.0 Core API.
• Match the SQL3 data types supported by JDBC 2.0 API with their uses.
• Identify the code to create a scrollable ResultSet object.
• Complete the code to move the cursor to a specific row in a scrollable ResultSet object.
• Select the code to retrieve values stored in a scrollable ResultSet object by using a cursor.
• Complete the code to create an updatable ResultSet object.
• Identify the code that is used to update a database by using an updatable ResultSet object.
• Sequence the lines of code that are used to insert a row in a table programmatically by using an updatable ResultSet object.
• Write the code to delete a row from a table programmatically by using an updatable ResultSet object.
• Write the code to refresh data in an updatable ResultSet object.
• Complete the code to view the changes made to an updatable ResultSet object.
• Complete the code to create a Statement object for a batch update in a specified situation.
• Identify the code that is used to handle a batch update exception.
• Select the code to define a SQL structured data type.
• Identify the code to create a DISTINCT data type.
• Complete the code to retrieve data from a field that implements a SQL3 data type.
• Select the code to create a class that implements the SQLData interface.
• Identify the code to make an entry for a UDT in the type map associated with a Connection object.
• Identify the code to retrieve values from a column that implements a type map.
• Identify the reason for selecting JDBC 2.0 Optional Package API in a specified situation.
• Label the connection pooling process that uses DataSource objects with method call and return components.
• Label the distributed transaction process that uses DataSource objects with method call and return components.
• Complete the code that implements JNDI API to make the code portable.

Unit 2: Rowset

• Identify the type of rowset that should be used in a specified situation.
• Write the code to create a CachedRowSet object at run time by using the default constructor provided by the RowSet class.
• Complete the code to set the properties of a rowset.
• Label the statement that must be specified with the statements that retrieve data from a table into a CachedRowSet object.
• Complete the code to propagate changes in a CachedRowSet object to a database.
• Write the code to register a bean as a listener to CachedRowSet.
• Match the components of EJB architecture with their functions.
• Identify the code that declares the methods that a client can call on an enterprise bean.
• Select the code for the home interface that declares the methods to locate, create, and remove a bean.
• Complete the code to define the business logic for an application.
• Complete the code to invoke the methods implemented in the enterprise bean class.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media