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

Chapter 4 Section 4.2

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

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

Figure 19 Add Procedures

4 On the Select Procedures and specify Resultset and Parameter Information

window click Edit Parameters to make any changes to the selected Procedure. See

Figure 20.

Figure 20 Procedure Parameters

5 To restore the data type, click Restore. When finished, click OK.

6 To select how you would like the OTD to generate the nodes for the Resultset click

Edit Resultsets.

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 ... 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 50

Commenti su questo manuale

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