Deutsch dropdown-ico

Bedienungsanleitung Sun Microsystems JDBC/ODBC Adapter

133 Seiten 2.48 mb
Download

Zur Seite of 133

Summary
  • Sun Microsystems JDBC/ODBC Adapter - page 1

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

  • Sun Microsystems JDBC/ODBC Adapter - page 2

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

  • Sun Microsystems JDBC/ODBC Adapter - page 3

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

  • Sun Microsystems JDBC/ODBC Adapter - page 4

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

  • Sun Microsystems JDBC/ODBC Adapter - page 5

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

  • Sun Microsystems JDBC/ODBC Adapter - page 6

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

  • Sun Microsystems JDBC/ODBC Adapter - page 7

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

  • Sun Microsystems JDBC/ODBC Adapter - page 8

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

  • Sun Microsystems JDBC/ODBC Adapter - page 9

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

  • Sun Microsystems JDBC/ODBC Adapter - page 10

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

  • Sun Microsystems JDBC/ODBC Adapter - page 11

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

  • Sun Microsystems JDBC/ODBC Adapter - page 12

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

  • Sun Microsystems JDBC/ODBC Adapter - page 13

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

  • Sun Microsystems JDBC/ODBC Adapter - page 14

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

  • Sun Microsystems JDBC/ODBC Adapter - page 15

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

  • Sun Microsystems JDBC/ODBC Adapter - page 16

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

  • Sun Microsystems JDBC/ODBC Adapter - page 17

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

  • Sun Microsystems JDBC/ODBC Adapter - page 18

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

  • Sun Microsystems JDBC/ODBC Adapter - page 19

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

  • Sun Microsystems JDBC/ODBC Adapter - page 20

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

  • Sun Microsystems JDBC/ODBC Adapter - page 21

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

  • Sun Microsystems JDBC/ODBC Adapter - page 22

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

  • Sun Microsystems JDBC/ODBC Adapter - page 23

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

  • Sun Microsystems JDBC/ODBC Adapter - page 24

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

  • Sun Microsystems JDBC/ODBC Adapter - page 25

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

  • Sun Microsystems JDBC/ODBC Adapter - page 26

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

  • Sun Microsystems JDBC/ODBC Adapter - page 27

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

  • Sun Microsystems JDBC/ODBC Adapter - page 28

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

  • Sun Microsystems JDBC/ODBC Adapter - page 29

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

  • Sun Microsystems JDBC/ODBC Adapter - page 30

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

  • Sun Microsystems JDBC/ODBC Adapter - page 31

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

  • Sun Microsystems JDBC/ODBC Adapter - page 32

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

  • Sun Microsystems JDBC/ODBC Adapter - page 33

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

  • Sun Microsystems JDBC/ODBC Adapter - page 34

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

  • Sun Microsystems JDBC/ODBC Adapter - page 35

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

  • Sun Microsystems JDBC/ODBC Adapter - page 36

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

  • Sun Microsystems JDBC/ODBC Adapter - page 37

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

  • Sun Microsystems JDBC/ODBC Adapter - page 38

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

  • Sun Microsystems JDBC/ODBC Adapter - page 39

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

  • Sun Microsystems JDBC/ODBC Adapter - page 40

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

  • Sun Microsystems JDBC/ODBC Adapter - page 41

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

  • Sun Microsystems JDBC/ODBC Adapter - page 42

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

  • Sun Microsystems JDBC/ODBC Adapter - page 43

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

  • Sun Microsystems JDBC/ODBC Adapter - page 44

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

  • Sun Microsystems JDBC/ODBC Adapter - page 45

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

  • Sun Microsystems JDBC/ODBC Adapter - page 46

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

  • Sun Microsystems JDBC/ODBC Adapter - page 47

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

  • Sun Microsystems JDBC/ODBC Adapter - page 48

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

  • Sun Microsystems JDBC/ODBC Adapter - page 49

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

  • Sun Microsystems JDBC/ODBC Adapter - page 50

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

  • Sun Microsystems JDBC/ODBC Adapter - page 51

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

  • Sun Microsystems JDBC/ODBC Adapter - page 52

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

  • Sun Microsystems JDBC/ODBC Adapter - page 53

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

  • Sun Microsystems JDBC/ODBC Adapter - page 54

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

  • Sun Microsystems JDBC/ODBC Adapter - page 55

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

  • Sun Microsystems JDBC/ODBC Adapter - page 56

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

  • Sun Microsystems JDBC/ODBC Adapter - page 57

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

  • Sun Microsystems JDBC/ODBC Adapter - page 58

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

  • Sun Microsystems JDBC/ODBC Adapter - page 59

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

  • Sun Microsystems JDBC/ODBC Adapter - page 60

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

  • Sun Microsystems JDBC/ODBC Adapter - page 61

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

  • Sun Microsystems JDBC/ODBC Adapter - page 62

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

  • Sun Microsystems JDBC/ODBC Adapter - page 63

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

  • Sun Microsystems JDBC/ODBC Adapter - page 64

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

  • Sun Microsystems JDBC/ODBC Adapter - page 65

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

  • Sun Microsystems JDBC/ODBC Adapter - page 66

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

  • Sun Microsystems JDBC/ODBC Adapter - page 67

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

  • Sun Microsystems JDBC/ODBC Adapter - page 68

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

  • Sun Microsystems JDBC/ODBC Adapter - page 69

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

  • Sun Microsystems JDBC/ODBC Adapter - page 70

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

  • Sun Microsystems JDBC/ODBC Adapter - page 71

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

  • Sun Microsystems JDBC/ODBC Adapter - page 72

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

  • Sun Microsystems JDBC/ODBC Adapter - page 73

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

  • Sun Microsystems JDBC/ODBC Adapter - page 74

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

  • Sun Microsystems JDBC/ODBC Adapter - page 75

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

  • Sun Microsystems JDBC/ODBC Adapter - page 76

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

  • Sun Microsystems JDBC/ODBC Adapter - page 77

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

  • Sun Microsystems JDBC/ODBC Adapter - page 78

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

  • Sun Microsystems JDBC/ODBC Adapter - page 79

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

  • Sun Microsystems JDBC/ODBC Adapter - page 80

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

  • Sun Microsystems JDBC/ODBC Adapter - page 81

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

  • Sun Microsystems JDBC/ODBC Adapter - page 82

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

  • Sun Microsystems JDBC/ODBC Adapter - page 83

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

  • Sun Microsystems JDBC/ODBC Adapter - page 84

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

  • Sun Microsystems JDBC/ODBC Adapter - page 85

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

  • Sun Microsystems JDBC/ODBC Adapter - page 86

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

  • Sun Microsystems JDBC/ODBC Adapter - page 87

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

  • Sun Microsystems JDBC/ODBC Adapter - page 88

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

  • Sun Microsystems JDBC/ODBC Adapter - page 89

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

  • Sun Microsystems JDBC/ODBC Adapter - page 90

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

  • Sun Microsystems JDBC/ODBC Adapter - page 91

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

  • Sun Microsystems JDBC/ODBC Adapter - page 92

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

  • Sun Microsystems JDBC/ODBC Adapter - page 93

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

  • Sun Microsystems JDBC/ODBC Adapter - page 94

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

  • Sun Microsystems JDBC/ODBC Adapter - page 95

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

  • Sun Microsystems JDBC/ODBC Adapter - page 96

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

  • Sun Microsystems JDBC/ODBC Adapter - page 97

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

  • Sun Microsystems JDBC/ODBC Adapter - page 98

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

  • Sun Microsystems JDBC/ODBC Adapter - page 99

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

  • Sun Microsystems JDBC/ODBC Adapter - page 100

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 100 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 101

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 101 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 102

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 102 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 103

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 103 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 104

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 104 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 105

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

  • Sun Microsystems JDBC/ODBC Adapter - page 106

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

  • Sun Microsystems JDBC/ODBC Adapter - page 107

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 107 Sun Microsys tems, 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 cr ...

  • Sun Microsystems JDBC/ODBC Adapter - page 108

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 108 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 109

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 109 Sun Microsys tems, 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 then ...

  • Sun Microsystems JDBC/ODBC Adapter - page 110

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 110 Sun Microsys tems, 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 a ...

  • Sun Microsystems JDBC/ODBC Adapter - page 111

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 111 Sun Microsys tems, 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 M ...

  • Sun Microsystems JDBC/ODBC Adapter - page 112

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 112 Sun Microsys tems, 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 op ...

  • Sun Microsystems JDBC/ODBC Adapter - page 113

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 113 Sun Microsys tems, 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 onm ...

  • Sun Microsystems JDBC/ODBC Adapter - page 114

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 114 Sun Microsys tems, 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 domai ...

  • Sun Microsystems JDBC/ODBC Adapter - page 115

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 115 Sun Microsys tems, 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 an ...

  • Sun Microsystems JDBC/ODBC Adapter - page 116

    Chapter 6 Section 6.6 Implementing the JDBC/ODBC eWay Sample Projects Build ing and Deploying the prjJDBC_B PEL Sample Project JDBC/ODBC eWay Adapter User’s Guide 116 Sun Microsys tems, 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 fil ...

  • Sun Microsystems JDBC/ODBC Adapter - page 117

    JDBC/ODBC eWay Adapter User’s Guide 117 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 118

    Appendix A Section A.1 JDBC/ODBC Drivers AS/400 Toolbox Driver JDBC/ODBC eWay Adapter User’s Guide 118 Sun Microsys tems, 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  S ...

  • Sun Microsystems JDBC/ODBC Adapter - page 119

    Appendix A Section A.2 JDBC/ODBC Drivers Attunity Driver JDBC/ODBC eWay Adapter User’s Guide 119 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 120

    Appendix A Section A.2 JDBC/ODBC Drivers Attunity Driver JDBC/ODBC eWay Adapter User’s Guide 120 Sun Microsys tems, 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 l ue Driver Jar F iles ...

  • Sun Microsystems JDBC/ODBC Adapter - page 121

    Appendix A Section A.3 JDBC/ODBC Drivers MySQL Connector/J Driver JDBC/ODBC eWay Adapter User’s Guide 121 Sun Microsys tems, 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 Informat ion T o c ...

  • Sun Microsystems JDBC/ODBC Adapter - page 122

    Appendix A Section A.4 JDBC/ODBC Drivers PostgreSQL Driver JDBC/ODBC eWay Adapter User’s Guide 122 Sun Microsys tems, 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 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 123

    Appendix A Section A.4 JDBC/ODBC Drivers PostgreSQL Driver JDBC/ODBC eWay Adapter User’s Guide 123 Sun Microsys tems, 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 opert ...

  • Sun Microsystems JDBC/ODBC Adapter - page 124

    Appendix A Section A.5 JDBC/ODBC Drivers SyBase J Connect Driv er JDBC/ODBC eWay Adapter User’s Guide 124 Sun Microsys tems, 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 Informat ion T o conn ...

  • Sun Microsystems JDBC/ODBC Adapter - page 125

    Appendix A Section A.6 JDBC/ODBC Drivers Sequelink Data Direct In formix ODBC Driver JDBC/ODBC eWay Adapter User’s Guide 125 Sun Microsys tems, 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:  OTD ...

  • Sun Microsystems JDBC/ODBC Adapter - page 126

    Appendix A Section A.7 JDBC/ODBC Drivers Sequelink DataDi rect MS Access ODBC Driver JDBC/ODBC eWay Adapter User’s Guide 126 Sun Microsys tems, 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 JDBC ...

  • Sun Microsystems JDBC/ODBC Adapter - page 127

    Appendix A Section A.7 JDBC/ODBC Drivers Sequelink DataDi rect MS Access ODBC Driver JDBC/ODBC eWay Adapter User’s Guide 127 Sun Microsys tems, Inc. A.7.1 O TD Wizard: Dat abase Connect ion Informat 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 Dat ...

  • Sun Microsystems JDBC/ODBC Adapter - page 128

    Appendix A Section A.8 JDBC/ODBC Drivers Teradata Driver JDBC/ODBC eWay Adapter User’s Guide 128 Sun Microsys tems, 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 Connec ...

  • Sun Microsystems JDBC/ODBC Adapter - page 129

    Appendix A Section A.9 JDBC/ODBC Drivers Installing JDBC/ODBC Drivers JDBC/ODBC eWay Adapter User’s Guide 129 Sun Microsys tems, 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 E ...

  • Sun Microsystems JDBC/ODBC Adapter - page 130

    Appendix A Section A.10 JDBC/ODBC Drivers Troubles hooting JDBC/ODBC eWay Adapter User’s Guide 130 Sun Microsys tems, 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 Updatab ...

  • Sun Microsystems JDBC/ODBC Adapter - page 131

    Index JDBC/ODBC eWay Adapter User’s Guide 131 Sun Microsys tems, 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 Update ...

  • Sun Microsystems JDBC/ODBC Adapter - page 132

    Index JDBC/ODBC eWay Adapter User’s Guide 132 Sun Microsys tems, 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 73 ...

  • Sun Microsystems JDBC/ODBC Adapter - page 133

    Index JDBC/ODBC eWay Adapter User’s Guide 133 Sun Microsys tems, Inc. U update count 65 ...

Produzent Sun Microsystems Kategorie Network Card

Dokumente, die wir vom Produzenten des Geräts Sun Microsystems JDBC/ODBC Adapter erhalten, können wir in mehrere Gruppen teilen. Unteranderem in:
- technische Zeichnungen Sun Microsystems
- Bedienungsanleitungen JDBC/ODBC Adapter
- Produktkarten Sun Microsystems
- Informationsbroschüren
- oder Energieetiketten Sun Microsystems JDBC/ODBC Adapter
Jede von ihnen ist wichtig, jedoch finden wir die wichtigsten Informationen für den Nutzer des Geräts in der Bedienungsanleitung Sun Microsystems JDBC/ODBC Adapter.

Die Dokumentengruppe, die als Bedienungsanleitungen bezeichnet wird, wird ebenfalls in detaillierte Arten geteilt, solche wie: Montageanleitungen Sun Microsystems JDBC/ODBC Adapter, Wartungsanleitungen, Kurzanleitungen oder Benutzeranleitungen Sun Microsystems JDBC/ODBC Adapter. Abhängig vom Bedarf, sollten Sie das Dokument finden, das Sie brauchen. In unserem Service können Sie sich die populärste Bedienungsanleitung des Produkts Sun Microsystems JDBC/ODBC Adapter ansehen.

Ähnliche Bedienungsanleitungen

Die komplette Bedienungsanleitung des Geräts Sun Microsystems JDBC/ODBC Adapter, wie sollte sie aussehen?
Die Bedienungsanleitung, auch bezeichnet als Benutzerhandbuch, oder einfach nur „Anleitung”, ist ein technisches Dokument, das dem Benutzer bei der Nutzung von Sun Microsystems JDBC/ODBC Adapter hilfreich sein soll. Die Bedienungsanleitungen werden in der Regel von technischen Schriftstellern geschrieben, aber in einer Sprache, die für alle Nutzer von Sun Microsystems JDBC/ODBC Adapter verständlich ist.

Eine gänzliche Bedienungsanleitung von Sun Microsystems sollte einige Grundelemente enthalten. Ein Teil von ihnen ist nicht so wichtig, wie z.B.: die Titelseite oder Autorenseiten. Die restlichen von ihnen jedoch, sollten Informationen liefern, die für den Nutzer von enormer Wichtigkeit sind.

1. Einführung und Hinweise, wie man sich in einer Bedienungsanleitung von Sun Microsystems JDBC/ODBC Adapter bewegt - Am Anfang jeder Bedienungsanleitung sollten wir Hinweise bezüglich der Nutzungsart eines bestimmten Ratgebers finden. In ihr sollten sich Informationen über die Lokalisierung des Inhaltsverzeichnisses von Sun Microsystems JDBC/ODBC Adapter befinden, FAQ oder über oft auftretende Probleme – also Stellen, die von den Benutzern in jeder Bedienungsanleitung am meisten gesucht werden
2. Inhaltsverzeichnis - Index aller Ratschläge bezüglich Sun Microsystems JDBC/ODBC Adapter, die wir im aktuellen Dokument finden
3. Ratschläge zur Nutzung der Grundfunktionen des Geräts Sun Microsystems JDBC/ODBC Adapter - die uns die ersten Schritte während der Nutzung von Sun Microsystems JDBC/ODBC Adapter erleichtern sollten
4. Troubleshooting - geordneter Tätigkeitslauf, der uns bei der Diagnose und als nächstes bei der Lösung wichtiger Probleme mit Sun Microsystems JDBC/ODBC Adapter hilft
5. FAQ - häufig gestellte Fragen
6. Kontaktdaten Informationen darüber, wo man Kontakt zum Produzenten / Service von Sun Microsystems JDBC/ODBC Adapter im bestimmten Land suchen kann, wenn es nicht gelingt, das Problem selbst zu lösen.

Haben Sie eine Frage bezüglich Sun Microsystems JDBC/ODBC Adapter?

Nutzen Sie das untere Formular

Wenn Sie mit Hilfe der gefundenen Bedienungsanleitung Ihr Problem mit Sun Microsystems JDBC/ODBC Adapter nicht gelöst haben, stellen Sie eine Frage, indem Sie das untere Formular nutzen. Wenn einer der Nutzer ein ähnliches Problem mit Sun Microsystems JDBC/ODBC Adapter hatte, ist es möglich, dass er mit Ihnen die Lösung teilen möchte.

Text vom Bild übertragen

Captcha
Neues Bild

Kommentare (0)