Manuale d’uso / di manutenzione del prodotto eWay JDBC/ODBC Adapter del fabbricante Sun Microsystems
Vai alla pagina of 133
SUN SEEBEY OND eWAY™ JDBC/ODBC ADAPTER USER’S GUIDE Release 5.1.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.
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 B.
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.
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 Sto.
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.
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.
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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 .
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 syst.
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.
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 .
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.
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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 .
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 .
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.
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.
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 .
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 .
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 .
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 .
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 .
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 .
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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 .
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 .
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.
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.
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.
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.
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.
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().
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.
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.
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 .
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.
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.
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.
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.
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).
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 .
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 .
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.
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 .
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.
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.
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.
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.
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.
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 .
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.
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 .
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.
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.
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 .
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.
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.
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 .
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.
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.
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.
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.
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 .
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 sWh.
Index JDBC/ODBC eWay Adapter User’s Guide 133 Sun M icrosystem s, Inc. U update count 65.
Un punto importante, dopo l’acquisto del dispositivo (o anche prima di acquisto) è quello di leggere il manuale. Dobbiamo farlo per diversi motivi semplici:
Se non hai ancora comprato il Sun Microsystems eWay JDBC/ODBC Adapter è un buon momento per familiarizzare con i dati di base del prodotto. Prime consultare le pagine iniziali del manuale d’uso, che si trova al di sopra. Dovresti trovare lì i dati tecnici più importanti del Sun Microsystems eWay JDBC/ODBC Adapter - in questo modo è possibile verificare se l’apparecchio soddisfa le tue esigenze. Esplorando le pagine segenti del manuali d’uso Sun Microsystems eWay JDBC/ODBC Adapter imparerai tutte le caratteristiche del prodotto e le informazioni sul suo funzionamento. Le informazioni sul Sun Microsystems eWay JDBC/ODBC Adapter ti aiuteranno sicuramente a prendere una decisione relativa all’acquisto.
In una situazione in cui hai già il Sun Microsystems eWay JDBC/ODBC Adapter, ma non hai ancora letto il manuale d’uso, dovresti farlo per le ragioni sopra descritte. Saprai quindi se hai correttamente usato le funzioni disponibili, e se hai commesso errori che possono ridurre la durata di vita del Sun Microsystems eWay JDBC/ODBC Adapter.
Tuttavia, uno dei ruoli più importanti per l’utente svolti dal manuale d’uso è quello di aiutare a risolvere i problemi con il Sun Microsystems eWay JDBC/ODBC Adapter. Quasi sempre, ci troverai Troubleshooting, cioè i guasti più frequenti e malfunzionamenti del dispositivo Sun Microsystems eWay JDBC/ODBC Adapter insieme con le istruzioni su come risolverli. Anche se non si riesci a risolvere il problema, il manuale d’uso ti mostrerà il percorso di ulteriori procedimenti – il contatto con il centro servizio clienti o il servizio più vicino.
