Programming Information

This chapter describes the basic components and programming requirements that comprise jConnect for JDBC. It explains how to invoke the jConnect driver, set connection properties, and connect to a database server. It also contains information about using jConnect features.

For information about JDBC programming, go to http://java.sun.com/jdbc.

Setting up jConnect

Setting the jConnect version

Invoking the jConnect driver

Establishing a connection

Setting connection properties

Connecting to Adaptive Server

Connecting to Adaptive Server Anywhere

Connecting to a server using JNDI

Implementing custom socket plug-ins

Creating and configuring a custom socket

Handling internationalization and localization

Using jConnect to pass Unicode data

jConnect character-set converters

Working with databases

Implementing high availability failover support

Performing server-to-server remote procedure calls

Using wide table support for Adaptive Server version 12.5 and later

Accessing database metadata

Using cursors with result sets

Support for batch updates

Updating a database from a result set of a stored procedure

Working with datatypes

Implementing advanced features

Using event notification

Handling error messages

Storing Java objects as column data in a table

Using dynamic class loading

JDBC 2.0 optional package extensions support

Restrictions on and interpretations of JDBC standards

Using JDBC 3.0 method stubs

Using Connection.isClosed and IS_CLOSED_TEST

Using Statement.close with unprocessed results

Making adjustments for multithreading

Using ResultSet.getCursorName

Using setLong with large parameter values

Using COMPUTE statements

Executing stored procedures


	Expand Search