Home

	Expand Search

Programmer's Reference jConnect for JDBC 6.0

Chapter 2 Programming Information

Working with databases

Working with databases

This section discusses database issues relevant to jConnect and includes these topics:

• 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 high availability failover support

Overview

Requirements, dependencies, and restrictions

Implementing failover in jConnect

Performing server-to-server remote procedure calls

Using wide table support for Adaptive Server version 12.5 and later

Accessing database metadata

Server-side metadata installation

Using cursors with result sets

Creating a cursor

Using JDBC 1.x methods for positioned updates and deletes

Using JDBC 2.0 methods for positioned updates and deletes

Using a cursor with a PreparedStatement object

Using TYPE_SCROLL_INSENSITIVE result sets in jConnect

Support for batch updates

Implementation notes

Updating a database from a result set of a stored procedure

Working with datatypes

Sending numeric data

Updating image data in the database

Using text data

Using date and time datatypes

Using char/varchar/text datatypes and getByte