JDBC applications

You can develop Java applications that use the JDBC API to connect to SQL Anywhere. Several of the applications supplied with SQL Anywhere use JDBC, such as the debugger, Sybase Central, and Interactive SQL.

Applications connecting to SQL Anywhere using JDBC.

Java and JDBC are also important programming languages for developing UltraLite applications.

JDBC can be used both from client applications and inside the database. Java classes using JDBC provide a more powerful alternative to SQL stored procedures for incorporating programming logic into the database.

JDBC provides a SQL interface for Java applications: if you want to access relational data from Java, you do so using JDBC calls.

The phrase client application applies both to applications running on a user's computer and to logic running on a middle-tier application server.

The examples illustrate the distinctive features of using JDBC in SQL Anywhere. For more information about JDBC programming, see any JDBC programming book.

You can use JDBC with SQL Anywhere in the following ways:

  • JDBC on the client   Java client applications can make JDBC calls to SQL Anywhere. The connection takes place through a JDBC driver.

    SQL Anywhere includes JDBC 3.0 and 4.0 drivers, which are Type 2 JDBC drivers, and also supports the jConnect driver for pure Java applications, which is a Type 4 JDBC driver.

  • JDBC in the database   Java classes installed into a database can make JDBC calls to access and modify data in the database using an internal JDBC driver.

 JDBC resources
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0