Sun Microsystems eWay JDBC/ODBC Adapter - Manual (Page 96)

Chapter 6 Section 6.6
Implementing the JDBC/ODBC eWay Sample Projects Building and Deploying the prjJDBC_BPEL Sample Project
JDBC/ODBC eWay Adapter User’s Guide 96 Sun Microsystems, Inc.
2 From the Project Explorer tree, right-click the Repository and select New Project. A
new Project (Project1) appears on the Project Explorer tree.
3 Right-click Project1 and select Rename from the shortcut menu. Rename the Project
(for this sample, prjJDBC_BPEL).
6.6.2
Creating the OTDs
The sample Project requires three OTDs to interact with the JDBC eWay. These OTDs
include:
ƒ JDBC Database OTD
ƒ Inbound DTD OTD
ƒ Outbound DTD OTD
Steps required to create a JDBC Database OTD include:
1 Right-click your new Project in the Enterprise Designer’s Project Explorer, and
select New > Object Type Definition.
The New Object Type Definition Wizard window appears.
2 Select the JDBC Database OTD Wizard from the list of OTD Wizards and click
Next
.
3 Enter the connection information for the JDBC database. Connection fields include:
Š Driver Jar Files
Š Driver Java Class Name
Š URL Connection String
Š User name
Š Password
4 Click Next, and select the types of database object you want to include in the
sample Project. For this example, select the following:
Š Tables/Views/Aliases
Š Prepared Statements
5 Click Add to select tables from the JDBC database. The Add Tables window
appears.
6 Search for or type in the name of the database. In this example we use the
DB_EMPLOYEE
table. Click Select when the database appears in the Results
selection frame. Click OK to close the Add Tables window
7 Click Next the Add Prepared Statements Wizard appears.
8 Click Add, the Add Prepared Statement window appears. Enter the following:
Š Prepared Statement Name: Select_ps
Š SQL Statement:
select * from db_employee where emp_no > ? order by emp_no