To define the DB adapter:

1. From the Eclipse menu, select Window, Show View, and then Other.
   The Show View dialog box appears.
   
2. Select HCSC-Definer and then HCSCTE View, and click OK.
   The Service Definition List appears in the tree view.
   
3. Right-click the Service Definition List in the tree view, and select Add Service Adapter.
   The Service adapter definition addition wizard appears.
   
4. From the Service component type: drop-down list, select DB adapter.
5. Click Next.
   The Service adapter definition addition (DB Adapter) wizard appears.
   
6. Enter the service name.
   Enter CSAFF_SAMPLE_DB as the service name.
   
7. Click Finish.
   The necessary files are created, and stored in the repository. The Service adapter definition (standard) window appears.
   
8. Enter settings in the Service adapter definition (standard) and Service adapter definition (details) windows.
   See DB adapter settings below for information about the settings.
   
9. Review the definition contents, and then save them by selecting File and then Save from the Eclipse menu.
10. Verify the DB adapter settings.
    Select Verify from the pop-up list displayed when you right-click the Service Definition List in the tree view. The results of the verification process appear in the Console View.
    

DB adapter settings

The table below shows the items you need to set in the Service adapter definition (standard) window when defining the DB adapter for sample business processes. You do not need to set items that do not appear in this table.

Table D-2 Settings in Service adapter definition (standard) window (DB adapter)

Category	Item		Value to set	Requires setting
Service component control information	Service name		CSAFF_SAMPLE_DB	Y
	Service ID		CSAFF_DB	Y
	Service type		DB adapter	N
	Maximum instances		0	Y
	Operation		CSAFF_SAMPLE_DB	Y
Operation information	Operation name		CSAFF_SAMPLE_DB	N
	Communication model		Sync	Y
Request message	Standard	Use check box	Do not use (leave the check box cleared)	Y
	Service component	Format ID	SAMPLE_DB_Request	Y
		Message format	csaff_sample_sqlformat.xsd	Y
Response message	Standard	Use check box	Do not use (leave the check box cleared)	Y
	Service component	Format ID	SAMPLE_DB_Response	Y
		Message format	csaff_sample_sqlformat.xsd	Y

Legend:

Y: Must be set.

N: Check the content that is already displayed.

The table below shows the items you need to set in the Service adapter definition (details) window when defining the DB adapter for sample business processes. You do not need to set items that do not appear in this table.

Table D-3 Settings in Service adapter definition (details) window (DB adapter)

Category	Item	Value to set	Requires setting
Service adapter control information	Service adapter (EJB-JAR file)	cscdba_ejb.jar	N
	Self-defined file	csa_sql_csaff_sample.xml	Y
		cscadapter_property.xml	N

Legend:

Y: Must be set.

N: Check the content that is already displayed.

Deploy the DB adapter you defined to the server and start the DB adapter.

To deploy the DB adapter definition:

1. Right-click the Service Definition List in the tree view, and select Deploy all services to server and start.
   If the DB adapter fails to start, a dialog box appears describing the nature of the error. Look up the message ID displayed in the error details and take the appropriate action.
   
   If you are not logged in, the Account Verification window appears. In this case, perform step 2.
   
2. Enter admin in the User ID field and the Password field, and then click OK.
   A message indicating that account verification is in progress appears, followed by a message indicating whether verification was successful.