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.

To access the JDBC Guide: Getting Started manual for JDBC 1.0, go to http://java.sun.com/products/jdk/1.1/docs/guide/jdbc.

To access the JDBC Guide: Getting Started manual for JDBC 2.1, go to http://java.sun.com/products/jdk/1.2/docs/guide/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

SYBSOCKET_FACTORY connection property

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

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

Dynamic class loading

JDBC 2.0 optional package extensions support

Restrictions on and interpretations of JDBC standards

Connection.isClosed() and the IS_CLOSED_TEST connection property

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