|Skip Navigation Links|
|Exit Print View|
|Oracle Java CAPS Adapter for Oracle Tutorials Java CAPS Documentation|
The data used for both the Java Collaboration Definition-based and Business Process Manager sample projects are contained within a table called db_employee. You create this table by running the SQL statement Oracle_Sample_script.sql, that is included in the sample Project. Note that you must use a database tool to run the script.
The SQL statement designed for the sample projects, is as follows:
drop table db_employee go create table db_employee ( EMP_NO int, LAST_NAME varchar(30), FIRST_NAME varchar(30), RATE float, LAST_UPDATE datetime) go
The sample Projects provided with the Oracle Java CAPS Adapter for Oracle use input files to pass predefined data or conditions into the Collaboration or Business Process, which then transform the database contents, and deliver the ResultSet.