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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|