EJB 2.0 Development with WebSphere Studio Application Developer

Developing a BMP entity bean

In this section, we develop a CustomerInfoBmp bean to illustrate the use of BMP.

The CustomerInfoBmp bean represents additional information for a customer of the bank. For each kind of additional information, we create a row in a CUSTOMERINFO table. Additional information could be a photo for printing on the credit card or a scanned image for the identification card.

Underlying table for customer information

Table 13-1 shows the layout of the CUSTOMERINFO table.

Table 13-1. Customer information table

Column name	Type	Length	Key	Nulls	Description
CUSTOMERID	INTEGER		PK	No	Customer ID
INFOID	INTEGER		PK	No	Information ID (1,2,...)
DESCRIPTION	VARCHAR	50	No	Yes	Description of information
DATA	BLOB	10000	No	Yes	Binary data

This design allows for ...