Database Issues

Failover Support
SAP jConnect supports the SAP Adaptive Server failover.
Server-to-Server Remote Procedure Calls
A Transact-SQL language command or stored procedure running on one server can execute a stored procedure located on another server.
Wide Table Support for Adaptive Server
SAP Adaptive Server 15.7 ESD #1 offers limits and parameters that are larger than previous versions of the database server.
Accessing Database Metadata
To support DatabaseMetaData methods, SAP Adaptive Server provides a set of stored procedures that SAP jConnect can call to obtain metadata about a database.
Use Cursors with Result Sets
SAP jConnect implements many JDBC 2.0 cursor and update methods.
Support for Batch Updates
Batch updates allow a Statement object to submit multiple statements as one unit (batch) to an underlying database for processing together.
Updating a Database from a Result Set of a Stored Procedure
SAP jConnect includes update and delete methods that allow you to get a cursor on the result set returned by a stored procedure.
Datatypes
Review the use of numeric, image, text, date, time, and char data.

Parent topic: Programming Information

Related concepts

Support for Batch Updates

Related tasks

Accessing Database Metadata

Related reference

Server-to-Server Remote Procedure Calls