Sun Microsystems eWay JDBC/ODBC Adapter manuale d’uso

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. In particular, and with[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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.com[...]

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 [...]

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[...]

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[...]

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 [...]

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. 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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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—[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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.[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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." );[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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( [...]

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().getRATE().toString() ); otdOutputDTD_DBemployee_1.setLastDate( typeConverter.dateToString( otdJD[...]

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[...]

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[...]

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 [...]

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, [...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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. Insert_psPSInsert Activity and the FileClient.write Activity[...]

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[...]

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[...]

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[...]

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[...]

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 ,[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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  [...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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