back to Course Categories | back | print
Oracle 9i Java Database Programming          

Duration: 3 days

Description 
This course is designed to teach Java and Oracle programmers how to create database programs using Java. Students will learn how to use JDBC and SQLJ to perform database operatoins. Students will create stored procedures, functions, packages, database triggers, object methods, instead-of triggers, database triggers and instance triggers in Java. Examples and exercises will demonstate how SQL, PL/SQL and Java are all integrated in Oracle.

Topics

  • Understanding the Oracle9i JVM and J2EE architecture
  • Oracle's Java strategy
  • Overview of Oracle Components for Java (OC4J)
  • Overview of Business Components for Java (BC4J)
  • Oracle Application Development Framework
  • Java stored procedures, functions and packages
  • Writing Java database table triggers
  • Java Database Connectivity (JDBC)
  • Different types of JDBC drivers
  • Connecting to Oracle
  • Loading JDBC drivers
  • Preparing statements
  • Coding for batch processing
  • Working with Oracle metadata
  • Using Oracle extensions to JDBC
  • Managing transactions using JDBC
  • Processing a SQL query
  • Executing a DML statement
  • Executing a DDL statement
  • Database, Connection, QueryDataSet and QueryResolver components
  • Mapping Oracle and Java data types
  • Handling Null values
  • Using LOBS and Oracle objects
  • Writing Dynamic SQL
  • Working with bind variables
  • Working with ResultSets
  • Prefetching rows
  • Implementing database and schema triggers using Java
  • Prespecifying column types
  • Writing object methods using Java
  • Error handling
  • Using JNDI services
  • Establishing a data source
  • Connection pooling
  • Caching
  • Client security
  • Connection Manager
  • Why use SQLJ
  • Working with host variables
  • Executing a SQL query with SQLJ
  • DDL statements with SQLJ
  • DML statements with SQLJ
  • Using iterators for multi-row processing
  • Dynamic SQLJ in SQLJ
  • Named versus positional iterators
  • Working with lobs
  • Native mappings
  • JDBC versus SQLJ
  • Compile time checking
  • Connection properties
  • Open standards
  • Java security
  • JPublisher
  • User defined types and Java classes
  • Working with collections and LOBS
  • Java versus native mappings
  • Java in-line functions
  • Integrating SQL, PL/SQL and Java
  • Calling Java routines from PL/SQL
  • Calling PL/SQL routines from Java
  • Processing a ResultSet for a stored procedure
  • Creating a deployment profile
  • Deploying a stored procedure
  • Java versus PL/SQL security issues

Prerequisites

  • Experience with Oracle and SQL is required.
  • A basic understanding of Java and PL/SQL programming is required.

  • This is an intense programming class designed to teach Oracle developers what they need to know to write Java programs that access Oracle databases.

 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design