Manuals
/
Brands
/
Computer Equipment
/
Network Card
/
Sun Microsystems
/
Computer Equipment
/
Network Card
Sun Microsystems
JDBC/ODBC Adapter manual
1
1
133
133
Download
133 pages, 2.49 Mb
SUN SEEBEYOND
eWAY™ JDBC/ODBC ADAPTER
USER’S GUIDE
Release 5.1.2
Contents
Main
Page
Contents
Introducing the JDBC/ODBC eWay 7
Installing the JDBC/ODBC eWay 17
Setting Properties of the JDBC/ODBC eWay 25
Using the JDBC/ODBC eWay Database Wizard 41
Using JDBC/ODBC Operations 57
Chapter 6
Implementing the JDBC/ODBC eWay Sample Projects 69
About the JDBC eWay Sample Projects 69
Building and Deploying the prjJDBC_BPEL Sample Project 95
Appendix A
JDBC/ODBC Drivers 117 Index 131
Chapter 1
Introducing the JDBC/ODBC eWay
Type I: JDBC-ODBC Bridge
Type One Driv er
Type II: Partial Java driver
Type Two Dr ive r
Pure Java driver for database middleware
Type Three Driver
Type Four Driver: Direct-to-database pure Java driver
Page
Page
JDBC eWay Javadoc
Page
Page
Chapter 2
Installing the JDBC/ODBC eWay
Adding the eWay to an Existing Sun Java Composite Application Platform Suite Installation
After Installation
Page
Page
Page
Page
Page
Chapter 3
Setting Properties of the JDBC/ODBC eWay
Page
Page
Page
Page
Page
Propert ies
Page
Page
Details for the Connection Retry Settings used by the external database are detailed in Tabl e 8.
Tabl e 8 Outbound JDBC eWayConnection Retry Settings
Table 7 Outbound JDBC eWayJDBC Connector Settings (Continued)
The Outbound non-Transactional JDBC eWay includes the following configuration sections:
Details for the JDBC Connector Settings used by the external database are detailed in Tabl e 9.
Table 9 Outbound non-Transactional eWay JDBC Connector Settings
Table 8 Outbound JDBC eWayConnection Retry Settings (Continued)
Table 9 Outbound non-Transactional eWay JDBC Connector Settings (Continued)
Details for the Connection Retry Settings used by the external database are detailed in Tabl e 10 .
The Outbound XA JDBC eWay includes the following configuration sections:
Table 10 Outbound non-Transactional eWayConnection Retry Settings
Table 9 Outbound non-Transactional eWay JDBC Connector Settings (Continued)
Page
Details for the Connection Retry Settings used by the external database are detailed in Tabl e 12 .
Table 12 Outbound XA JDBC eWayConnection Retry Settings
Table 11 Outbound XA JDBC eWayJDBC Connector Settings (Continued)
Table 12 Outbound XA JDBC eWayConnection Retry Settings (Continued)
Chapter 4
Using the JDBC/ODBC eWay Database Wizard
Page
Page
Page
Page
Page
Page
Page
Page
Page
7Click Add to add the type of Resultset node you would like to generate. Figure 21 Edit Resultset
Page
Page
Page
Page
Page
Chapter 5
Using JDBC/ODBC Operations
Page
Page
The Query (Select) Operation
The Insert Operation
The Update Operation
The Delete Operation
Executing Stored Procedures
Manipulating the ResultSet and Update Count Returned by Stored Procedure
Page
Prepared Statement
Batch Operations
Page
Chapter 6
Implementing the JDBC/ODBC eWay Sample Projects
Page
Assigning Operations in JCD
Assigning Operations in BPEL
Page
Page
Projec t
Page
Page
Populating the Connectivity Map
jcdDelete Collaboration
jcdInsert Collaboration
jcdPsSelect Collaboration
jcdTableSelect Collaboration
jcdPsUpdate Collaboration
Creating the jcdDelete Business Rules
Creating the jcdInsert Business Rules
Figure 32 jcdInsert Business Rules
Sample code from the jcdInsert Includes:
Creating the jcdPsSelect Business Rules
Figure 33 jcdPsSelect Business Rules
Sample code from the jcdPsSelect Includes:
Creating the jcdTableSelect Business Rules
Figure 34 jcdTableSelect Business Rules
Sample code from the jcdTableSelect Includes:
Creating the jcdUpdate Business Rules
Page
Page
Configuring the eWay Properties
Configuring the Environment Explorer Properties
Configuring the Integration Server
Page
Page
Projec t
Page
Creating the Business Process Flow
Configuring the bpelPsInsert Modeling Elements
Page
Configuring the bpelUpdate Modeling Elements
Page
Configuring the bpelDelete Modeling Elements
Page
Configuring the bpelTableSelect Modeling Elements
Page
Page
Populating the Connectivity Map
Binding the eWay Components
Page
Page
Configuring the eWay Properties
Configuring the Environment Explorer Properties
Table 22 JDBC eWay Environment Properties
Table 23 File eWay Environment Properties
Configuring the Integration Server
Page
Page
Page
Appendix A
JDBC/ODBC Drivers
Page
Page
Use Table 27 to configure the environment properties for the specified JDBC/ODBC driver.
Table 26 Attunity Driver Database Connection Information
Note: The <database-logical-name> is created in
Table 27 Attunity Driver Database Environment Properties
Note: NOTE: Default server port is 2551.
Page
Page
Page
Page
Page
Page
Page
Page
Page
Page
Index
A
B
C
D
M
O
P
R
S
