data access resources

 

How do I?...

	Establish data access using enterprise beans
	Develop enterprise beans
	Assemble beans into a data access application
	Map the beans to database tables
	Configure access to a relational database
	Configure access to a non-relational database
	Create a resource adapter
	Create a connection factory
	Establish data access without using enterprise beans
	Use optional IBM data access beans
	Verify your database vendor requirements (for relational databases)
	Configure access to a relational database
	Configure access to a database
	Set up JDBC - Cloudscape database
	Set up JDBC - DB2 database
	Set up JDBC - Oracle database
	Establish data access using SDO
	The Service Data Objects framework
	Logically name the new resource
	Establish resource references
	Deploy your data access application
	Install application files (same as any application type)
	Deploy applications (IBM Education Assistant)
	Administer applications (IBM Education Assistant)
	Test and monitor database connections
	Test connections
	Remedy stale connections
	Use the JDBC connection pool counter for relational databases
	Use the J2C connection pool counter for non-relational databases
	Troubleshoot
	Resolve connectivity issues specific to database type

 

Conceptual overviews

Documentation	Introduction: Data access resources
Presentations	IBM Education Assistant offers: Adding security for JDBC and J2C resources JDBC JavaServer Faces Overview JavaServer Faces Architecture Service Data Objects Overview JDBC mediator EJB mediator
	See also the IBM Redbook DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide

 

Tutorials

developerWorks offers: Tutorial 5 - Java Connector Architecture (JCA 1.5) This tutorial illustrates the Java Connector Architecture (JCA), which defines the standards that allow J2EE application servers to interact with a back-end. This is called an Enterprise Information System (EIS). With JCA 1.5, it is possible for a back-end system to initiate communications towards the J2EE application server, and to propagate a transactional context too. The EIS will control the transaction boundaries in this scenario, the J2EE container acts as a transactional resource controlled by the EIS. The zip file comes with all sample code required to run this tutorial.

 

Samples

The Samples Gallery offers: WebSphere Bank Using the WebSphere Bank online bank, customers can open accounts, get account balances, and transfer funds between accounts. The WebSphere Bank application uses Web services, Java Message Service (JMS) API, container-managed persistence (CMP), container-managed relationships (CMR), stateless session beans, Message Driven Beans (MDB), JCA 1.5 API, JSP pages, and servlets. Album catalog Album Catalog illustrates access to relational data in a web application via Service Data Objects (SDO) and JDBC Mediator. It illustrates the use of SDOs and JDBC Mediator to display and manipulate data from a relational database in a disconnected fashion.

 

---