Français dropdown-ico

Sun Microsystems eWay JDBC/ODBC Adapter manuel d'utilisation

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133

Aller à la page of

Les manuels d’utilisation similaires

Un bon manuel d’utilisation

Les règles imposent au revendeur l'obligation de fournir à l'acheteur, avec des marchandises, le manuel d’utilisation Sun Microsystems eWay JDBC/ODBC Adapter. Le manque du manuel d’utilisation ou les informations incorrectes fournies au consommateur sont à la base d'une plainte pour non-conformité du dispositif avec le contrat. Conformément à la loi, l’inclusion du manuel d’utilisation sous une forme autre que le papier est autorisée, ce qui est souvent utilisé récemment, en incluant la forme graphique ou électronique du manuel Sun Microsystems eWay JDBC/ODBC Adapter ou les vidéos d'instruction pour les utilisateurs. La condition est son caractère lisible et compréhensible.

Qu'est ce que le manuel d’utilisation?

Le mot vient du latin "Instructio", à savoir organiser. Ainsi, le manuel d’utilisation Sun Microsystems eWay JDBC/ODBC Adapter décrit les étapes de la procédure. Le but du manuel d’utilisation est d’instruire, de faciliter le démarrage, l'utilisation de l'équipement ou l'exécution des actions spécifiques. Le manuel d’utilisation est une collection d'informations sur l'objet/service, une indice.

Malheureusement, peu d'utilisateurs prennent le temps de lire le manuel d’utilisation, et un bon manuel permet non seulement d’apprendre à connaître un certain nombre de fonctionnalités supplémentaires du dispositif acheté, mais aussi éviter la majorité des défaillances.

Donc, ce qui devrait contenir le manuel parfait?

Tout d'abord, le manuel d’utilisation Sun Microsystems eWay JDBC/ODBC Adapter devrait contenir:
- informations sur les caractéristiques techniques du dispositif Sun Microsystems eWay JDBC/ODBC Adapter
- nom du fabricant et année de fabrication Sun Microsystems eWay JDBC/ODBC Adapter
- instructions d'utilisation, de réglage et d’entretien de l'équipement Sun Microsystems eWay JDBC/ODBC Adapter
- signes de sécurité et attestations confirmant la conformité avec les normes pertinentes

Pourquoi nous ne lisons pas les manuels d’utilisation?

Habituellement, cela est dû au manque de temps et de certitude quant à la fonctionnalité spécifique de l'équipement acheté. Malheureusement, la connexion et le démarrage Sun Microsystems eWay JDBC/ODBC Adapter ne suffisent pas. Le manuel d’utilisation contient un certain nombre de lignes directrices concernant les fonctionnalités spécifiques, la sécurité, les méthodes d'entretien (même les moyens qui doivent être utilisés), les défauts possibles Sun Microsystems eWay JDBC/ODBC Adapter et les moyens de résoudre des problèmes communs lors de l'utilisation. Enfin, le manuel contient les coordonnées du service Sun Microsystems en l'absence de l'efficacité des solutions proposées. Actuellement, les manuels d’utilisation sous la forme d'animations intéressantes et de vidéos pédagogiques qui sont meilleurs que la brochure, sont très populaires. Ce type de manuel permet à l'utilisateur de voir toute la vidéo d'instruction sans sauter les spécifications et les descriptions techniques compliquées Sun Microsystems eWay JDBC/ODBC Adapter, comme c’est le cas pour la version papier.

Pourquoi lire le manuel d’utilisation?

Tout d'abord, il contient la réponse sur la structure, les possibilités du dispositif Sun Microsystems eWay JDBC/ODBC Adapter, l'utilisation de divers accessoires et une gamme d'informations pour profiter pleinement de toutes les fonctionnalités et commodités.

Après un achat réussi de l’équipement/dispositif, prenez un moment pour vous familiariser avec toutes les parties du manuel d'utilisation Sun Microsystems eWay JDBC/ODBC Adapter. À l'heure actuelle, ils sont soigneusement préparés et traduits pour qu'ils soient non seulement compréhensibles pour les utilisateurs, mais pour qu’ils remplissent leur fonction de base de l'information et d’aide.

Table des matières du manuel d’utilisation

  • Page 1

    SUN SEEBEY OND eWAY™ JDBC/ODBC ADAPTER USER’S GUIDE Release 5.1.2[...]

  • Page 2

    JDBC/ODBC eWay Adapter User’s Guide 2 Sun Micros ystems, Inc. Copyright © 2006 Sun Microsystems, Inc., 4150 Network Circle, Sa nta Clara, California 95054, U.S.A. All rights reserved. Sun Microsystems, Inc. has intellectual property rights relating to te chnology embodied in the product that is described in this document. In particular, and with[...]

  • Page 3

    Contents JDBC/ODBC eWay Adapter User’s Guide 3 Sun Micros ystems, Inc. Contents Chapter 1 Introducing the JDBC/ODBC eWay 7 About Java Database Connectivity (JDBC) 7 JDBC Dri vers 7 Type I: JDBC-OD BC Bridge 8 Type One Driver 8 Type II: Parti al Java driver 9 Type Two Drive r 9 Pure Java driver for database middleware 10 Type Three Driver 10 Type [...]

  • Page 4

    Contents JDBC/ODBC eWay Adapter User’s Guide 4 Sun Micros ystems, Inc. Chapter 3 Setting Properties of the JDBC/ODBC eWay 25 Creating and Configuring a JDBC eWay 25 Configuring the eWay Connectivity Map Properties 25 Transaction Support Levels Between Different Ve rsions 27 Configuring the eWay Environment Properties 29 eWay Connectivity Map Prop[...]

  • Page 5

    Contents JDBC/ODBC eWay Adapter User’s Guide 5 Sun Micros ystems, Inc. The Tab le 60 The Quer y (Selec t) Operation 60 The Insert Operation 61 The Update Operation 62 The Delete Operation 63 The Stored Proce dure 63 Executing Stored Procedures 64 Manipulating the ResultSet and Update Count Returned by Stored Procedure 65 Prepared Statemen t 67 Ba[...]

  • Page 6

    Contents JDBC/ODBC eWay Adapter User’s Guide 6 Sun Micros ystems, Inc. Building and Deploying the Project 94 Running the Samp le 94 Building and Deploying the prjJDBC_BPEL Sample Project 95 Creating a Project 95 Creating the OTDs 96 Creating the Business Proce ss 97 Creating the Business Process Fl ow 97 Configuring the b pelPsInsert Modeling Ele[...]

  • Page 7

    JDBC/ODBC eWay Adapter User’s Guide 7 Sun Micros ystems, Inc. Chapter 1 Introducing the JDBC/ODBC eW a y W elcome to the Sun SeeBeyond eWay ™ JDBC/ODBC Adapter Use r ’ s Guide. This documen t includes information about in stalling, configuring, and us ing the Sun Java Com posite Application Platform Suite JDBC/ODBC eW ay™ Adapter , re ferre[...]

  • Page 8

    Chapter 1 Section 1.1 Introducing the JDBC/ODBC eWay About Java D atabase Conne ctivity (JD BC) JDBC/ODBC eWay Adapter User’s Guide 8 Sun Micros ystems, Inc. database and middlewar e vendors. The vari ous driver types ar e described in the following sections:  “T ype I: JDBC-ODBC Bridge” on page 8  “T ype II: Partial Java driver” on[...]

  • Page 9

    Chapter 1 Section 1.1 Introducing the JDBC/ODBC eWay About Java D atabase Conne ctivity (JD BC) JDBC/ODBC eWay Adapter User’s Guide 9 Sun Micros ystems, Inc. The pros and c ons for using this type of driver are as follows: Pr o s  Allows access to almost any database si nce the database ODBC drivers ar e readily available Cons  Performance [...]

  • Page 10

    Chapter 1 Section 1.1 Introducing the JDBC/ODBC eWay About Java D atabase Conne ctivity (JD BC) JDBC/ODBC eWay Adapter User’s Guide 10 Sun Micros ystems, Inc. Figure 2 T ypical T ype 2 Driv er Configuration The pros and c ons for using this type of driver are as follows: Pr o s  Allows access to almost any database since the databases ODBC dri[...]

  • Page 11

    Chapter 1 Section 1.1 Introducing the JDBC/ODBC eWay About Java D atabase Conne ctivity (JD BC) JDBC/ODBC eWay Adapter User’s Guide 11 Sun Micros ystems, Inc. differ ent data bases. Many mainfram e legacy non-relational databases use this kind of driver . Figure 3 T ypical T ype 3 Middleware Driv er Configuration The pros and c ons for using this[...]

  • Page 12

    Chapter 1 Section 1.1 Introducing the JDBC/ODBC eWay About Java D atabase Conne ctivity (JD BC) JDBC/ODBC eWay Adapter User’s Guide 12 Sun Micros ystems, Inc. Cons: Not optimized for server operating system, so the driv e r can't take advantage of operating system featur es. (The driver is optimized for th e database and can take advantage o[...]

  • Page 13

    Chapter 1 Section 1.2 Introducing the JDBC /ODBC eWay About the JDBC/ODBC eWay JDBC/ODBC eWay Adapter User’s Guide 13 Sun Micros ystems, Inc. 1.2 About the JDBC/ODBC eW a y This document describes how to install and configure the JDBC/ODBC eW ay . The JDBC/ODBC eW ay enables the eGate system to exchange data with external databases. The Sun Java [...]

  • Page 14

    Chapter 1 Section 1.4 Introducing the JDBC /ODBC eWay About This Document JDBC/ODBC eWay Adapter User’s Guide 14 Sun Micros ystems, Inc.  Connectivity Map Generator: Generates an d links your Project’s Connectivit y Map components using a Collaborat ion or Business Process. Many of these featur es are docum ented further in the Sun SeeBeyond[...]

  • Page 15

    Chapter 1 Section 1.5 Introducing the JDBC /ODBC eWay Related D ocuments JDBC/ODBC eWay Adapter User’s Guide 15 Sun Micros ystems, Inc. 1.4.2 Intended Audience This guide is intend ed for experienced comput er users who hav e the responsibility of helping to set up and maintain a fully functioning Java Composite Application Platform Suite system.[...]

  • Page 16

    Chapter 1 Section 1.7 Introducing the JDBC /ODBC eWay Documentation Feedback JDBC/ODBC eWay Adapter User’s Guide 16 Sun Micros ystems, Inc. 1.7 Document at ion Feedback W e appreciate your feedback. Pleas e send an y comments or suggestions regar ding this document to: CAPS_docsfeedback@sun.com[...]

  • Page 17

    JDBC/ODBC eWay Adapter User’s Guide 17 Sun Micros ystems, Inc. Chapter 2 Inst alling the JDBC/ODBC eW a y This chapter describes how to install the JDBC/ODBC eW ay . What ’ s in this Ch apter  Installing the JDBC eW ay on page 17  ICAN 5.0 Project Migration Procedures on page 19  Installing Enterprise Manager eW ay Plug-Ins on page 21 [...]

  • Page 18

    Chapter 2 Section 2.1 Installing the JDBC/ODBC eWay Installing the JDBC eWay JDBC/ODBC eWay Adapter User’s Guide 18 Sun Micros ystems, Inc. 2.1.1 Installing the JDBC eW ay on an eGate supported system Follow the dire c tions for installing the Sun Java Composite Applica tion Platform Suite in the Sun Java Composite Application Plat form Suite Ins[...]

  • Page 19

    Chapter 2 Section 2.2 Installing the JDBC/ODBC eWay ICAN 5.0 Project Migration Procedures JDBC/ODBC eWay Adapter User’s Guide 19 Sun Micros ystems, Inc. 7 When prom pted, restart the IDE (I ntegrated Development Envir onment) to complete the installation. After Inst allat ion Once you install the eW ay , it must then be incorporated into a Projec[...]

  • Page 20

    Chapter 2 Section 2.2 Installing the JDBC/ODBC eWay ICAN 5.0 Project Migration Procedures JDBC/ODBC eWay Adapter User’s Guide 20 Sun Micros ystems, Inc. 2 From the Pr oject Explorer , right- click your Project and select Export from the shortcut menu . Th e Export Manager appears. 3 Select the Proje ct that you want to export in the left pane of [...]

  • Page 21

    Chapter 2 Section 2.3 Installing the JDBC/ODBC eWay Installin g Enterprise Manager eWay Plug-Ins JDBC/ODBC eWay Adapter User’s Guide 21 Sun Micros ystems, Inc. C Select the Envir onment Explorer tab, an d from the Envir onment Explor er , right- click the Pr oject’s Environment and select V ersion Control > Check Out fr om the shortcut menu.[...]

  • Page 22

    Chapter 2 Section 2.3 Installing the JDBC/ODBC eWay Installin g Enterprise Manager eWay Plug-Ins JDBC/ODBC eWay Adapter User’s Guide 22 Sun Micros ystems, Inc. T o add plug-ins from the Sun Java Compos ite Applicat ion Platform Suite Inst aller 1 From the Sun Java Composite Application Platform Suite Installer ’s Downloads tab , select th e Plu[...]

  • Page 23

    Chapter 2 Section 2.3 Installing the JDBC/ODBC eWay Installin g Enterprise Manager eWay Plug-Ins JDBC/ODBC eWay Adapter User’s Guide 23 Sun Micros ystems, Inc. For information on Managing and Moni toring alert codes and logs, as well as how to view the alert generated by the project component during runtime, s ee the Sun SeeBeyond eGate ™ Integ[...]

  • Page 24

    Chapter 2 Section 2.3 Installing the JDBC/ODBC eWay Installin g Enterprise Manager eWay Plug-Ins JDBC/ODBC eWay Adapter User’s Guide 24 Sun Micros ystems, Inc. Note: An alert code is a warning that an error has occurr ed. It is not a diagnostic. The user actions noted above are just some possible corrective measur es you may tak e. Refer to the l[...]

  • Page 25

    JDBC/ODBC eWay Adapter User’s Guide 25 Sun Micros ystems, Inc. Chapter 3 Sett ing P roper t ies of the JDBC/ODBC eW a y This chapter describes how to set th e pr operties of the JDBC/ODBC eW ay . What ’ s In This Chapter  Creating and Configuring a JDBC eW ay on page 25  Configuring the eW ay Connectivity Map Properties on page 25  Con[...]

  • Page 26

    Chapter 3 Section 3.2 Setting Properties of the JDBC/ODBC eWay Config uring the eWay Connectivity Map Properties JDBC/ODBC eWay Adapter User’s Guide 26 Sun Micros ystems, Inc.  Outbound JDBC eW ay  Outbound JDBC XA eW ay  Outbound JDBC non-T ransactional eW ay T o configure the eW a y propert ies: 1 On the Enterprise Designer ’s Connec[...]

  • Page 27

    Chapter 3 Section 3.2 Setting Properties of the JDBC/ODBC eWay Config uring the eWay Connectivity Map Properties JDBC/ODBC eWay Adapter User’s Guide 27 Sun Micros ystems, Inc.  Outbound JDBC eW ay: Also r eferred to as LocalT ransaction, this support level is opposite to NoT ransaction, and this means that the tran saction, when The Prope rtie[...]

  • Page 28

    Chapter 3 Section 3.2 Setting Properties of the JDBC/ODBC eWay Config uring the eWay Connectivity Map Properties JDBC/ODBC eWay Adapter User’s Guide 28 Sun Micros ystems, Inc. In 5.1.2, five new records ar e to be inserted into a table . If one of the records fails to insert (such as when a duplicate key exists), the other four recor ds will not [...]

  • Page 29

    Chapter 3 Section 3.3 Setting Properties of the JDBC/ODBC eWay Configuring the eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 29 Sun Micros ystems, Inc. 3.3 Configur ing the eW a y En vironment P ropert ies The eW ay Environment Configuration properties contain parame ters that define how the eW ay connects to and interacts with [...]

  • Page 30

    Chapter 3 Section 3.4 Setting Properties of the JDBC/ODBC eWay eWay Connectivity Map Properties JDBC/ODBC eWay Adapter User’s Guide 30 Sun Micros ystems, Inc. Figure 9 JDBC eW ay Environment Configuration 4 Click on any folder to display the de fault configurat ion properties for that sectio n. 5 Click on any property field to make it editable. A[...]

  • Page 31

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 31 Sun Micros ystems, Inc. Outbound XA eW a y Conf iguration Sett ings Include:  Connectivity Map Outbound XA eW ay Properties on page 31 3.4.1 Connect ivit y Map Outbound eW a y P ropert ies The Outbound eW ay Propert[...]

  • Page 32

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 32 Sun Micros ystems, Inc.  Outbound JDBC eW ay Properties on page 32  Outbound non-T ransactional JDBC eW ay Properties on page 35  Outbound XA JDBC eW ay Properties on page 37 3.5.1 Inbound JDBC eW a y P roper [...]

  • Page 33

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 33 Sun Micros ystems, Inc. JDBC Connector Sett ings Details for the JDBC C onnector Settings used by the external databa se ar e detailed in Ta b l e 7 . Ta b l e 7 Outbound JDBC eW ay—JDBC Connector Settings Name Descr[...]

  • Page 34

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 34 Sun Micros ystems, Inc. Connect ion Re tr y Sett ings Details for the Connection Ret ry Settings used by the external data base ar e detailed in Ta b l e 8 . DataSource name Specifies th e name of the XADataSource or C[...]

  • Page 35

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 35 Sun Micros ystems, Inc. 3.5.3 Outbound non- T ransact ional JDBC eW a y P roper t ies The Outbound non-T ransactional JDBC eW ay includes the following configuration sections:  JDBC Connector Settings  Connection[...]

  • Page 36

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 36 Sun Micros ystems, Inc. P or tNumber Specifies the I/O port number on which the server is listeni ng for connection requests. A valid port number . DatabaseName Specifies the name of the database instance . Any valid s[...]

  • Page 37

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 37 Sun Micros ystems, Inc. Connect ion Re tr y Sett ings Details for the Connection Ret ry Settings used by the external data base ar e detailed in Ta b l e 1 0 . 3.5.4 Outbound XA JDBC eW a y P roper t ies The Outbound X[...]

  • Page 38

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 38 Sun Micros ystems, Inc.  Connection Retry Settings JDBC Connector Sett ings Details for the JDBC C onnector Settings used by the external databa se ar e detailed in Ta b l e 1 1 . T able 11 Outbound XA JDBC eW ay—[...]

  • Page 39

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 39 Sun Micros ystems, Inc. Connect ion Re tr y Sett ings Details for the Connection Ret ry Settings used by the external data base ar e detailed in Ta b l e 1 2 . DataSource name Specifies th e name of the XADataSource im[...]

  • Page 40

    Chapter 3 Section 3.5 Setting Properties of the JDBC/ODBC eWay eWay Environment Properties JDBC/ODBC eWay Adapter User’s Guide 40 Sun Micros ystems, Inc. ConnectionRetryInterval Specifi es the milliseconds of pause before each attempt to reaccess the database. Thi s setting is used in conjunction with the 'Connection Retries' setting. F[...]

  • Page 41

    JDBC/ODBC eWay Adapter User’s Guide 41 Sun Micros ystems, Inc. Chapter 4 Using the JDBC/ODBC eW a y Dat abase Wizard This chapter describes how to use the JDBC eW ay Database W izard to build OTDs. What ’ s In This Chapter:  About the Database OTD W izard on page 41  Creating a New JDBC OTD on page 41  Steps to Edit an Existing JDBC OT[...]

  • Page 42

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 42 Sun Micros ystems, Inc.  Connect T o Database on page 42  Select Database Objects on page 43  Select T ables/V iews/Aliases on page 44  Select Procedures on page 48  Add Prepared Statement on page 52  Sp[...]

  • Page 43

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 43 Sun Micros ystems, Inc. 2 Enter the JDBC databa se connection informat ion in the Connection Information frame. R equired Data base Conne ct ion Fields include:  Driver Jar Files – the locati on of the driver JAR fil[...]

  • Page 44

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 44 Sun Micros ystems, Inc. Figure 12 Select Database Objects 4.2.4 Select T ables/Views/Aliases Select the types of tables, views , or aliases requir ed in the OTD. Steps R equired to Select T able/Views/Aliases Include: 1 I[...]

  • Page 45

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 45 Sun Micros ystems, Inc. Figure 13 Select T ables/Views/ Aliases 2 In the Add T ables window , select if your selection criteria will include table data, view only data, both, and/or system tables. 3 From the T able/V iew [...]

  • Page 46

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 46 Sun Micros ystems, Inc. Figure 14 Database Wizard - All Schemes 4 Select the table of choice and click OK . The table selected is add ed to the Selected T ables/V iews/Aliases section. See Figur e 15.[...]

  • Page 47

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 47 Sun Micros ystems, Inc. Figure 15 Selected T ables/Views/Aliases window with a table selected 5 In the Selected T ables /V iews/Aliases sect ion, review the table(s) you have selecte d. T o make changes to the selected T [...]

  • Page 48

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 48 Sun Micros ystems, Inc. Figure 16 T able/View Columns 7 Click Advanced to change the data type, per cisio n/length, or scale. Once you have finished your table choices, click OK . In general, you will not need to make any[...]

  • Page 49

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 49 Sun Micros ystems, Inc. Steps R equired to Selec t Stored P rocedures Include: 1 On the Select Procedures and specify Re sultset and Parameter Information window , click Add. Figure 18 S elect Procedures and specify Resul[...]

  • Page 50

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 50 Sun Micros ystems, Inc. Figure 19 Add Procedures 4 On the Select Procedures and specify Re sultset and Parameter Information window click Edit Parameters to make any changes to the selecte d Procedure. See Figure 20. Figu[...]

  • Page 51

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 51 Sun Micros ystems, Inc. 7 Click Add to add the type of Resultset node you would like to generate. Figure 21 Edit Resultset The DBW izard provide s three dif ferent ways to generate the ResultSet nodes of a Store d Procedu[...]

  • Page 52

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 52 Sun Micros ystems, Inc. 8 On the Select Procedures and specify Re sultset and Parameter Information window click Next to continue. Note: Not all drivers and databases support stored procedur es or stored pr ocedures with [...]

  • Page 53

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 53 Sun Micros ystems, Inc. Figure 22 P repared Statement 2 Enter the name of a Pr epared Statement or cr eate a SQL statement by clicking in the SQL Statement window . When finish ed creating the statement, click Save As giv[...]

  • Page 54

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 54 Sun Micros ystems, Inc. Figure 24 Edit the Prepared Statement Parameters . 5 T o edit Resultset Columns, click Edit Resultset Columns . The ResultSet Colu mns window appears . See Figure 25. Figure 25 ResultSet Columns 6 [...]

  • Page 55

    Chapter 4 Section 4.2 Using the JDBC/ODBC eWay Data base Wizard Creating a New JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 55 Sun Micros ystems, Inc. 4.2.7 Specify the O TD Name Specify the name that your OTD will disp lay in the Enterp rise Designe r Project Explorer . Steps R equired to Specify the O TD Name: 1 Enter a name for the OTD . The O[...]

  • Page 56

    Chapter 4 Section 4.3 Using the JDBC/ODBC eWay Da tabase Wizard Steps to Edit an Existing JDBC OTD JDBC/ODBC eWay Adapter User’s Guide 56 Sun Micros ystems, Inc. Figure 27 Database Wizard - Summary 4.3 Steps to Edit an Exist ing JDBC O TD Y ou can edit any database OTD you cre ate directly from the Enterprise Designer Pr oject Explorer . Steps to[...]

  • Page 57

    JDBC/ODBC eWay Adapter User’s Guide 57 Sun Microsytems, Inc. Chapter 5 Using JDBC/ODBC Operat ions Database operations in the JDBC eW ay are used to acce ss the JDBC database. Database operations ar e either accessed through Acti vities in BPEL, or through methods called from a JCD Collaboration. What ’ s in This Chapter  JDBC eW ay Database[...]

  • Page 58

    Chapter 5 Section 5.1 Using JDBC/ODBC O perations JDBC eW ay Database Operations (B PEL) JDBC/ODBC eWay Adapter User’s Guide 58 Sun Microsytems, Inc. Figure 28 displays the bu siness rules between the FileClient.write and otdJDBC.Db_employe eDelete Activi ties. In th is example, th e whereClause appears on the Input side. Figure 28 Input and Outp[...]

  • Page 59

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 59 Sun Microsytems, Inc. 5.2 JDBC eW a y Dat abase Operat ions ( JCD) The same database operations ar e also used in the JCD, but appear as methods to call from the Collaboration. T ables, V iews, and Stored Pr ocedures ar e ma[...]

  • Page 60

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 60 Sun Microsytems, Inc. operation. Check wi th the respective driver ’s vendor for further inform ation. This feature is known as Updatable ResultSet. Note: Refer to the Javadoc for a full description of methods included in [...]

  • Page 61

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 61 Sun Microsytems, Inc. { FileClient_1.setText( "Selecting record(s) from db_employee table via table select .." ); FileClient_1.write(); otdJDBC_1.getDB_EMPLOYEE().select( input.getText() ); while (otdJDBC_1.getDB_E[...]

  • Page 62

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 62 Sun Microsytems, Inc. otdInputDTD_DBemployees_1.unmarshalFromString( input.getText() ); for (int i1 = 0; i1 < otdInputDTD_DBemployees_1.countX_sequence_A(); i1 += 1) { otdJDBC_1.getInsert_Ps().setEmp_no( typeConverter.str[...]

  • Page 63

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 63 Sun Microsytems, Inc. otdJDBC_1.getUpdate_Ps().setEmp_no( typeConverter.stringToShort( input.getText(), "#", false, 0 ) ); otdJDBC_1.getUpdate_Ps().executeUpdate(); FileClient_1.setText( "Done Update." );[...]

  • Page 64

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 64 Sun Microsytems, Inc. Ex ecut ing Stored Procedures The OTD r epresents the Stor ed Procedur e “LookUpGlobal” with two parameters, an inbound parameter (INLOCALID) and an outbound parameter (OUTGLOBALPRODUCTID). These in[...]

  • Page 65

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 65 Sun Microsytems, Inc. FileClient_1.write(); } } Manipulat ing the R esultSet and Update Count R eturned by Stored Pr o c e du re For Stor ed Procedur es that return ResultSe ts and Update Count, the following methods are pr [...]

  • Page 66

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 66 Sun Microsytems, Inc. Collaboration usability for a stored p rocedure R esultSet The Column data of the ResultSets can be dragged-and-dr opped from their nodes to the Business Rules. Below is a code snippet that can be gener[...]

  • Page 67

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 67 Sun Microsytems, Inc. parameters are r etrieved. Therefor e, you sh ould retrieve all ResultSet(s) and Update Counts first followed by retrieving the OUT type par ameters and return values. The following list includes specif[...]

  • Page 68

    Chapter 5 Section 5.2 Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD) JDBC/ODBC eWay Adapter User’s Guide 68 Sun Microsytems, Inc. submit the batch to the data base server . Batch operations apply only to Prepar ed Statements. Not all drivers support batch operations. Check with the respective driver ’s vendor for further informa[...]

  • Page 69

    JDBC/ODBC eWay Adapter User’s Guide 69 Sun Micros ystems, Inc. Chapter 6 Implement ing the JDBC/ODBC eW a y Sample P rojects This chapter pr ovides an introduction to the JDBC eW ay components, and information on how these components are cr eated an d implemented in a Sun Java Composit e Application Platform Suite Project. Sample Pr ojects are de[...]

  • Page 70

    Chapter 6 Section 6.1 Implementing the JDBC/ODBC eWay Sample Pr ojects About the JDBC eWay Sample Projects JDBC/ODBC eWay Adapter User’s Guide 70 Sun Micros ystems, Inc. Figure 29 Database project flow Both the prjJDBC_JCD and prjJDBC_BPEL sample Pr ojects demonstrate how to:  Select employee r ecords fr om a database using a pr epared stateme[...]

  • Page 71

    Chapter 6 Section 6.1 Implementing the JDBC/ODBC eWay Sample Pr ojects About the JDBC eWay Sample Projects JDBC/ODBC eWay Adapter User’s Guide 71 Sun Micros ystems, Inc.  BPEL_T ableSelect_output().dat 6.1.1 Sample P roject Dat a Data used for the sample Pr ojects are contained within a table called db_employee . The table has the following co[...]

  • Page 72

    Chapter 6 Section 6.2 Implementing the JDBC/ODBC eWay Sample Projects Running the Sample Projects JDBC/ODBC eWay Adapter User’s Guide 72 Sun Micros ystems, Inc. At run time, the eInsight engine invokes each step in the or der that you defined in the Business Pr ocess. Using the engine’s W eb Services interface, the Activity in turn invokes the [...]

  • Page 73

    Chapter 6 Section 6.3 Implementing the JDBC/ODBC eWay Sample Projects Running the SQL Script JDBC/ODBC eWay Adapter User’s Guide 73 Sun Micros ystems, Inc. The script creates the table s and recor ds required by the sample Project. 2 Import the sample Pr ojects. 3 Build, deploy , and run the sample Pr ojects. Y ou must do the following before you[...]

  • Page 74

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 74 Sun Micros ystems, Inc. Note: Make sur e you save all unsaved work before importing a P roject. 2 From the Enterprise Designer ’s Project Ex plor er pane, right-click the Repositor[...]

  • Page 75

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 75 Sun Micros ystems, Inc.  Creating the Collaboratio n Definitions (Java) on page 78  Create the Collaboration Business Rules on page 81  Binding the eW ay Components on page [...]

  • Page 76

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 76 Sun Micros ystems, Inc. 4 Click Next , and select the ty pes of database object you want to include in the sample Project. For our example, select the following:  T ables/V iews/A[...]

  • Page 77

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 77 Sun Micros ystems, Inc. Steps required to create a new Connectivit y Map: 1 From the Project Explore r tree, right-click the new prjJDBC_JCD Pr oject and select New > Connectivity[...]

  • Page 78

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 78 Sun Micros ystems, Inc.  jcdInsert  jcdPsSelect  jcdT ableSelect  jcdPsUpdate 6.5.4 Creat ing the Collaborat ion Def init ions ( Ja v a) The next step i s to create Colla[...]

  • Page 79

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 79 Sun Micros ystems, Inc. jcdInser t Collaborat ion Steps required to create the jcdInsert Collaborat ion: 1 From the Pr oject Explorer , right-c lick the sample Project and select Ne [...]

  • Page 80

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 80 Sun Micros ystems, Inc. 6 Click the Up One Level button t wice to return to the Re pository . Double-click Sun SeeBeyond > eW ays > File > FileClient . The Selected OTDs fie[...]

  • Page 81

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 81 Sun Micros ystems, Inc. 4 For Step 3 of the wizar d, from the Sele ct OTDs selection window , double-click prjJDBC_JCD > otdALL > otdJDBC . The otdJDBC OTD is add ed to the Sel[...]

  • Page 82

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 82 Sun Micros ystems, Inc. Figure 32 jcdInser t Business Rules Sample code fr om the jcdInsert Includes: package prjJDBC_JCDjcdALL; public class jcdInsert { public com.stc.codegen.logge[...]

  • Page 83

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 83 Sun Micros ystems, Inc. otdInputDTD_DBemployees_1.getX_sequence_A( i1 ).getEmpNo(), "#", false, 0 ) ); otdJDBC_1.getInsert_Ps().setLast_name( otdInputDTD_DBemployees_1.getX[...]

  • Page 84

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 84 Sun Micros ystems, Inc. Figure 33 jcdPsSelect Bu siness Rules Sample code from the jcdPsSelect Incl udes: package prjJDBC_JCDjcdALL; public class jcdPsSelect { public com.stc.codegen[...]

  • Page 85

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 85 Sun Micros ystems, Inc. otdOutputDTD_DBemployee_1.setEmpNo( Integer.toString( otdJDBC_1.getSelect_ps().get$Select_psResults().getEMP_NO() ) ); otdOutputDTD_DBemployee_1.setLastname( [...]

  • Page 86

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 86 Sun Micros ystems, Inc. Figure 34 jcdT ableSelect Business Ru les Sample code from the jcdT ableSelec t Includes: package prjJDBC_JCDjcdALL; public class jcdTableSelect { public com.[...]

  • Page 87

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 87 Sun Micros ystems, Inc. otdOutputDTD_DBemployee_1.setRate( otdJDBC_1.getDB_EMPLOYEE().getRATE().toString() ); otdOutputDTD_DBemployee_1.setLastDate( typeConverter.dateToString( otdJD[...]

  • Page 88

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 88 Sun Micros ystems, Inc. Steps required to bind eW ay components together: 1 Double-click a Connectivity Map—in this example cmDelete —in the Pr oject Explore r tree. The cmDelete[...]

  • Page 89

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 89 Sun Micros ystems, Inc. Steps required to create an En vironment: 1 From the Enterprise Designer ’s Enterprise Explorer , click the Environment Explorer tab. 2 Right-click the Repo[...]

  • Page 90

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 90 Sun Micros ystems, Inc. Y ou must configure eW ay properties in both the Connecti vity Map and the Environment Explor er . Figure 38 eW ays in the cmDelete Connectivity Map Configur [...]

  • Page 91

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 91 Sun Micros ystems, Inc. Configur ing the Environment Explorer P ropert ies Steps required to configure the En vironment Explorer pr opert ies: 1 From the Environment Explorer tr ee, [...]

  • Page 92

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 92 Sun Micros ystems, Inc. Configur ing the Integrat ion Ser ver Y ou must set your SeeBeyond Integration Se rver Passwor d property before deploying your Project. 1 From the Envir onme[...]

  • Page 93

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 93 Sun Micros ystems, Inc. Steps required to create the Deplo yme nt P rof ile: 1 From the Enterpris e Explorer ’s Pr oject Explor er , right-click the prjJDBC_JCD Project and select [...]

  • Page 94

    Chapter 6 Section 6.5 Implementing the JDBC/ODBC eWay Sample Projects Bu ilding and Deplo ying the prjJDBC_JCD Sam ple Project JDBC/ODBC eWay Adapter User’s Guide 94 Sun Micros ystems, Inc. Steps required to create and star t the domain: 1 Navigate to your <JavaCAPS51>logicalhost dir ectory (where <JavaCAPS51> is the location of your[...]

  • Page 95

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 95 Sun Micros ystems, Inc. data, and the File eW ay sends the output to an Output file name (as defined in the outbound File eW ay Properties wi ndow). The Where Clause defined in the b[...]

  • Page 96

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 96 Sun Micros ystems, Inc. 2 From the Project Explor er tree, right-click the Re pository and sele ct New Project . A new Project ( Project1 ) appears on the Pr oject Explorer tr ee. 3 [...]

  • Page 97

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 97 Sun Micros ystems, Inc. Note: In our example, the SQL statement includes the ? placeholder for input. This placeholder repr esents the value for the Where Clause. 9 Click the OK butt[...]

  • Page 98

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 98 Sun Micros ystems, Inc. Configur ing the bpelP sInser t Modeling Elements Business Rules, cr eated between the Business Pr ocess Activities, allow you to configure the re lationships[...]

  • Page 99

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 99 Sun Micros ystems, Inc. Figure 40 bpelPsInsert Business Process Steps required to configure the bpelPsI nser t business process: 1 Configure the business rule between the FileClient.[...]

  • Page 100

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 100 Sun M icrosystem s, Inc. Figure 43 bpelP sInse r t Busines s Rule # 3 4 Configure the business rule between the otdJDBC. Insert_psPSInsert Activity and the FileClient.write Activity[...]

  • Page 101

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 101 Sun M icrosystem s, Inc. Note: Review the eInsight Business Process Manager User ’ s Guide for a more detailed description of the steps required to co nnect and add business rules[...]

  • Page 102

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 102 Sun M icrosystem s, Inc. Figure 47 bpelUpdate Business Rule # 2 3 Configure the business rule between otdJDBC.DB_EMPLOYEEUpdate and the FileClient.write Activity , as seen in Figure[...]

  • Page 103

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 103 Sun M icrosystem s, Inc. Note: Review the eInsight Business Process Manager User ’ s Guide for a more detailed description of the steps required to co nnect and add business rules[...]

  • Page 104

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 104 Sun M icrosystem s, Inc. 3 Configure the business rule betwe en the otdJDBC.DB_EMPLOYEEDelete Activity and the FileClient.write Activity , as seen in Figure 52. Figure 52 bpelDelete[...]

  • Page 105

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 105 Sun M icrosystem s, Inc. Figure 54 bpelT ableSelect Business Rule # 1 2 Configure the business rule between the FileClient.write Activity and otdJDBC.DB_EMPLOYEESelectAll Activity ,[...]

  • Page 106

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 106 Sun M icrosystem s, Inc. Figure 56 bpelSelectT able Business Rule # 3 4 Configure the business rule between the otdInpu tDTD_DBemployees.marshal Activity and the FileClient.write Ac[...]

  • Page 107

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 107 Sun M icrosystem s, Inc. 6.6.4 Creat ing the Connect ivity Map The Connectivity Map pr ovides a canvas fo r assembling and configuring a Proje ct’s components. Steps required to c[...]

  • Page 108

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 108 Sun M icrosystem s, Inc. T o Select a JDBC Busin ess P rocess 1 Drag a business proce ss from the Enterprise Explor er Pr oject Explorer onto the corresponding Connectivity Map. For[...]

  • Page 109

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 109 Sun M icrosystem s, Inc. 5 Minimize the bpelDelete Binding dialog box by clicking the chevrons in the upper - right corner . 6 Save your curr ent changes to the Repository , and the[...]

  • Page 110

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 110 Sun M icrosystem s, Inc. Figure 60 Envir onment Editor - envJDBCProj 8 Save your curr ent changes to the Repository . 6.6.6 Configur ing the eW ays eW ays facilitate communi cation [...]

  • Page 111

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 111 Sun M icrosystem s, Inc. Configur ing the eW a y P ropert ies Steps required to configure the eW a y proper t ies: 1 Double-click the FileClientIN eW ay on each of the Connectivity [...]

  • Page 112

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 112 Sun M icrosystem s, Inc. 3 From the Environment Explorer tr ee, right-clic k the File External System ( esFileClient in this sample), and select Properties . The Properties Editor o[...]

  • Page 113

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 113 Sun M icrosystem s, Inc. Configur ing the Integrat ion Ser ver Y ou must set your SeeBeyond Integration Se rver Passwor d property before deploying your Project. 1 From the Envir on[...]

  • Page 114

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 114 Sun M icrosystem s, Inc. Figure 62 Deployment Profile 6.6.8 C re a ti ng a nd St arti n g t h e D o ma i n T o build and deploy your Project, you mu st first create a domain. A doma[...]

  • Page 115

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 115 Sun M icrosystem s, Inc. an Existing Domain button. Once your domain is started, a green check mark indicates that the domain is running. Note: For more information about creating a[...]

  • Page 116

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 116 Sun M icrosystem s, Inc. 2 V erify the output data by viewing the sample output files. See About the JDBC eW ay Sample Projects on page 69 for more details on the types of output fi[...]

  • Page 117

    JDBC/ODBC eWay Adapter User’s Guide 117 Sun M icrosystem s, Inc. Appendix A JDBC/ODBC Dr iv ers Drivers are uniquely different in what they do and the type of functions they support. The JDBC/ODBC eW ay allows you to pick and choose which driver is best suited for your application environment. There can be significant differ ences and limitations[...]

  • Page 118

    Appendix A Section A.1 JDBC/ODBC Drivers AS/400 Toolbox Driver JDBC/ODBC eWay Adapter User’s Guide 118 Sun M icrosystem s, Inc. What ’ s In This Chapter:  AS/400 T oolbox Driver on page 1 18  Attunity Driver on page 1 1 9  MySQL Connector/J Driver on page 121  PostgreSQL Driver on page 122  SyBase JConnect Driver on page 124  [...]

  • Page 119

    Appendix A Section A.2 JDBC/ODBC Drivers Attunity Driver JDBC/ODBC eWay Adapter User’s Guide 119 Sun M icrosystem s, Inc. A.1.2 Environment P roper t ies Use T able 25 to configure t he environment pr operties for the specified JDBC/ODBC driver . A.2 Attunit y Driver Configuration P roperties:  OTD W izard: Data base Connection Information on [...]

  • Page 120

    Appendix A Section A.2 JDBC/ODBC Drivers Attunity Driver JDBC/ODBC eWay Adapter User’s Guide 120 Sun M icrosystem s, Inc. A.2.2 Environment P roper t ies Use T able 27 to configure t he environment pr operties for the specified JDBC/ODBC driver . T able 26 Attunity Driver Database Conn ection Information Pa r a m et e r V a lu e Driver Jar F iles[...]

  • Page 121

    Appendix A Section A.3 JDBC/ODBC Drivers MySQL Connector/J Driver JDBC/ODBC eWay Adapter User’s Guide 121 Sun M icrosystem s, Inc. A.3 MySQL Connector/J Dr iv er Configuration P roperties:  OTD W izard: Data base Connection Information on page 121  Environment Properties on page 121 A.3.1 O TD Wizard: Dat abase Connect ion Inf ormat ion T o[...]

  • Page 122

    Appendix A Section A.4 JDBC/ODBC Drivers PostgreSQL Driver JDBC/ODBC eWay Adapter User’s Guide 122 Sun M icrosystem s, Inc. Note: It is not mandatory to enter driver pr operties in the Outbound JDBC eWay Environment pr operties for MySQL. A.4 P ostgreSQL Dr iv er Configuration P roperties:  OTD W izard: Data base Connection Information on page[...]

  • Page 123

    Appendix A Section A.4 JDBC/ODBC Drivers PostgreSQL Driver JDBC/ODBC eWay Adapter User’s Guide 123 Sun M icrosystem s, Inc. A.4.2 Environment P roper t ies Use T able 31 to configure t he environment pr operties for the specified JDBC/ODBC driver . Note: It is not mandatory to enter driver pr operties in the Outbound JDBC eWay Environment pr oper[...]

  • Page 124

    Appendix A Section A.5 JDBC/ODBC Drivers SyBase J Connect Driv er JDBC/ODBC eWay Adapter User’s Guide 124 Sun M icrosystem s, Inc. A.5 SyBase JConnect Dr iver Configuration P roperties:  OTD W izard: Data base Connection Information on page 124  Environment Properties on page 124 A.5.1 O TD Wizard: Dat abase Connect ion Inf ormat ion T o co[...]

  • Page 125

    Appendix A Section A.6 JDBC/ODBC Drivers Sequelink Data Direct In formix ODBC Driver JDBC/ODBC eWay Adapter User’s Guide 125 Sun M icrosystem s, Inc. Note: It is not mandatory to enter driver pr operties in the Outbound JDBC eWay Environment pr operties for Sybase. A.6 Sequelink Dat aDirect Informix ODBC Dr iv er Configuration P roperties:  OT[...]

  • Page 126

    Appendix A Section A.7 JDBC/ODBC Drivers Sequelink DataDi rect MS Access ODBC Driver JDBC/ODBC eWay Adapter User’s Guide 126 Sun M icrosystem s, Inc. A.6.2 Environment P roper t ies Use T able 35 to configure t he environment pr operties for the specified JDBC/ODBC driver . Note: It is not mandatory to enter driver pr operties in the Outbound JDB[...]

  • Page 127

    Appendix A Section A.7 JDBC/ODBC Drivers Sequelink DataDi rect MS Access ODBC Driver JDBC/ODBC eWay Adapter User’s Guide 127 Sun M icrosystem s, Inc. A.7.1 O TD Wizard: Dat abase Connect ion Inf ormat ion T o connect to Microsoft Access , via the Microsoft Access ODBC driver , use the information provided in T able 36 to complete the Connect to D[...]

  • Page 128

    Appendix A Section A.8 JDBC/ODBC Drivers Teradata Driver JDBC/ODBC eWay Adapter User’s Guide 128 Sun M icrosystem s, Inc. Note: It is not mandatory to enter driver pr operties in the Outbound JDBC eWay Environment properties for Sequelink DataDirect MS Access ODBC. A.8 T eradata Dr iv er Configuration P roperties:  OTD W izard: Data base Conne[...]

  • Page 129

    Appendix A Section A.9 JDBC/ODBC Drivers Installing JDBC/ODBC Drivers JDBC/ODBC eWay Adapter User’s Guide 129 Sun M icrosystem s, Inc. A.9 Inst alling JDBC/ODBC Drivers The database driv ers sp ecified in your projects need to be installed on both the Enterprise Designer machine an d the Logi cal host machine. When insta lling the drivers on the [...]

  • Page 130

    Appendix A Section A.10 JDBC/ODBC Drivers Troubles hooting JDBC/ODBC eWay Adapter User’s Guide 130 Sun M icrosystem s, Inc. A.10 T roubleshoot ing Refer to the following when tr oubleshooting Driver issues.  The ReceiveOne operation in BPEL is not supported when using inbound functions with some driver s.  Some drivers do not support Updata[...]

  • Page 131

    Index JDBC/ODBC eWay Adapter User’s Guide 131 Sun M icrosystem s, Inc. Index A activity input and output 57 Add Prepared Statements 52 alert codes, viewing 22 AS/400 Driver 11 8 Attunity Driver 119 Automap 93 , 113 B binding dialog box 88 , 109 BPEL operations 57 Delete 57 Insert 57 ReceiveOne 57 SelectAll 57 SelectMultipl e 57 SelectOne 57 Updat[...]

  • Page 132

    Index JDBC/ODBC eWay Adapter User’s Guide 132 Sun M icrosystem s, Inc. JCD operations 59 delete(String sWhere) 59 deleteRow() 59 insert() 59 insertRow() 59 select(String where) 59 update(Strin g sWhere) 59 updateRow() 59 JDBC driver class 33 , 35 , 38 JDBC eWay Project building and deploying ( BPEL) 95 eInsight and eGate components 72 Importing 7[...]

  • Page 133

    Index JDBC/ODBC eWay Adapter User’s Guide 133 Sun M icrosystem s, Inc. U update count 65[...]