About the Sun Adapter for DB2 Sample Projects

Topics covered in this section include:

• Sample Input Trigger Files and Output Files

• Sample Project Data

• Operations Used in the DB2 Sample Projects

The Sun Adapter for DB2 Sample Project Zip file contains two sample Projects, one that is Java Collaboration Definition (JCD)-based, and one that uses the Sun Business Process Manager (BPM).

Both the prjDB2_JCD and prjDB2_BPEL sample projects demonstrate how to:

• Select employee records from a database using a prepared statement.

• Select employee records from the db_employee table.

• Insert employee records into the db_employee table.

• Update an employee record in the db_employee table.

• Delete an employee record from the db_employee table.

Sample Input Trigger Files and Output Files

In addition to the sample projects, the DB2.zip file also includes six sample input trigger files and ten sample output files

Sample input files

• TriggerInsert.in.~in (for JCD projects only)

• TriggerBpInsert.in.~in (for BPM projects only)

• TriggerDelete.in.~in

• TriggerUpdate.in.~in

• TriggerPsSelect.in.~in

• TriggerTableSelect.in.~in

Sample output JCD files

• JCD_Insert_output().dat

• JCD_Delete_output().dat

• JCD_Update_output().dat

• JCD_PsSelect_output().dat

• JCD_TableSelect_output().dat

Sample output BPM files

• BPEL_Insert_output().dat

• BPEL_Delete_output().dat

• BPEL_Update_output().dat

• BPEL_TableSelect_output().dat

• BPEL_PsSelect_output().dat

Sample Project Data

Data used for the sample projects are contained within a table called db_employee. The table has three columns, as follows:

Table 1 Sample Project Data - db_employee Table

Column Name	Data Type	Data Length
emp_no	INTEGER	10
last_name	VARCHAR	30
first_name	VARCHAR	30
rate	FLOAT	15
last_update	TIMESTAMP	19

---

Note –

DB2 databases do not accept table data with columns that include Boolean data types. For example, an DB2 server expects a literal “T” or “F” for True or False Boolean values, and does not accept Java primitive Boolean True or False values.

---

Operations Used in the DB2 Sample Projects

The following database operations are used in both the Java Collaboration Definition-based and Business Process Manager sample projects:

• Delete

• Insert

• Select Table

• Select Prepared Statement

• Update