JDBC CLI

JDBC is a call-level interface for Java applications. JDBC provides you with a uniform interface to a wide range of relational databases, and provides a common base on which higher level tools and interfaces can be built. JDBC is now a standard part of Java and is included in the JDK.

SAP Sybase IQ includes a 4.0 driver, which is a Type 2 driver.

SAP Sybase IQ also supports a pure Java JDBC driver, named jConnect, which is available from SAP.

In addition to using JDBC as a client-side application programming interface, you can also use JDBC inside the database server to access data by using Java in the database.

• JDBC Applications
  You can develop Java applications that use the JDBC API to connect to SAP Sybase IQ. Several of the applications supplied with SAP Sybase IQ use JDBC, such as Interactive SQL.
• JDBC Drivers
  SAP Sybase IQ supports the following JDBC drivers:
• JDBC Program Structure
  The following sequence of events typically occurs in JDBC applications:
• Differences Between Client- and Server-Side JDBC Connections
  A difference between JDBC on the client and in the database server lies in establishing a connection with the database environment.
• SQL Anywhere JDBC Drivers
  The SQL Anywhere JDBC 4.0 driver provides some performance benefits and feature benefits compared to the pure Java jConnect JDBC driver, however, this driver does not provide a pure-Java solution. The SQL Anywhere JDBC 4.0 driver is recommended.
• The jConnect JDBC Driver
  The jConnect driver is available as a separate download. To use JDBC from an applet, you must use the jConnect JDBC driver to connect to SAP Sybase IQ databases.
• Connections from a JDBC Client Application
  Database metadata is always available when using a SQL Anywhere JDBC driver.
• How to Establish a Connection from a Server-Side JDBC Class
  SQL statements in JDBC are built using the createStatement method of a Connection object. Even classes running inside the server need to establish a connection to create a Connection object.
• Notes on JDBC Connections
  Familiarize yourself with autocommit behavior, transaction isolation levels, and connection defaults.
• Data Access Using JDBC
  Java applications that hold some or all classes in the database have significant advantages over traditional SQL stored procedures. At an introductory level, however, it may be helpful to use the parallels with SQL stored procedures to demonstrate the capabilities of JDBC. In the following examples, you write Java classes that insert a row into the Departments table.
• JDBC Callbacks
  The SQL Anywhere JDBC driver supports two asynchronous callbacks, one for handling the SQL MESSAGE statement and the other for validating requests for file transfers.
• JDBC Escape Syntax
  You can use JDBC escape syntax from any JDBC application, including Interactive SQL. This escape syntax allows you to call stored procedures regardless of the database management system you are using. The general form for the escape syntax is
• JDBC 4.0 API Support
  All mandatory classes and methods of the JDBC 4.0 specification are supported by the SQL Anywhere JDBC driver. Some optional methods of the java.sql.Blob interface are not supported. These optional methods are: