Sun-microsystems eWay JDBC/ODBC Adapter Manuale Utente Scaricare il pdf (Pagina 49)

Chapter 4 Section 4.2

Using the JDBC/ODBC eWay Database Wizard Creating a New JDBC OTD

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

Steps Required to Select Stored Procedures Include:

1 On the Select Procedures and specify Resultset and Parameter Information

window, click Add.

Figure 18 Select Procedures and specify Resultset and Parameter Information

2 On the Select Procedures window, enter the name of a Procedure or select a schema

from the drop down list. Click Search. Wildcard characters can also be used.

3 In the resulting Procedure Selection list box, select a Procedure. Click OK.

1 2 ... 44 45 46 47 48 49 50 51 52 53 54 ... 132 133

USER’S GUIDE 1
Contents 3
Using JDBC/ODBC Operations 57 4
JDBC/ODBC Drivers 117 6
Index 131 6
Chapter 1 7
JDBC Drivers 7
Type I: JDBC-ODBC Bridge 8
Type One Driver 8
Type II: Partial Java driver 9
Type Two Driver 9
Type Three Driver 10
Chapter 1 Section 1.1 11
About the JDBC/ODBC eWay 13
What’s New in This Release 13
About This Document 14
Related Documents 15
Documentation Feedback 16
Installing the JDBC/ODBC eWay 17
Platform Suite Installation 18
After Installation 19
Chapter 2 Section 2.2 20
Chapter 2 Section 2.3 21
Viewing Alert Codes 22
Note: Confirm with the 23
Administration Guide 24
Chapter 3 25
 Outbound JDBC eWay 26
 Outbound JDBC XA eWay 26
Chapter 3 Section 3.2 27
 Inbound JDBC eWay 29
Chapter 3 Section 3.4 30
Properties 31
Inbound JDBC eWay Properties 32
Outbound JDBC eWay Properties 32
JDBC Connector Settings 33
Connection Retry Settings 34
Chapter 3 Section 3.5 36
About the Database OTD Wizard 41
Creating a New JDBC OTD 41
Select Wizard Type 42
Connect To Database 42
Select Database Objects 43
Select Tables/Views/Aliases 44
Chapter 4 Section 4.2 45
Select Procedures 48
Figure 21 Edit Resultset 51
Add Prepared Statement 52
Specify the OTD Name 55
Review Selections 55
Chapter 4 Section 4.3 56
Using JDBC/ODBC Operations 57
Chapter 5 Section 5.1 58
Chapter 5 Section 5.2 59
The Table 60
The Insert Operation 61
The Update Operation 62
The Stored Procedure 63
Executing Stored Procedures 64
Procedure 65
Prepared Statement 67
Batch Operations 67
Statements 68
Sample Projects 69
Chapter 6 Section 6.1 70
Sample Project Data 71
Running the Sample Projects 72
Running the SQL Script 73
Importing a Sample Project 73
Chapter 6 Section 6.5 74
Creating a Project 75
Creating the OTDs 75
Creating a Connectivity Map 76
Running the Sample 94
Creating the Business Process 97
Chapter 6 Section 6.6 100
Creating the Connectivity Map 107
Binding the eWay Components 108
Creating an Environment 109
Configuring the eWays 110
Running the Sample Project 115
JDBC/ODBC Drivers 117
AS/400 Toolbox Driver 118
Attunity Driver 119
Environment Properties 120
MySQL Connector/J Driver 121
PostgreSQL Driver 122
SyBase JConnect Driver 124
Appendix A Section A.6 125
Teradata Driver 128
Installing JDBC/ODBC Drivers 129
Troubleshooting 130

Commenti su questo manuale

Nessun commento

Sun-microsystems eWay JDBC/ODBC Adapter Manuale Utente Pagina 49

Commenti su questo manuale

Prodotti e manuali riguardandi Hardware Sun-microsystems eWay JDBC/ODBC Adapter