Open SQL/JDBC 

Purpose

The aim of Open SQL for Java is to enable Java users to develop database access independently of a particular database system. This goal is achieved by:

·        Defining a subset of SQL that is comprehensible for all database systems. For more information, see Open SQL Grammar.

·        Defining a subset of JDBC that is compatible with all database systems. This section deals with Open SQL/JDBC.

Features

Although JDBC is a standard that is recognized by the Java community, existing implementations of various database vendors differ in details. Open SQL/JDBC is the JDBC-compatible implementation of the essential parts of the JDBC standard. This implementation enables you to access portably all database systems that are supported by SAP. Open SQL/JDBC implements the interfaces from the Java package java.sql.*.

Using Open SQL/JDBC, you can select and modify data in existing database tables. The tables are created in the Java Dictionary.

For more information about the most important aspects of Open SQL/JDBC use, see:

·        Getting a Connection to the Database

·        Inserting Data into A Table

·        Using Queries

·        Semantics of the Data Types DATE, TIME, and TIMESTAMP

·        Transactions in Open SQL/JDBC

·        Native SQL Access

·        Error Handling

 

See also:

Overview of the JDBC API