Part B source shows how you can use the JDBC BC to update Java DB from
the BPEL process.
First, we will create the DB for SouthAir. While you can use any DB, this example
shows how you can use Java DB that is well integrated with the NetBeans IDE. From
the IDE, select Tools | Java Database | Create Database. Enter SouthAirDB as the
Database Name and provide User Name and Password.
If you are using the DB provided in the source code folder, set the correct
path to the DB in Database Location field.
Building a Sample Application
[ 232 ]
After creating the database, connect to the database by right-clicking on the
Databases under the Services tab and selecting Connect as shown in the figure:
Now that our database is ready, right-click on Tables and select Create Table. The
following figure shows the SouthAir database structure. This is just an example
database structure. Real databases may not look like this.
We will have some fields that match with the itinerary information that NorthAir
Web Service expects.
Now SouthAirDB is ready with one table called Itinerary that the Reservation BPEL
process updates. Unfortunately, SouthAir does not have a Web Service for our
business process to interact with. So, we will create a web service that can perform
the CRUD operation on SouthAir DB whenever a reservation request is made.
Pages:
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207