Sun Microsystems JDBC/ODBC Adapter manual Creating the OTDs

Chapter 6	Section 6.6
Implementing the JDBC/ODBC eWay Sample Projects	Building and Deploying the prjJDBC_BPEL Sample Project

2From the Project Explorer tree, right-click the Repository and select New Project. A new Project (Project1) appears on the Project Explorer tree.

3Right-click Project1 and select Rename from the shortcut menu. Rename the Project (for this sample, prjJDBC_BPEL).

6.6.2Creating 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:

1Right-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.

2Select the JDBC Database OTD Wizard from the list of OTD Wizards and click Next.

3Enter the connection information for the JDBC database. Connection fields include:

ŠDriver Jar Files

ŠDriver Java Class Name

ŠURL Connection String

ŠUser name

ŠPassword

4Click 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

5Click Add to select tables from the JDBC database. The Add Tables window appears.

6Search 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

7Click Next the Add Prepared Statements Wizard appears.

8Click 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

JDBC/ODBC eWay Adapter User’s Guide 96 Sun Microsystems, Inc.