Home | Previous Page | Next Page

Performing Database Operations

In This Chapter

Querying the Database

Example of Sending a Query to an Informix Database

Using Result Sets

Deallocating Resources

Executing Across Threads

Using Scroll Cursors

Scroll Sensitivity

Client-Side Scrolling

Result Set Updatability

Using Hold Cursors

Updating the Database

Performing Batch Updates

SQL Statements and Batch Updates

Return Value from Statement.executeBatch() Method

Performing Bulk Inserts

Parameters, Escape Syntax, and Unsupported Methods

Using CallableStatement OUT Parameters

Server and Driver Restrictions and Limitations

JDBC Support for DESCRIBE INPUT

Using Escape Syntax

Unsupported Methods and Methods that Behave Differently

Handling Transactions

Handling Errors

Handling Errors With the SQLException Class

Retrieving the Syntax Error Offset

Catching RSAM Error Messages

Handling Errors with the com.informix.jdbc.Message Class

Accessing Database Metadata

Other Informix Extensions to the JDBC API

Using the Auto Free Feature

Obtaining Driver Version Information

Storing and Retrieving XML Documents

Setting Up Your Environment to Use XML Methods

Setting Your CLASSPATH

Specifying a Parser Factory

Retrieving Data

Inserting Data Examples

XMLtoString() Examples

XMLtoInputStream() Example

Retrieving Data Examples

StringtoDOM() Example

InputStreamtoDOM() Example

getInputSource() Examples

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]