Creating the database table

You can use the Data perspective to define databases, schemas, and tables. We could define the CUSTOMERINFO table from scratch. However, it is easier to use the skeleton definitions that the deployment step generated.

Open the Data perspective and expand the ItsoBank5BmpEJB project in the Data Definition view (Figure 13-15).

Figure 13-15. Data definition created by top-down mapping

Open the NULLID.CUSTOMERINFOCMP table. On the Columns page:

  • Change the length of the DESCRIPTION column to 50

  • Change the data type of the DATA column to BLOB

  • Change the length of the DATA column to 10 (leave the LOB multiplier as K, so ...

Get EJB 2.0 Development with WebSphere Studio Application Developer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.