test

Sun Adapter for Oracle Tutorials

Configuring the Adapter Properties

The Oracle 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.

Configuring the Connectivity Map Properties

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.

ProcedureConfigure the Connectivity Map Properties

  1. 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.

  2. From the Properties Editor, edit the values of the appropriate properties for your system.

  3. Once you are done editing the property values for that Adapter, click OK to save the current properties.

  4. Repeat this procedure to edit all of your Connectivity Map properties.

File1 Inbound Adapter 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 

File2 Outbound Adapter Properties

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) 

Oracle1 Outbound Adapter Properties

When you double-click the Oracle1 Outbound Adapter, the Adapter Connections dialog box appears. Choose an Adapter connection for your project (for this sample select Outbound Oracle Adapter). When the Properties Editor for the Oracle1 Outbound Adapter opens, click OK to save the default settings.

Configuring the Environment Properties

Environment properties are configured from the Services tree of the NetBeans IDE Services window.

ProcedureConfigure the Environment Properties

  1. From the Services tree in the NetBeans IDE Services window, expand the CAPS Environments -> envOracleProj nodes

  2. Double-click an Adapter to open the Properties Editor to the Adapter's Environment properties sheet.

  3. Edit the property values for your system. Once you are done, click OK to save the current properties.

  4. Repeat this procedure to edit all of your Environment properties.

File Adapter Environment Properties

Enter the following values for the File Adapters.

Section 

Property Name 

Required Value 

Configuration -> Inbound File Adapter -> Parameter Settings 

Directory 

Enter the directory that contains the input files (trigger files included in the sample Project). 

Trigger files:

  • TriggerDelete.in.~in

  • TriggerInsert.in.~in

  • TriggerPsSelect.in.~in

  • TriggerTableSelect.in.~in

  • TriggerUpdate.in.~in

Configuration -> Outbound File Adapter -> Parameter Settings 

Directory 

Enter the directory where output files are written. 

For the JCD sample Project, the output files are:

  • JCD_Delete_output0.dat

  • JCD_Insert_output0.dat

  • JCD_PsSelect_output0.dat

  • JCD_TableSelect_output0.dat

  • JCD_Update_output0.dat

For the BPEL sample Project, the output files are:

  • BPEL_Delete_output0.dat

  • BPEL_Insert_output0.dat

  • BPEL_PsSelect_output0.da

  • BPEL_TableSelect_output0.dat

  • BPEL_Update_output0.dat
 
 
 
 

Oracle Adapter Environment Properties

Enter the following values for the outbound Oracle Adapters.

Section 

Property Name 

Required Value 

Configuration -> Outbound Oracle Adapter -> JDBC Connector settings. 

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. 
 

What's the Next Step?

For your next step, see Creating the Deployment Profile.