Geophysical Database Access Using Oracle9i SQLJ Implementations

Nirva Morisseau-Leroy, Mark Powell
AOML/Hurricane Research Division

We will present a complete SQLJ program that illustrates how to efficiently insert atmospheric observation objects into the H*WIND Scientific Schema. The H*WIND database schema, designed for the NOAA/Hurricane Research Division, is stored in an Oracle8i data server located in Miami. The HRD's atmospheric scientists use the H*WIND database to generate real-time analyses of tropical cyclone surface wind observations from all over the World. This tutorial will focus on the basic features of SQLJ. SQLJ is an embedded SQL standard for Java specified by ANSI/ISO standards organization. Specifically, you will learn the major components of Oracle9i SQLJ, SQLJ declaration statements (iterator and connection context declarations, and SQLJ executable statements.

BIO - Nirva Morisseau-Leroy Nirva Morisseau-Leroy is a Senior Software/Oracle application developer at the Hurricane Research Division of the NOAA Atlantic Oceanographic and Meteorological Lab (AOML) of OAR. AUTHOR · Principal and lead author of Oracle9i SQLJ Programming: Developing robust, multi-platform database applications with the revolutionary new embedded SQL for Java, published by Oracle Press (McGraw-Hill/Osborne), July 2001 · Principal and lead author of Oracle8i Java Component Programming With EJB, CORBA AND JSP: Developing database component-based applications with EJB, CORBA, and JSP using JDBC and SQLJ implementations published by Oracle Press (McGraw-Hill/Osborne), September 2000. · Principal and lead author of Oracle8i SQLJ Programming: Developing robust, multi-platform database applications with the revolutionary new embedded SQL for Java , a bestseller on both amazon.com and bn.com, published by Oracle Press (McGraw-Hill/Osborne), November 1999

Auditorium - Tutorial Wednesday - 4:10 - 5:00 P.M.