Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » SQL Anywhere Server - Programming

JDBC support

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.

The software includes the SQL Anywhere JDBC driver, which is a Type 2 driver.

The software also supports the use of jConnect, a pure Java JDBC driver 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 the Java in the database feature.


In this section:
    JDBC applications
    You can develop Java applications that use the JDBC API to connect to a database. Several of the applications included with the database software use JDBC.
    JDBC drivers
    The SQL Anywhere JDBC driver and the jConnect driver are supported.
    SQL Anywhere JDBC driver
    The SQL Anywhere JDBC driver is recommended for its performance and feature benefits when compared to the pure Java jConnect JDBC driver. However, the SQL Anywhere JDBC driver does not provide a pure-Java solution.
    The jConnect JDBC driver
    To use JDBC from an applet, you must use the jConnect JDBC driver to connect to a database.
    JDBC program structure
    JDBC applications typically connect to a database, execute one or more SQL statements, process result sets, and then disconnect from the database.
    Differences between client- and server-side JDBC applications
    There are some minor differences between client-side and server-side JDBC applications.
    A sample client-side JDBC application
    A typical JDBC application connects to a database server, issues SQL queries, processes multiple results sets, and then terminates.
    A sample server-side JDBC application
    A typical JDBC application connects to a database server, issues SQL queries, processes multiple results sets, and then terminates.
    Notes on JDBC connections
    Be aware that there are differences between JDBC on the client side and on the server side. Aspects such as autocommit behavior and isolation levels are described here.
    Server-side data access using JDBC
    Database transaction logic implemented as Java methods that can be called from SQL can offer significant advantages over traditional SQL stored procedures.
    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. These are similar to the callbacks supported by the ODBC driver.
    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.
    SQL Anywhere JDBC API support
    Some optional methods of the java.sql.Blob interface are not supported by the SQL Anywhere JDBC driver.