JDBC provides a SQL interface for Java applications: if you want to access relational data from Java, use JDBC calls.
Rather than a thorough guide to the JDBC database interface, this appendix provides some simple examples to introduce JDBC and illustrates how you can use it inside and outside the server. This appendix also provides more details on the server-side use of JDBC, running inside the database server.
The examples illustrate the distinctive features of using JDBC in Sybase IQ. For more information about JDBC programming, see any JDBC programming book.
You can use JDBC with Sybase IQ in the following ways:
Java client applications can make JDBC calls to Sybase IQ. The connection takes place through the Sybase jConnect JDBC driver or through the iAnywhere JDBC driver.
In this appendix, the phrase client application applies both to applications running on a user's machine and to logic running on a middle-tier application server.
JDBC in the server Java classes installed into a database can make JDBC calls to access and modify data in the database, using an internal JDBC driver.
The focus in this appendix is on server-side JDBC.