![]() |
JDBC Applications and the Cloudscape Technology
|
Reference Manual |
Application Development OverviewCloudscape application developers use JDBC, the application programming interface that makes it possible to access relational databases from Java programs. The JDBC API is part of the JDK and is not specific to, or provided by, Cloudscape. It consists of the java.sql package, which is a set of classes and interfaces that make it possible to access databases (from a number of different vendors, not just Cloudscape) from a Java application. To develop Cloudscape applications successfully, you will need to learn JDBC. This chapter does not teach you how to program with the JDBC API; JDBC programming is not specific to Cloudscape. Sun offers a tutorial for learning the JDBC interface, JDBC Database Access with Java, Hamilton, Cattell, and Fisher, Addison-Wesley, 1997. This chapter covers the details of application programming that are specific to Cloudscape applications. For example, all JDBC applications typically start their DBMS's JDBC driver and use a database connection URL to connect to a database. This chapter gives you the details of how to start Cloudscape's JDBC driver and how to work with Cloudscape's database connection URL to accomplish various tasks. It also covers essential Cloudscape concepts such as the Cloudscape system. You will find reference information about the particulars of Cloudscape's implementation of JDBC in the Cloudscape Reference Manual. In addition, Learning Cloudscape: The Tutorial walks you through some of the JDBC basics:
Cloudscape application developers should also learn SQL. SQL is the standard query language used with relational databases and is not tied to a particular programming language. (When it was originally created, SQL stood for structured query language, but it does not stand for anything nowadays.) No matter how a particular RDBMS has been implemented, the user can design databases and insert, modify, and retrieve data using the standard SQL statements and well-defined data types. SQL-92 is the version of SQL standardized by ANSI and ISO in 1992; Cloudscape supports entry-level SQL-92 as well as some higher-level features. Entry-level SQL-92 is a subset of full SQL-92 specified by ANSI and ISO that is supported by nearly all major DBMSs today. This chapter does not teach you SQL. You will find reference information about the particulars of Cloudscape's implementation of SQL in the Cloudscape Reference Manual. In addition, Learning Cloudscape: The Tutorial walks you through some SQL basics. Cloudscape also implements a subset of the JDBC2.0 extensions and the Java Transaction API. This implementation allows Cloudscape to serve as a resource manager in a J2EE-compliant system. For information, see the Cloudscape Reference Manual. Cloudscape extends the power of SQL with Java. This topic is worth an entire chapter, so you will find information about Cloudscape's Java extensions to SQL in Chapter 4, "Using Cloudscape's Java Extensions", in this book. You may also want to look at the recommendations for further reading listed in Further Reading in Using the Cloudscape Documentation. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |