Sun Microsystems eWay JDBC/ODBC Adapter manual

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

Ir para a página of

Bom manual de uso

As regras impõem ao revendedor a obrigação de fornecer ao comprador o manual com o produto Sun Microsystems eWay JDBC/ODBC Adapter. A falta de manual ou informações incorretas fornecidas ao consumidor são a base de uma queixa por não conformidade do produto com o contrato. De acordo com a lei, pode anexar o manual em uma outra forma de que em papel, o que é frequentemente utilizado, anexando uma forma gráfica ou manual electrónicoSun Microsystems eWay JDBC/ODBC Adapter vídeos instrutivos para os usuários. A condição é uma forma legível e compreensível.

O que é a instrução?

A palavra vem do latim "Instructio" ou instruir. Portanto, no manual Sun Microsystems eWay JDBC/ODBC Adapter você pode encontrar uma descrição das fases do processo. O objetivo do manual é instruir, facilitar o arranque, a utilização do equipamento ou a execução de determinadas tarefas. O manual é uma coleção de informações sobre o objeto / serviço, um guia.

Infelizmente, pequenos usuários tomam o tempo para ler o manual Sun Microsystems eWay JDBC/ODBC Adapter, e um bom manual não só permite conhecer uma série de funcionalidades adicionais do dispositivo, mas evita a formação da maioria das falhas.

Então, o que deve conter o manual perfeito?

Primeiro, o manual Sun Microsystems eWay JDBC/ODBC Adapter deve conte:
- dados técnicos do dispositivo Sun Microsystems eWay JDBC/ODBC Adapter
- nome do fabricante e ano de fabricação do dispositivo Sun Microsystems eWay JDBC/ODBC Adapter
- instruções de utilização, regulação e manutenção do dispositivo Sun Microsystems eWay JDBC/ODBC Adapter
- sinais de segurança e certificados que comprovam a conformidade com as normas pertinentes

Por que você não ler manuais?

Normalmente, isso é devido à falta de tempo e à certeza quanto à funcionalidade específica do dispositivo adquirido. Infelizmente, a mesma ligação e o arranque Sun Microsystems eWay JDBC/ODBC Adapter não são suficientes. O manual contém uma série de orientações sobre funcionalidades específicas, a segurança, os métodos de manutenção (mesmo sobre produtos que devem ser usados), possíveis defeitos Sun Microsystems eWay JDBC/ODBC Adapter e formas de resolver problemas comuns durante o uso. No final, no manual podemos encontrar as coordenadas do serviço Sun Microsystems na ausência da eficácia das soluções propostas. Atualmente, muito apreciados são manuais na forma de animações interessantes e vídeos de instrução que de uma forma melhor do que o o folheto falam ao usuário. Este tipo de manual é a chance que o usuário percorrer todo o vídeo instrutivo, sem ignorar especificações e descrições técnicas complicadas Sun Microsystems eWay JDBC/ODBC Adapter, como para a versão papel.

Por que ler manuais?

Primeiro de tudo, contem a resposta sobre a construção, as possibilidades do dispositivo Sun Microsystems eWay JDBC/ODBC Adapter, uso dos acessórios individuais e uma gama de informações para desfrutar plenamente todos os recursos e facilidades.

Após a compra bem sucedida de um equipamento / dispositivo, é bom ter um momento para se familiarizar com cada parte do manual Sun Microsystems eWay JDBC/ODBC Adapter. Atualmente, são cuidadosamente preparados e traduzidos para sejam não só compreensíveis para os usuários, mas para cumprir a sua função básica de informação

Índice do manual

  • Página 1

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

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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.[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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.[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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—[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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.[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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." );[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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( [...]

  • Página 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.[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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, [...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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.[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 ,[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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  [...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 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 [...]

  • Página 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[...]

  • Página 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[...]

  • Página 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[...]

  • Página 133

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