JDBC provides a SQL interface for Java applications: if you want to access relational data from Java, you do so using 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. As well, this appendix 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:
JDBC on the client 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.
Required software You need TCP/IP to use the Sybase jConnect driver.
The Sybase jConnect driver may already be available, depending on your installation of Sybase IQ.
For more information about the jConnect driver and its location, see “The jConnect driver files”.
