Skip Navigation Links | |
Exit Print View | |
Oracle Java CAPS Adapter for SQL Server Tutorials Java CAPS Documentation |
About the Adapter for SQL Server Sample Projects
Sample Input Trigger Files and Output Files
Operations Used in the SQL Server Sample Projects
About the Java CAPS Business Process Manager Project
Associating Business Process Manager Operators
Deploying JCD- Based Operations in the Business Process Manager
About the Java Collaboration Definition Sample Project
Creating the Java Collaboration Definition Project for the Java CAPS Adapter for SQL Server
Create the SQL Server Database OTD
Create the Inbound and Outbound DTD OTDs
Creating the Collaboration Definitions (Java)
Create the jcdDelete Collaboration Definition
Using the Java Collaboration Editor to Create Business Rules
Creating the Business Rules for the jcdDelete Collaboration
Create the jcdDelete Collaboration Business Rules
jcdDelete Collaboration Java Code
Creating the Business Rules for the jcdInsert Collaboration
Create the jcdInsert Collaboration Business Rules
jcdInsert Collaboration Java Code
Creating the Business Rules for the jcdPsSelect Collaboration
Using the Collaboration Editor's Java Source Editor
Create the jcdPsSelect Collaboration Business Rules
Creating the Business Rules for the jcdTableSelect Collaboration
Create the jcdTableSelect Collaboration Business Rules
jcdTableSelect Collaboration Java Code
Creating the Business Rules for the jcdUpdate Collaboration
Create the jcdUpdate Collaboration Business Rules
jcdUpdate Collaboration Java Code
Creating the Connectivity Maps
Adding Connectivity Maps to a Project
Add the Connectivity Maps to the Project
Populating and Binding the Connectivity Maps Using the Connectivity Map Generator
Populate the Connectivity Maps Using the Connectivity Map Generator.
Configuring the Adapter Properties
Configuring the Connectivity Map Properties
Configure the Connectivity Map Properties
File1 Inbound Adapter Properties
File2 Outbound Adapter Properties
SQL1 Outbound Adapter Properties
Configuring the Environment Properties
Configure the Environment Properties
File Adapter Environment Properties
SQL Server Adapter Environment Properties
Creating the Deployment Profile
Building and Deploying the Project
Deploying the Project from NetBeans
Creating the BPEL-Based Project for the Adapter for SQL Server
Creating the Business Processes
Create the bpDelete Business Process
Create the bpInsert Business Process
Create the bpPsSelect Business Process
Create the bpTableSelect Business Process
Create the bpUpdate Business Process
Using Business Process Designer to Create Business Rules
Creating the bpDelete Business Rules
Create the bpDelete Business Rules
Creating the bpInsert Business Rules
Create the bpInsert Business Rules
Creating the bpPsSelect Business Rules
Create the bpPsSelect Business Rules
Creating the bpTableSelect Business Rules
Create the bpTableSelect Business Rules
The Java CAPS Adapter for SQL Server handles the communication details necessary to send and receive data between the Java CAPS environment and a Microsoft SQL Server Database. The Adapter can apply business logic defined within the collaboration rules or business processes to perform data identification, manipulation, and transformation operations.
The Java CAPS Adapter for SQL Server Tutorial provides two sample projects:
prjSQLServer_BPEL Sample Project: Demonstrates how to create a Java CAPS Business Process Manager project that uses the SQL Server Adapter. The prjSQLServer_BPEL sample project uses input files to pass data into a business process. There are four business processes that demonstrate the Insert, Update, Delete, and Select operations, and one process to demonstrate a Prepared Statement. Results are written out to an output file.
prjSQLServer_JCD Sample Project: Demonstrates how to create a Java Collaboration Definition (JCD) project that uses the SQL Server Adapter. The prjSQLServer_JCD sample project uses input files to pass data into Collaborations. There are four Collaborations that demonstrate the Insert, Update, Delete, and Table Select operations, and one Collaboration to demonstrate a Prepared Statement. Results are written out to an output file.
It is assumed that you are already familiar with Java CAPS terminology and concepts.
Note - You can download the Sample Project files from http://java.net/projects/javacaps-samples/pages/Home.
What You Need to Know
The following topics contain introductory and conceptual information for the Java CAPS Adapter for SQL Server Tutorial.
What You Need to Do
The following topics contain the step-by-step instructions for importing and building the Adapter for SQL Server sample projects.
What You Need to Do for the Java Collaboration Definition Project
The following topics contain the step-by-step instructions for importing and building the Adapter for SQL Server Java Collaboration Definition Project (JCD) sample project.
Creating the Java Collaboration Definition Project for the Java CAPS Adapter for SQL Server
What You Need to Do for the BPEL Project
The following topics contain the step-by-step instructions for importing and building the Adapter for SQL Server BPEL Project sample project.