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
Documentation Introduction: Data access resources Presentations IBM Education Assistant offers:
- Adding security for JDBC and J2C resources
- 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
- 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.
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.
WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.
IBM is a trademark of the IBM Corporation in the United States, other countries, or both.