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.
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: 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 SAP Sybase IQ. For more information about JDBC programming, see any JDBC programming book.
You can use JDBC with SAP Sybase IQ in the following ways:
- JDBC on the client – Java client applications can make JDBC calls to SAP Sybase IQ. The
connection takes place through a JDBC driver.
SAP Sybase IQ includes a JDBC 4.0 driver, which is a Type 2 JDBC driver, 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
- Example source code – You can find source code for the examples in this section in the directory %ALLUSERSPROFILE%\SybaseIQ\samples\SQLAnywhere\JDBC.
- JDBC Specification – You can find more information about the JDBC Data Access API at http://www.oracle.com/technetwork/java/javase/tech/index-jsp-136101.html.
- Required software – You need TCP/IP to use the jConnect driver.
The jConnect driver is available at http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect.