Creating new EJB in IBM WCS

NOTE: If you want your table to be used in stagprop, Make sure table name doesnot exceed 18 CHAR length.

Creating new EJB :

Create Table:

1.       Do physical mapping in RAD : Go to WebSphereCommerceServerExtensionsData > Data Models > WCDEV.dbm à Select DB2ADMIN schema. Rename it to NULLID

2.       Right-click NULLID > Add Data Object > Table.

3.       Create ur table. Right click on table and generate DDL. This ddl you can use to create table in DB.

4.       Create the XOrderItemsBundles entity bean

4.1 In the Enterprise Explorer view, expand WebSphereCommerceServerExtensionsData.

4.2 Right-click Deployment Descriptor: WebSphereCommerceServerExtensionsData; select New > Enterprise Bean

4.3 In the Create and Enterprise Bean window:

4.4 Select Entity bean with container-managed persistence (CMP) fields

In the Source folder field, leave the default value, ejbModule.

In the Default package field, enter com.ibm.commerce.extension.objects.

From the CMP Version list, select 1.x.

Click Next.

5.       In the Enterprise Bean Details window, add new CMP attributes for the OrederId,OrderItemsID etc.

5.1 Select the default CMP attribute id:java.lang.Integer and click Remove.

Click Add.

5.2 In the Name field, enter OrederId.

5.3 In the Type field, enter java.lang.Long.

Note : You must use the java.lang.Long data type, not the long data type, since the column OrederId that you are trying to map to is BIGINT or NUMBER.

Select the Key Field check box to indicate that this field is the primary key of the database table.

Click Apply.

Same way for other field.

You must use the java.lang.Integer data type, not the integer data type.

Ensure the Access with getter and setter methods check box is selected. By selecting this option all getter and setter methods will be automatically generated for all fields.

Clear the Access with getter and setter methods check box.

Click Apply then Close to close this window.

Ensure the Use the single key attribute type for the key class check box is not selected, then click Next. Ensuring this check box is not selected ensures that a key class is created, ensuring consistency with other beans.

In the EJB Java Class Details window, create the entity bean called Bonus:

To select the bean's superclass, click Browse.

In the Type Selection window, in the Select a class using: (any) field, enter ECEntityBean and click OK.

Specify the interfaces that the remote interface should extend by clicking Add.

In the Type Selection window, in the Select an interface using: (any) field, enter Protectable and click OK to select com.ibm.commerce.security.Protectable. This interface is required in order to protect the new resource under access control.

Click Next.

Deselect Add bean to Class Diagram.

Click Finish.

Setting EJB properties : Set the EJB isolation level

WebSphereCommerceServerExtensionsData > Deployment Descriptor > Entity Beans

1. Right-click On your bean and open the bean in its deployment descriptor.
2. Click the Access tab.
3. Next to the Isolation Level text box, click Add.
4. In the Add Isolation Level window, select Read committed, then click Next.
5. From the Beans found list, select the Bonus bean, then click Next.
6. From the Methods found list, select Bonus to select all of its methods, and click Finish.
7. Save your changes and keep the editor open

Set the security identity of the bean:

Ø  Select the Access tab selected.

Ø  In the Security Identity (Method Level) section, click Add.

Ø  Select Use identity of EJB server, then click Next. The Use identity of EJB server field ensures that all EJB beans run under the same identity for security.

Ø  From the Beans found list, select the your bean, then click Next.

Ø  From the Methods found list, select your bean to select all of its methods, and click Finish.

Ø  Save your changes and keep the editor open.

Remove the unused generated fields and methods. The ECEntityBean base class provides its own implementation of these methods:

In the Java EE view, expand WebSphereCommerceServerExtensionsData > Entity Beans > XOrderItemsBundlesBean

Open the XOrderItemsBundlesBeanclass for editing

Ø  In the Outline view removed the unused fields:

Ø  Select the myEntityCtx field and from its pop-up menu, select Delete.

Ø  Select the getEntityContext() method and from its pop-up menu, select Delete.

Ø  Select the setEntityContext(EntityContext) method and from its pop-up menu, select Delete.

Ø  Select the unsetEntityContext() method and from its pop-up menu, select Delete.

Add getter method for all primary key fields.

You can generate this method without having to type the source. Right-click the catalogId property in the Outline view, and select Source > Generate Getter and Setters. Select only the getOrderItemId()

method

In the Outline view, right-click the getOrderItemId method and select Enterprise Bean (1.x-2.x) > Promote to Remote Interface

Add Ejb finder :

1. In the EJB Deployment Descriptor editor, click the Bean tab.
2. In the Beans pane, select the XOrderItemsBundles bean.
3. Click Add next to the Finders text box, as in the following screen capture:

Add ejbCreate and ejbPostCreate methods :

/**

                 * ejbCreate method for a CMP entity bean.

                 */

                public com.XYZ.commerce.bundleorder.XOrderItemsBundlesKey ejbCreate(

                                java.lang.Long orderItemsId,

                                java.lang.Long bundleCatentryId,

                                java.lang.Long ordersId,

                                java.lang.Long catentryId,

                                java.lang.String slot,

                                java.lang.String field1,

                                java.lang.String field2,

                                java.lang.Integer field3) throws javax.ejb.CreateException {

                                this.initializeFields();

                                _initLinks();

                                this.orderItemsId = orderItemsId;

                                this.bundleCatentryId = bundleCatentryId;

                                this.ordersId = ordersId;

                                this.catentryId= catentryId;

                                this.slot = slot;

                                this.field1 = field1;

                                this.field2 = field2;

                                this.field3 = field3;

                                XOrderItemsBundlesKey bunKey = new XOrderItemsBundlesKey(orderItemsId,bundleCatentryId);

                                this.initializeOptCounter(bunKey);

                                return null;

                }

                /**

                 * ejbPostCreate

                 */

                public void ejbPostCreate(

                                java.lang.Long orderItemsId,

                                java.lang.Long bundleCatentryId,

                                java.lang.Long ordersId,

                                java.lang.Long catentryId,

                                java.lang.String slot,

                                java.lang.String field1,

                                java.lang.String field2,

                                java.lang.Integer field3) throws javax.ejb.CreateException {

                }

In the Outline view, right-click the ejbCreate(Long, Integer, Short, Integer, String) method you just created and select Enterprise Bean (1.x-2.x) >Promote to Home Interface

getOwner And fulfills method is not necessary till you have foreign key to any table.

Create getter method for all primary key and in outline right click on getter method  select Enterprise Bean > Promote to Remote Interface. Once this is complete, a small R icon displays next to the method, indicating that it has been promoted to the remote interface.

Map the database table to the EJB :

In the Java EE perspective Enterprise Explorer view, right-click WebSphereCommerceServerExtensionsData and select Java EE > EJB to RDB Mapping (1.x-2.x) > Generate Map

Click finish. If you have preexisting folder :

In overview section by clicking all column you should get field mapped.

Make the bean portable and enable optimistic locking

Enable optimistic locking. Open the deployment descriptor under WebSphereCommerceServerExtensionsData

In the Enterprise Explorer view, navigate to WebSphereCommerceServerExtensionsData > Deployment Descriptor.

Ø  Open the deployment descriptor for editing.

Ø  In the Bean tab, select the your bean.

Ø  In the lower right pane, scroll down to the Concurrency Control section.

Ø  Select Enable optimistic locking.

Ø  Save your changes.

Edit methods to call optimistic locking classes. In the XOrderItemsBundle class make the following changes:

Ø  In the Outline view, select ejbLoad() and add the following code as the first line in the method: super.ejbLoad();

Ø  In the Outline view, select ejbStore() and add the following code as the first line in the method: super.ejbStore();

Ø  In the Outline view, select ejbCreate(Long, Integer) and add the following code:

Ø  Add this.initializeFields(); as the first line in the method.

Ø  Add the following two lines to the method before the return statement

XOrderItemsBundlesKey bunKey = new XOrderItemsBundlesKey(orderItemsId,bundleCatentryId);

            this.initializeOptCounter(bunKey);

Ø  Save your changes.

Generate the Access Bean for the EJB

In the Java EE perspective Enterprise Explorer view, right-click WebSphereCommerceServerExtensionsData . Select New > Other. In the list of options, expand EJB

and select Access Bean. Select Next.

On the Select an Access Bean Type page, select Copy helper . Select Next

On the Select EJB Project page, select XOrderItemsBundles bean.

Select Next.

 On the Copy Helper Access Bean page, for the Constructor method, select

findByPrimaryKey(com.ibm.commerce.extension.helpers.XPaperCatalog).

Select Finish.

Right-click WebSphereCommerceServerExtensionsData. Select Java EE >Prepare for Deployment

Save all file.