Topics covered in this section include:
The Sun Adapter for Oracle 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 prjOracle_JCD and prjOracle_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.
In addition to the sample projects, the Oracle.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
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 |
Oracle databases do not accept table data with columns that include Boolean data types. For example, an Oracle server expects a literal “T” or “F” for True or False Boolean values, and does not accept Java primitive Boolean True or False values.
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