Table of Contents
Using Java to access UDO Features..Shawn Swart
Introductions
Session Overview
Why learn learn JDBC?
Types of JDBC Drivers
Informix’s Java Database Drivers
JDBC Version Scope
Informix Corner Cases
The JDBC Package
Connecting
Registering the JDBC Driver
Database URLs
The Sub-name
Making the connection
Retrieving Data
Retrieval with the Statement Interface
Retrieval with the PreparedStatement Interface
Retrieving with the CallableStatement Interface
Changing Data
Updates via the Statement Interface
Updates via the PreparedStatement Interface
Errors accessing a Database
SQLException
SQLWarning
DataTruncation
JDBC MetaData
DatabaseMetaData
ResultSetMetaData
Transactions
JDBC Types
Accessing Tables that utilize ROW Types with JDBC 1.x
Inaccessible features of UDO with the JDBC 1.x driver
What We Covered So Far
More of What We Covered
Questions?..Break
Topics for Part 2
Connectivity Enhancements
Using JNDI
Using SQLHOSTS file
Password Encryption
ResultSet enhancements
The SCROLL_INSENSITIVE Cursor
The SCROLL_INSENSITIVE Cursor Navigation methods.
HTTP Proxy Servlet
More on proxying JDBC connections
Accessing Extended Types
Mapping New Data Types
Setting the Type Mapping
Opaque Types
Datablade API Types
Accessing Opaque Types
Accessing Opaque Types...
Accessing Named Rows using the SQLData interface
Accessing Named Rows using the Struct interface
Accessing Distinct Types
Caching of Type Names
Informix SQLJ Briefly
Informix SQLJ Briefly
SQLJ Basic Syntax
Informix Extensions
Utilities and Tools
Part 2 Summary
PPT Slide
|
