The DB2 sample Project contains several Adapters, each represented in the Connectivity Maps as a node between an External Application and a Service. The Adapters facilitate the communication and movement of data between external applications and the Sun Enterprise Service Bus system. These Adapters must be configured for your system.
Adapter properties must be configured in both the Connectivity Maps and the Environment.
Connectivity Map properties are configured from each of the Connectivity Maps. These properties are specific to each of the configured Adapters, unlike the Environment properties which contain common properties for each Adapter type.
Open a Connectivity Map, and double-click the adapter to open the Properties Editor to that adapter's property sheet. For example, open the cmDelete Connectivity Map and double-click the inbound File Adapter (the node between the File1 External Application and the cmDelete_jcdDelete1 service).
The Properties Editor open to the selected Adapter's property sheet.
From the Properties Editor, edit the values of the appropriate properties for your system.
Once you are done editing the property values for that Adapter, click OK to save the current properties.
Repeat this procedure to edit all of your Connectivity Map properties.
Enter the following values for the File1 Adapters.
Connectivity Map |
Property Name |
Required Value |
---|---|---|
cmDelete |
Input file name |
TriggerDelete.in |
cmInsert |
Input file name |
TriggerBpInsert.in |
cmPsSelect |
Input file name |
TriggerPsSelect.in |
cmTableSelect |
Input file name |
TriggerTableSelect.in |
cmUpdate |
Input file name |
TriggerUpdate.in |
Enter the following values for the outbound File2 Adapters.
Connectivity Map |
Property Name |
Required Value |
---|---|---|
cmDelete |
Output file name |
JCD_Delete_output%d.dat (for JCD Sample) |
BPEL_Delete_output%d.dat (for BPEL Sample) |
||
cmInsert |
Output file name |
JCD_Insert_output%d.dat (for JCD Sample) |
BPEL_Insert_output%d.dat (for BPEL Sample) |
||
cmPsSelect |
Output file name |
JCD_PsSelect_output%d.dat (JCD Sample) |
BPEL_PsSelect_output%d.dat (for BPEL Sample) |
||
cmTableSelect |
Output file name |
JCD_TableSelect_output%d.dat.in (for JCD Sample) |
BPEL_TableSelect_output%d.dat.in (for BPEL Sample) |
||
cmUpdate |
Output file name |
JCD_Update_output%d.dat (for JCD Sample) |
BPEL_Update_output%d.dat (for BPEL Sample) |
When you double-click the DB21 Outbound Adapter, the Adapter Connections dialog box appears. Choose an Adapter connection for your project (for this sample select Outbound DB2 Adapter). When the Properties Editor for the DB21 Outbound Adapter opens, click OK to save the default settings.
Environment properties are configured from the Services tree of the NetBeans IDE Services window.
From the Services tree in the NetBeans IDE Services window, expand the CAPS Environments -> envDB2Proj nodes
Double-click an Adapter to open the Properties Editor to the Adapter's Environment properties sheet.
Edit the property values for your system. Once you are done, click OK to save the current properties.
Repeat this procedure to edit all of your Environment properties.
Enter the following values for the File Adapters.
Enter the following values for the outbound DB2 Adapters.
Section |
Property Name |
Required Value |
---|---|---|
Configuration -> Outbound DB2 Adapter -> JDBC Connector settings. |
PortNumber |
Enter the port number where the server is listening for requests. |
ServerName |
Enter the host name of the database server being used. |
|
DatabaseName |
Enter the name of the particular database that is being used on the server. |
|
User |
Enter the user account name for the database. |
|
Password |
Enter the user account password for the database. |
|
For your next step, see Creating the Deployment Profile.