iPlanet Application Server includes several samples that demonstrate how J2EE components use JDBC to interact with a database. The samples mentioned in this section are targeted towards understanding specific interactions between iPlanet Application Server and databases.
HelloDB is a simple application based on HTML, Servlets, EJBs, and JSPs. The motivation for HelloDB was the need to have a little test application that could be deployed quickly to test database connectivity.
SQLRunner provides a web-based interface for executing Standard Query Language (SQL) statements on a relational database. It is useful for developers who want to test SQL statements before using them in Java programs. It is also useful for people who simply want to access a database through the web, instead of having to install proprietary database client software. The SQL Runner can process any SQL statement that is supported by the underlying database server and JDBC driver.
BLOB provides a web-based interface to an object repository in a database.The sample provides a front end to manage files in a database which are stored as BLOBs (Binary Large OBjects).
Transaction samples demonstrate both local and distributed transaction management features of iPlanet Application Server.
Bank provides a web-based interface to a basic online banking service. Bank customer service representatives are able to add new customers and remove existing customers from the bank's database as well as from the directory server. All customer and account information is stored in a relational database.
Java Petstore is the Sun J2EE sample application that demonstrates many facets of the J2EE specification. All catalog data and account information is stored in a relational database.
Sun J2EE Developer Guide samples contain several samples that access relational databases.
Copyright
(c) 2001 Sun Microsystems, Inc. All rights reserved.