Sun Microsystems SUN SEEBEYOND eWAY Page 60 User Manual Download

Page: 60 / 115

Chapter 6

Section 6.2

Using VSAM Operations

VSAM eWay Database Operations (JCD)

VSAM eWay Adapter User’s Guide

Sun Microsytems, Inc.

getPrepStatement().getPreparedStatementTest().addBatch();
getPrepStatement().getPreparedStatementTest().executeBatch();

Summary of Contents for SUN SEEBEYOND eWAY

Page 1: ...SUN SEEBEYOND eWAY ADAPTER FOR VSAM USER S GUIDE Release 5 1 3 ...

Page 2: ...is Tous droits réservés Sun Microsystems Inc détient les droits de propriété intellectuels relatifs à la technologie incorporée dans le produit qui est décrit dans ce document En particulier et ce sans limitation ces droits de propriété intellectuels peuvent inclure un ou plus des brevets américains listés à l adresse http www sun com patents et un ou les brevets supplémentaires ou les application...

Page 3: ...s Inc Web Site 11 Documentation Feedback 11 Chapter 2 Installing the VSAM eWay 12 Installing the VSAM eWay 12 Installing the VSAM eWay on an eGate supported system 13 Adding the eWay to an Existing Sun Java Composite Application Platform Suite Installation 13 Copying JAR files to the eDesigner Library 14 Installing Third Party Products 14 After Installation 14 Extracting the Sample Projects and Ja...

Page 4: ...Way Properties 26 Outbound VSAM CP eWay Properties 26 JDBC Connector Settings 27 Connection Retry Settings 29 Outbound VSAM non Transactional eWay Properties 30 JDBC Connector Settings 30 Connection Retry Settings 32 Chapter 4 Using the VSAM eWay Database Wizard 34 About the Database OTD Wizard 34 Creating a New VSAM OTD 34 Select Wizard Type 35 Connect To Database 35 Select Database Objects 36 Se...

Page 5: ...g Operations in BPEL 63 About the eInsight Engine and eGate Components 63 Running the Sample Projects 64 Running the SQL Script 64 Importing a Sample Project 65 Building and Deploying the prjVSAM_BPEL Sample Project 65 Creating a Project 66 Creating the OTDs 66 Creating the Business Process 67 Creating the Business Process Flow 67 Configuring the bpInsert Modeling Elements 68 Configuring the bpUpd...

Page 6: ...96 jcdPsSelect Collaboration 97 jcdTableSelect Collaboration 97 jcdUpdate Collaboration 98 Create the Collaboration Business Rules 98 Creating the jcdDelete Business Rules 98 Creating the jcdInsert Business Rules 99 Creating the jcdPsSelect Business Rules 100 Creating the jcdTableSelect Business Rules 102 Creating the jcdUpdate Business Rules 104 Binding the eWay Components 105 Creating an Environ...

Page 7: ...ion Feedback on page 11 1 1 About VSAM Virtual Storage Access Method VSAM is one of several access methods that defines the technique by which data is stored and retrieved It is a GET PUT interface used to transfer data from a direct access storage device DASD to an application program VSAM does not support data stored on tape VSAM stores data as a collection of data sets IBM uses a collection of ...

Page 8: ...m via TCP IP The eWay utilizes an IBM WebSphere Information Integrator Classic Federatione component that allows you to view and access VSAM in the same way as any standard relational database system For details on operating and using eGate and its user interface the Enterprise Designer see the Sun SeeBeyond eGate Integrator User s Guide 1 3 What s New in This Release The Sun SeeBeyond eWay Adapte...

Page 9: ...e Sun SeeBeyond eGate Integrator User s Guide or the Sun SeeBeyond eGate Integrator System Administration Guide 1 4 About This Document This document includes the following chapters Chapter 1 Introducing the VSAM eWay Provides an overview description of the product as well as high level information about this document Chapter 2 Installing the VSAM eWay Describes the system requirements and provide...

Page 10: ...ication Platform Suite system This person must also understand any operating systems on which the Java Composite Application Platform Suite will be installed Windows and UNIX and must be thoroughly familiar with Windows style GUI operations 1 4 3 Text Conventions The following conventions are observed throughout this document 1 5 Related Documents The following Sun documents provide additional inf...

Page 11: ...1 6 Sun Microsystems Inc Web Site The Sun Microsystems web site is your best source for up to the minute product news and technical support information The site s URL is http www sun com 1 7 Documentation Feedback We appreciate your feedback Please send any comments or suggestions regarding this document to CAPS_docsfeedback sun com ...

Page 12: ... during the installation process The following section describes how to install the components required for this eWay Refer to the readme for the latest information on Supported Operating Systems System Requirements External System Requirements The VSAM eWay Readme is uploaded with the eWay s documentation file VSAMeWayDocs sar and can be accessed from the Documentation tab of the Sun Java Composi...

Page 13: ...ts to Install box 5 From the Selecting Files to Install box locate and select your first product s SAR file ONce you have selected the SAR file click Next Your next selected product appears Follow this procedure for each of your selected products The Installation Status window appears and installation begins after the last SAR file has been selected 6 Once your product s installation is finished c...

Page 14: ...Federation see the IBM WebSphere Information Integrator Installation Guide for Classic Federation and Classic Event Important When you install the Classic Federation be sure to configure the properties for VSAM See the appropriate Federation documentation for details After Installation Once you install the eWay it must then be incorporated into a Project before it can perform its intended function...

Page 15: ...rt your Projects save your current ICAN 5 0 x Projects to your Repository 2 From the Project Explorer right click your Project and select Export from the shortcut menu The Export Manager appears 3 Select the Project that you want to export in the left pane of the Export Manager and move it to the Selected Projects field by clicking the Add to Select Items arrow button or click All to include all o...

Page 16: ...oject Explorer and the Environment Explorer To check out all of the Project s components do the following A From the Project Explorer right click the Project and select Version Control Check Out from the shortcut menu The Version Control Check Out dialog box appears B Select Recurse Project to specify all components and click OK C Select the Environment Explorer tab and from the Environment Explor...

Page 17: ... to the Auto Install from Repository sub tab and connect to your Repository 3 Select the application plug ins you require and click Install The application plug ins are installed and deployed To add plug ins from the Sun Java Composite Application Platform Suite Installer 1 From the Sun Java Composite Application Platform Suite Installer s Downloads tab select the Plug Ins you require and save the...

Page 18: ...ation failed because of a database connection error Reason 0 Occurs while retrieving a connection from the database or the connection pool Verify that the database has not terminated with unexpected errors DBCOMMON CONNECT FAILED000005 Connection handle not usable Reason 0 The connection in the pool is stale and is not usable Probably a database restart occurred causing the connection to be stale ...

Page 19: ...rt codes and logs see the Sun SeeBeyond eGate Integrator System Administration Guide DBCOMMON XAEND FAILED000001 XAEnd failed Reason 0 Error occurred during commit on XA connection Look for the detailed error mentioned in the alert for the appropriate action DBCOMMON CANNOT GET ISOLATION LEVEL Unable to get isolationLevel for the transaction Reason 0 Could not read transaction isolation informatio...

Page 20: ... Map These parameters most commonly apply to a specific component eWay and may vary from other eWays of the same type in the Project Environment Explorer These parameters are commonly global applying to all eWays of the same type in the Project The saved properties are shared by all eWays in the VSAM External System window Collaboration or Business Process VSAM eWay properties may also be set from...

Page 21: ...t and click OK Figure 2 Template window The choices to make are as follows VSAM CP eWay Also referred to as LocalTransaction this support level is opposite to NoTransaction and this means that the transaction when The Properties window opens displaying the default properties for the eWay Outbound VSAM non Transactional eWay Also referred to as NoTransaction this support level indicates that the Co...

Page 22: ...to be inserted into a table If the last record fails to insert such as when a duplicate key exists all previous records will have been inserted This is the behavior of NoTransaction support In 5 1 3 five new records are to be inserted into a table If one of the records fails to insert such as when a duplicate key exists the other four records will not be inserted This is the behavior of the LocalT...

Page 23: ...ay configure the type of External System required Available External System properties include Inbound VSAM eWay Outbound VSAM CP eWay Outbound VSAM non Transactional eWay To Configure the Environment Properties 1 In Enterprise Explorer click the Environment Explorer tab 2 Expand the Environment created for the VSAM Project and locate the VSAM External System Note For more information on creating ...

Page 24: ...uration properties for that section 5 Click on any property field to make it editable After modifying the configuration properties click OK to save the changes 3 4 eWay Connectivity Map Properties The eWay Connectivity Map consists of the following properties categories Outbound eWay Connectivity Map Outbound CP eWay Properties on page 25 Outbound non Transactional eWay Connectivity Map Outbound n...

Page 25: ...actional mode cannot be used in XA two phase commit transactions The Outbound non Transactional eWay Properties listed in Table 4 include inbound parameters used by the external database Table 3 Outbound eWay JDBC Connector Settings Name Description Required Value Description VSAM Connection Pool Datasource A valid string ClassName Displays the Java class in the JDBC driver that is used to impleme...

Page 26: ... Inbound VSAM eWay includes the following configuration section Parameter Settings Details for the Inbound VSAM eWay Parameter Settings are listed in Table 5 3 5 2 Outbound VSAM CP eWay Properties The Outbound VSAM CP eWay includes the following configuration sections JDBC Connector Settings Connection Retry Settings Table 5 Inbound VSAM eWay Parameter Settings Name Description Required Value Desc...

Page 27: ...on The description of the database A valid string The configured default is VSAM Connection Pool Datasource ServerName This setting specifies the host name of the external database server Any valid string PortNumber Specifies the I O port number on which the server is listening for connection requests A valid port number DatabaseName Specifies the name of the database instance Any valid string Use...

Page 28: ...method name 2 param 1 param 2 param n For example to execute the method setSpyAttributes give the method a String for the URL setSpyAttribute url Note The setSpyAttributes for Data Direct drivers that are contained in the following examples between the last set of double octothorps within each example are used for debugging purposes and need not be used on every occasion Optional if you are using ...

Page 29: ...l connection which is faster A valid numeric value The default is 0 MaxPoolSize Specifies the maximum number of physical connections the pool should keep available at all times 0 zero indicates that there is no maximum If the pool size is too big you may end up with too many connections with the database The pool size depends on the transaction volume and response time A valid numeric value The de...

Page 30: ... to reconnect to the database 10 times in 5 seconds apart when the Connection Retries is 10 and the Connection Retry Interval is 5000 A valid numeric value The default is 1000 Table 8 VSAM non Transactional eWay JDBC Connector Settings Name Description Required Value Description The description of the database A valid string The configured default is VSAM non Transactional Connection Pool Datasour...

Page 31: ...name 2 param 1 param 2 param n For example to execute the method setSpyAttributes give the method a String for the URL setSpyAttribute url Note The setSpyAttributes for Data Direct drivers that are contained in the following examples between the last set of double octothorps within each example are used for debugging purposes and need not be used on every occasion Optional if you are using Spy Log...

Page 32: ...tion which is faster A valid numeric value The default is 0 MaxPoolSize Specifies the maximum number of physical connections the pool should keep available at all times 0 zero indicates that there is no maximum If the pool size is too big you may end up with too many connections with the database The pool size depends on the transaction volume and response time A valid numeric value The default is...

Page 33: ...base This setting is used in conjunction with the Connection Retries setting For example In the event that the eWay cannot connect to the Database the eWay will try to reconnect to the database 10 times in 5 seconds apart when the Connection Retries is 10 and the Connection Retry Interval is 5000 A valid numeric value The default is 1000 Table 9 VSAM non Transactional eWay Connection Retry Setting...

Page 34: ...dures or Prepared Statements Field nodes are added to the OTD based on the Tables in the external data source Java method and parameter nodes are added to provide the appropriate JDBC functionality For more information about the Java methods refer to your JDBC developer s reference The OTD Wizard allows the addition and removal of columns nodes in an OTD Nodes with the same name and type as existi...

Page 35: ...equired to build an OTD in the New Object Type Definition Wizard Steps Required to Select the VSAM Database OTD Wizard Include 1 On the Project Explorer tree right click the Project and select New Object Type Definition from the shortcut menu The Select Wizard Type page appears displaying the available OTD wizards 2 From the New Object Type Definition Wizard window select the VSAM Database and cli...

Page 36: ...r name a valid VSAM database username Password a password for the user name noted above Figure 6 Database Connection Information 4 2 3 Select Database Objects Select the type of VSAM database objects you want included in the OTD Steps Required to Select Database Objects Include 1 When selecting Database Objects you can select any combination of Tables Views or Prepared Statements you would like to...

Page 37: ...crosystems Inc Figure 7 Select Database Objects 4 2 4 Select Tables Views Aliases Select the types of tables or views required in the OTD Note Aliases are not supported in the current release of the VSAM eWay Steps Required to Select Table and Views Include 1 In the Select Tables Views Aliases window click Add See Figure 8 ...

Page 38: ... Guide 38 Sun Microsystems Inc Figure 8 Select Tables Views Aliases 2 In the Add Tables window select if your selection criteria will include table data view only data both and or system tables 3 From the Table View Name drop down list select the location of your database table and click Search See Figure 9 ...

Page 39: ... Wizard Creating a New VSAM OTD VSAM eWay Adapter User s Guide 39 Sun Microsystems Inc Figure 9 Database Wizard All Schemes 4 Select the table of choice and click OK The table selected is added to the Selected Tables Views Aliases section See Figure 10 ...

Page 40: ... not wish to make any additional changes click Next to continue 6 In the Table View Columns window you can select or deselect your table columns You can also change the data type for each table by highlighting the data type and selecting a different one from the drop down list If you would like to change any of the tables columns click Change See Figure 11 The data type is usually listed as Other ...

Page 41: ...tems Inc Figure 11 Table View Columns 7 Click Advanced to change the data type percision length or scale Once you have finished your table choices click OK In general you will not need to make any changes See Figure 12 Figure 12 Table View Columns Advanced 4 2 5 Add Prepared Statement Add a Prepared Statement object to your OTD ...

Page 42: ...te loop at runtime and will stop all of the system s CPU If it is used it should only be used with the if statement 1 On the Add Prepared Statements window click Add Figure 13 Prepared Statement 2 Enter the name of a Prepared Statement or create a SQL statement by clicking in the SQL Statement window If you are not logging into the VSAM database with the default user name you must enter the Table ...

Page 43: ...ent appears To edit the parameters click Edit Parameters You can change the datatype by clicking in the Type field and selecting a different type from the list 4 Click Add if you want to add additional parameters to the Statement or highlight a row and click Remove to remove it Click OK Figure 15 Figure 15 Edit the Prepared Statement Parameters 5 To edit Resultset Columns click Edit Resultset Colu...

Page 44: ... ResultSet column Both the Name and Type are editable 7 Click OK to return to the Add Prepared Statements window 4 2 6 Specify the OTD Name Specify the name that your OTD will display in the Enterprise Designer Project Explorer Steps Required to Specify the OTD Name 1 Enter a name for the OTD The OTD contains the selected tables and the package name of the generated classes See Figure 17 ...

Page 45: ...view Selections Review the selections made for the new OTD Steps Required to Review Your OTD Selections 1 View the summary of the OTD If you find you have made a mistake click Back and correct the information 2 If you are satisfied with the OTD information click Finish to begin generating the OTD See Figure 18 The resulting OTD appears on the Enterprise Designer s Project Explorer ...

Page 46: ...r User s Guide 46 Sun Microsystems Inc Figure 18 Database Wizard Summary 4 3 Resulting OTD The resulting VSAM OTD appears on the Enterprise Designer s canvas in the OTD Editor window See Figure 19 In the example a node in the OTD has been expanded allowing you to view some of its structure ...

Page 47: ...er Steps to Edit the OTD from the Enterprise Designer Include 1 Unlock the OTD To do this right click the OTD in the Project Explorer and select Version Control Check Out from the menu The Version Control Check Out window appears 2 Select the OTD you want to check out then click Check Out 3 From the Project Explorer right click the OTD again and select Edit from the menu The VSAMDatabase Connectio...

Page 48: ...48 Sun Microsystems Inc 5 Step through each of the wizard steps and click Finish to save your changes Note You must verify during project activation or at runtime that no errors are generated after editing an OTD Errors could occur if you delete a database object such as a table or column that is included in a Collaboration ...

Page 49: ...ods with Tables table OTD Views view OTD Prepared statements prepared statement OTD Views are read only and for informational purposes only Use the OTD wizard see Chapter 4 to create the VSAM Database OTDs User defined OTD You can use the OTD wizard to create an eGate User defined OTD See the eGate Integrator User s Guide for a complete explanation of how to create a User defined OTD 5 2 Using Tab...

Page 50: ...setConcurrencytoUpdatable setConcurrentlytoReadOnly setScrollTypetoForwardOnly setScrollTypetoScrollSensitive setScrollTypetoInsensitive Note Because of driver limitations before you can do any modifications insert update or delete to a table the table must be under CICS control on the mainframe To call a method in the Collaboration Editor Java 1 Open the eGate Enterprise Designer s Collaboration ...

Page 51: ...fields of the table OTD where you want to do the insertion and insert the row using a Literal If you want to update multiple columns you can repeat the Copy rule as desired 3 Activate the insertion by calling the insertRow method For multiple insert operations you can use a while rule 5 2 4 Update Operations To perform an update operation on a table 1 From the Collaboration Editor Java call the up...

Page 52: ...ed select update insert or delete operation in which you want the statement to be used Note When using a Prepared Statement the ResultsAvailable method will always return true Although this method is available you should not use it with a while loop Doing so would result in an infinite loop at runtime and will stop all of the system s CPU If it is used it should only be used with the if statement ...

Page 53: ...M database Within a BPEL business process the VSAM eWay uses BPEL Activities to perform basic outbound database operations including Insert Update Delete SelectOne SelectMultiple SelectAll In addition to these outbound operations the VSAM eWay also employs the inbound Activity ReceiveOne within a Prepared Statement OTD 6 1 1 Activity Input and Output The Sun SeeBeyond Enterprise Designer Business ...

Page 54: ...tput SelectAll where clause optional Returns all rows that fit the condition of the where clause SelectMultiple number of rows where clause optional Returns the number of rows specified that fit the condition of the where clause and the number of rows to be returned For example If the number of rows that meet the condition are 5 and the number of available rows are 10 then only 5 rows will be retu...

Page 55: ... a table while methods are the operations that you can apply to the OTD This allows you to perform query update insert and delete SQL operations in a table The ability to update via a resultset is called Updatable Resultset which is a feature supported by this eWay By default the Table OTD has UpdatableConcurrency and ScrollTypeForwardOnly Normally you do not have to change the default setting The...

Page 56: ...Emp otdOutputDTD_Emp_1 com stc connector appconn file FileApplication FileClient_1 throws Throwable FileClient_1 setText Selecting record s from CICSEMP table via table select FileClient_1 write otdVSAM_1 getCICSEMP select input getText while otdVSAM_1 getCICSEMP next otdOutputDTD_Emp_1 setENAME otdVSAM_1 getCICSEMP getENAME otdOutputDTD_Emp_1 setPHONE typeConverter intToString otdVSAM_1 getCICSEM...

Page 57: ...nserting records into CICSEMP table FileClient_1 write otdInputDTD_Emp_1 unmarshalFromString input getText otdVSAM_1 getCICSEMP insert for int i1 0 i1 otdInputDTD_Emp_1 countX_sequence_A i1 1 otdVSAM_1 getCICSEMP setENAME otdInputDTD_Emp_1 getX_sequence_A i1 getENAME otdVSAM_1 getCICSEMP setPHONE typeConverter stringToInt otdInputDTD_Emp_1 getX_sequence_A i1 getPHONE false 0 otdVSAM_1 getCICSEMP s...

Page 58: ...ter public com stc codegen util CollaborationContext collabContext public com stc codegen util TypeConverter typeConverter public void receive com stc connector appconn file FileTextMessage input otdVSAM OtdVSAMOTD otdVSAM_1 dtd otdOutputDTD_1935483687 Emp otdOutputDTD_Emp_1 com stc connector appconn file FileApplication FileClient_1 throws Throwable FileClient_1 setText Update the Department File...

Page 59: ...ement uses a question mark as a place holder for input For example insert into EMP_TAB Age Name Dept No value To execute a prepared statement set the input parameters and call executeUpdate and specify the input values if any getPrepStatement getPreparedStatementTest setAge 23 getPrepStatement getPreparedStatementTest setName Peter Pan getPrepStatement getPreparedStatementTest setDeptNo 6 getPrepS...

Page 60: ...6 2 Using VSAM Operations VSAM eWay Database Operations JCD VSAM eWay Adapter User s Guide 60 Sun Microsytems Inc getPrepStatement getPreparedStatementTest addBatch getPrepStatement getPreparedStatementTest executeBatch ...

Page 61: ...mple Projects on page 61 Running the Sample Projects on page 64 Running the SQL Script on page 64 Importing a Sample Project on page 65 Building and Deploying the prjVSAM_BPEL Sample Project on page 65 Building and Deploying the prjVSAM_JCD Sample Project on page 92 7 1 About the VSAM eWay Sample Projects The VSAM eWay VSAM_eWay_Sample zip file contains two sample Projects that provide basic instr...

Page 62: ...s include TriggerDelete in in TriggerInsert in in for JCE projects only TriggerBpInsert in in for BPEL projects only TriggerPsSelect in in TriggerTableSelect in in TriggerUpdate in in Sample output JCD files include JCD_Delete_output0 dat JCD_Insert_output0 dat JCD_PsSelect_output0 dat JCD_TableSelect_output0 dat JCD_Update_output0 dat Sample output BPEL files include BPEL_Delete_output0 dat BPEL_...

Page 63: ...th an icon identifying the component that is the basis for the Activity At run time the eInsight engine invokes each step in the order that you defined in the Business Process Using the engine s Web Services interface the Activity in turn invokes the eWay You can open a file specified in the eWay and view its contents before and after the Business Process is executed Note Inbound database eWays ar...

Page 64: ...rt a domain Deploy the Project 4 Check the output 7 3 Running the SQL Script The data used for both the JCD and BPEL sample Projects are contained within a table called CICSEMP You create this table by using the SQL statement VSAM_sample_script sql that is included in the sample Project Note that you must use a database tool to run the script Following is the SQL statement designed for the sample ...

Page 65: ...e Enterprise Designer s Project Explorer pane right click the Repository and select Import Project from the shortcut menu The Import Manager appears 3 Browse to the directory that contains the sample Project ZIP file Select the sample file and click Import 4 Click Close after successfully importing the sample Project 7 5 Building and Deploying the prjVSAM_BPEL Sample Project The following provides...

Page 66: ...d to create a VSAM Database OTD include 1 Right click your new Project in the Enterprise Designer s Project Explorer and select New Object Type Definition The New Object Type Definition Wizard window appears 2 Select the VSAM Database OTD Wizard from the list of OTD Wizards and click Next 3 Enter the connection information for the VSAM database Connection fields include Host name Port ID Database ...

Page 67: ...Type Definition The New Object Type Definition Wizard window appears 2 Select DTD from the list of OTD Wizards and click Next 3 Browse to and then select a DTD file For our example select one of the following DTD files from the sample Project and then click Next otdInputDTD dtd otdOutputDTD dtd 4 The file you select appears in the Select Document Elements window Click Next 5 Click Finish to comple...

Page 68: ...processes necessary to facilitate the Insert operation See Figure 21 for an illustration of how all the modeling elements appear when connected Table 11 Business Process Activities Business Process Activity bpInsert FileClient Receive FileClient Write otdVSAM CICSEMPInsert inside a Scope otdInputDTD_Emp unmarshal FileClient Write bpUpdate FileClient receive FileClient write otdVSAM CICSEMPUpdate F...

Page 69: ...n of the steps required to connect and add business rules to a modeling elements in a business process Figure 21 bpInsert Business Process Steps required to configure the bpInsert business process 1 Configure the business rule between FileClient receive and FileClient write Activities as seen in Figure 22 Figure 22 bpInsert Business Rule 1 2 Configure the business rule between the FileClient write...

Page 70: ...uide 70 Sun Microsystems Inc Figure 23 bpInsert Business Rule 2 3 Configure the business rule between otdInputDTD_Emp unmarshal Activity and the Insert Scope element as seen in Figure 24 Figure 24 bpInsert Business Rule 3 4 Configure the business rule in the While statement that connects to the otdVSAM CICSEMPInsert Activity as seen in Figure 25 ...

Page 71: ...lding and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User s Guide 71 Sun Microsystems Inc Figure 25 bpInsert Business Rule 4 5 Configure the business rule in the While statement that connects from the otdVSAM CICSEMPInsert Activity as seen in Figure 26 ...

Page 72: ...ment to the FileClient write Activity as seen in Figure 27 Figure 27 bpInsert Business Rule 6 Configuring the bpUpdate Modeling Elements The bpUpdate business process describes how to update a record in the VSAM database using the Business Process Designer Once you have connected the modeling elements together begin adding the business processes necessary to facilitate the Update operation Figure ...

Page 73: ...en the TriggerUpdate in file is empty Note Review the eInsight Business Process Manager User s Guide for a more detailed description of the steps required to connect and add business rules to a modeling elements in a business process Figure 28 bpUpdate Business Process Steps required to configure the bpUpdate business process 1 Configure the business rule between FileClient receive and FileCleint ...

Page 74: ...lements The bpDelete business process describes how to delete a record in the VSAM database using the Business Process Designer Once you have connected the modeling elements together begin adding the business processes necessary to facilitate the Delete operation See Figure 32 for an illustration of how all the modeling elements appear when connected Note The where clause in the business rule read...

Page 75: ...required to connect and add business rules to a modeling elements in a business process Figure 32 bpDelete Business Process Steps required to configure the bpDelete business process 1 Configure the business rule between FileClient receive and FileCleint write Activities as seen in Figure 33 Figure 33 bpDelete Business Rule 1 2 Configure the business rule between the FileClient write Activity and o...

Page 76: ...ecessary to facilitate the SelectAll operation See Figure 36 for an illustration of how all the modeling elements appear when connected Note The where clause in the business rule reads the trigger value as a placeholder for input This permits you to modify the query to select a specific record Also note that all records are selected from the database when the TriggerTableSelect in file is empty No...

Page 77: ...icrosystems Inc Figure 37 bpTableSelect Business Rule 1 2 Configure the business rule between the FileClient write Activity and otdVSAM CICSEMPSelectAll Activity as seen in Figure 38 Figure 38 bpTableSelect Business Rule 2 3 Configure the business rule between the otdVSAM CICSEMPSelectAll Activity and the otdInputDTD_Emp marshal Activity as seen in Figure 39 ...

Page 78: ... prjVSAM_BPEL Sample Project VSAM eWay Adapter User s Guide 78 Sun Microsystems Inc Figure 39 bpSelectTable Business Rule 3 4 Configure the business rule between the otdInputDTD_Emp marshal Activity and the FileClient write Activity as seen in Figure 40 Figure 40 bpTableSelect Business Rule 4 ...

Page 79: ...in the VSAM database via the Business Process Designer Once you have connected the modeling elements together begin adding the business processes necessary to facilitate the SelectAll operation See Figure 42 for an illustration of how all the modeling elements appear when connected Note Review the eInsight Business Process Manager User s Guide for a more detailed description of the steps required ...

Page 80: ...vity and otdVSAM Select_psPSSelectAll Activity as seen in Figure 44 Figure 44 bpPsSelect Business Rule 2 3 Configure Case 1 of the Decision branching activity This requires adding business rules between the otdInputDTD_Emp marshal and the FileClient write Activities within the Scope element Figure 45 Activities within Case 1 Scope 4 Configure the business rule between the start of the Scope elemen...

Page 81: ...AM_BPEL Sample Project VSAM eWay Adapter User s Guide 81 Sun Microsystems Inc Figure 46 Case 1 Scope Business Rule 3 5 Configure the business rule between otdInputDTD_Emp marshal Activity and FileClient write Activity in the Scope element as seen in Figure 47 Figure 47 Case 1 Scope Business Rule 4 ...

Page 82: ...ing business rules between the otdInputDTD_Emp marshal and the FileClient write Activities within the Scope element Figure 48 Activities within Case 2 Scope 7 Configure the business rule between the start of the Scope element in Case 2 and the FileClient Write Activity as seen in Figure 49 Figure 49 Case 2 Scope Business Rule 5 8 Configure the business rule between the Decision end Element and the...

Page 83: ...right click the new prjVSAM_BPEL Project and select New Connectivity Map from the shortcut menu 2 The New Connectivity Map appears and a node for the Connectivity Map is added under the Project on the Project Explorer tree labeled CMap1 Create four additional Connectivity Maps CMap2 CMap3 CMap4 and CMap5 and rename them as follows cmDelete cmInsert cmPsSelect cmTableSelect cmUpdate The icons in th...

Page 84: ...siness Process 1 Drag a business process from the Enterprise Explorer Project Explorer onto the corresponding Connectivity Map For example drag the bpDelete business process onto the cmDelete Connectivity Map 2 Save your changes to the Repository Binding the eWay Components The final step in creating a Connectivity Map is binding the eWay components together Steps required to bind eWay components ...

Page 85: ... Environments include the external systems Logical Hosts Integration Servers and message servers used by a Project and contain the configuration information for these components Environments are created using the Enterprise Designer s Environment Editor Steps required to create an Environment 1 From the Enterprise Designer s Enterprise Explorer click the Environment Explorer tab 2 Right click the ...

Page 86: ...7 Right click LogicalHost1 and select New Sun SeeBeyond Integration Server A new Integration Server IntegrationSvr1 is added to the Environment Explorer tree under LogicalHost1 see Figure 52 Figure 52 Environment Editor envVSAMProj 8 Save your current changes to the Repository 7 5 6 Configuring the eWays eWays facilitate communication and movement of data between the external applications and the ...

Page 87: ...s seen in Table 13 Click OK to close the Properties Editor Table 12 FileClientIN eWay Property Settings Connectivity Map Property Name Required Values cmDelete Input file name TriggerDelete in cmInsert Input file name TriggerBpInsert in cmPsSelect Input file name TriggerPsSelect in cmTableSelect Input file name TriggerTableSelect in cmUpdate Input file name TriggerUpdate in Table 13 FileClientOUT ...

Page 88: ...he File External System esFileClient in this sample and select Properties The Properties Editor opens to the File eWay Environment configuration 4 Modify the File eWay Environment configuration properties for your system as seen in Table 14 and click OK Table 14 File eWay Environment Properties Section Property Name Required Values Configuration Inbound File eWay Parameter Settings Directory Enter...

Page 89: ...c Value and as the Confirm Password and click OK 5 Click OK to accept the new property and close the Properties Editor For more information on deploying a Project see the Sun SeeBeyond Java Composite Application Platform Suite Deployment Guide 7 5 7 Creating the Deployment Profile A Deployment Profile is used to assign services and message destinations to the Integration Server and message server ...

Page 90: ... you install the Sun Java Composite Application Platform Suite Steps required to create and start the domain 1 Navigate to your JavaCAPS51 logicalhost directory where JavaCAPS51 is the location of your Sun Java Composite Application Platform Suite installation 2 Double click the domainmgr bat file The Domain Manager appears 3 If you have already created a domain select your domain in the Domain Ma...

Page 91: ...ns and click Build again 3 After the Build has succeeded you are ready to deploy your Project Deploy the Project 1 From the Deployment Editor toolbar click the Deploy icon Click Yes when the Deploy prompt appears 2 A message appears when the project is successfully deployed You can now test your sample 7 5 10 Running the Sample Project Additional steps are required to run the deployed sample Proje...

Page 92: ...e the sample project include Creating a Project on page 92 Creating the OTDs on page 92 Creating a Connectivity Map on page 94 Creating the Collaboration Definitions Java on page 95 Create the Collaboration Business Rules on page 98 Binding the eWay Components on page 105 Creating an Environment on page 106 Configuring the eWays on page 107 Creating the Deployment Profile on page 110 Creating and ...

Page 93: ... For our example select the following Tables Views Aliases Prepared Statements 5 Click Add to select tables from the VSAM database The Add Tables window appears 6 Search for or Type in the name of the database In this example we use the CICSEMP table Click Select when the database appears in the Results selection frame Click OK to close the Add Tables window 7 Click Next the Add Prepared Statement...

Page 94: ...in to create the second DTD file 7 6 3 Creating a Connectivity Map The Connectivity Map provides a canvas for assembling and configuring a Project s components Steps required to create a new Connectivity Map 1 From the Project Explorer tree right click the new prjVSAM_JCD Project and select New Connectivity Map from the shortcut menu 2 The New Connectivity Map appears and a node for the Connectivi...

Page 95: ...rnal systems are added to the Connectivity Map toolbar 3 Rename the following components and then save changes to the Repository File1 to FileClientIN File2 to FileClientOUT VSAM1 to eaVSAMOUT 4 Rename each Connectivity Map Service to match the intended operation as for example jcdDelete jcdInsert jcdPsSelect jcdTableSelect jcdUpdate 7 6 4 Creating the Collaboration Definitions Java The next step ...

Page 96: ...dDelete Collaboration appears in the right pane of the Enterprise Designer jcdInsert Collaboration Steps required to create the jcdInsert Collaboration 1 From the Project Explorer right click the sample Project and select New Collaboration Definition Java from the shortcut menu The Collaboration Definition Wizard Java appears 2 Enter a Collaboration Definition name for this sample jcdInsert and cl...

Page 97: ...t is included in the Sample Project 6 Click the Up One Level button twice to return to the Repository Double click Sun SeeBeyond eWays File FileClient The Selected OTDs field now lists the FileClient OTD 7 Click Finish The Collaboration Editor with the new jcdPsSelect Collaboration appears in the right pane of the Enterprise Designer jcdTableSelect Collaboration Steps required to create the jcdTab...

Page 98: ...e wizard from the Select OTDs selection window double click prjVSAM_JCD otdALL otdVSAM The otdVSAM OTD is added to the Selected OTDs field 5 Click the Up One Level button twice to return to the Repository Double click Sun SeeBeyond eWays File FileClient The Selected OTDs field now lists the FileClient OTD 6 Click Finish The Collaboration Editor with the new jcdUpdate Collaboration appears in the r...

Page 99: ...rom the input data into the otdInputDTD_CICSEMP OTD calls the otdVSAM OTD and inserts records into the database via a For Loop The Collaboration also writes a message to JCD_Insert_output0 dat to confirm an inserted record The jcdInsert Collaboration contains the Business Rules displayed in Figure 56 Figure 56 jcdInsert Business Rules Sample code from the jcdInsert Includes package prjVSAM_JCDjcdA...

Page 100: ...1 otdInputDTD_Emp_1 countX_sequence_A i1 1 otdVSAM_1 getCICSEMP setENAME otdInputDTD_Emp_1 getX_sequence_A i1 getENAME otdVSAM_1 getCICSEMP setPHONE typeConverter stringToInt otdInputDTD_Emp_1 getX_sequence_A i1 getPHONE false 0 otdVSAM_1 getCICSEMP setMAILID otdInputDTD_Emp_1 getX_sequence_A i1 getMAILID otdVSAM_1 getCICSEMP setSALARY new java math BigDecimal otdInputDTD_Emp_1 getX_sequence_A i1 ...

Page 101: ... the Business Rules displayed in Figure 57 Figure 57 jcdPsSelect Sample code from the jcdPsSelect Includes package prjVSAM_JCDjcdALL public class jcdPsSelect public com stc codegen logger Logger logger public com stc codegen alerter Alerter alerter public com stc codegen util CollaborationContext collabContext public com stc codegen util TypeConverter typeConverter public void receive com stc conn...

Page 102: ...et Select_psResults getMAILID otdOutputDTD_Emp_1 setSALARY otdVSAM_1 getSelect_ps get Select_psResults getSALARY toString otdOutputDTD_Emp_1 setJOBID typeConverter doubleToString otdVSAM_1 getSelect_ps get Select_psResults getJOBID 000000 000000 false otdOutputDTD_Emp_1 setEMPID typeConverter intToString otdVSAM_1 getSelect_ps get Select_psResults getEMPID false otdOutputDTD_Emp_1 setDEPTID typeCo...

Page 103: ...pty The jcdTableSelect Collaboration contains the Business Rules displayed in Figure 58 Figure 58 jcdTableSelect Sample code from the jcdTableSelect Includes package prjVSAM_JCDjcdALL public class jcdTableSelect public com stc codegen logger Logger logger public com stc codegen alerter Alerter alerter public com stc codegen util CollaborationContext collabContext public com stc codegen util TypeCo...

Page 104: ...etCICSEMP getEMPID false otdOutputDTD_Emp_1 setDEPTID typeConverter shortToString otdVSAM_1 getCICSEMP getDEPTID false otdOutputDTD_Emp_1 setDEPARTMENT otdVSAM_1 getCICSEMP getDEPARTMENT marshals XML data from the output data into the otdOutputDTD_CICSEMP_1 marshallToString method FileClient_1 setText otdOutputDTD_Emp_1 marshalToString FileClient_1 write Writes a message to confirm when records ar...

Page 105: ... jcdDelete Collaboration from the Project Explorer to the jcdDelete Service The Service icon gears change from red to green 3 Double click the jcdDelete Service The jcdDelete Binding dialog box appears 4 Map the input FileClient under Implemented Services to the FileClientIN File External Application To do this click on FileSender in the jcdDelete Binding dialog box and drag the cursor to the File...

Page 106: ...t Environments include the external systems Logical Hosts Integration Servers and message servers used by a Project and contain the configuration information for these components Environments are created using the Enterprise Designer s Environment Editor Steps required to create an Environment 1 From the Enterprise Designer s Enterprise Explorer click the Environment Explorer tab 2 Right click the...

Page 107: ...7 Right click LogicalHost1 and select New Sun SeeBeyond Integration Server A new Integration Server IntegrationSvr1 is added to the Environment Explorer tree under LogicalHost1 see Figure 61 Figure 61 Environment Editor envVSAMProj 8 Save your current changes to the Repository 7 6 8 Configuring the eWays eWays facilitate communication and movement of data between the external applications and the ...

Page 108: ...em as seen in Table 16 Click OK to close the Properties Editor Table 15 FileClientIN eWay Property Settings Connectivity Map Property Name Required Values cmDelete Input file name TriggerDelete in cmInsert Input file name TriggerInsert in cmPsSelect Input file name TriggerPsSelect in cmTableSelect Input file name TriggerTableSelect in cmUpdate Input file name TriggerUpdate in Table 16 FileClientOU...

Page 109: ...he File External System esFileClient in this sample and select Properties The Properties Editor opens to the File eWay Environment configuration 4 Modify the File eWay Environment configuration properties for your system as seen in Table 17 and click OK Table 17 File eWay Environment Properties Section Property Name Required Values Configuration Inbound File eWay Parameter Settings Directory Enter...

Page 110: ...ic Value and as the Confirm Password and click OK 5 Click OK to accept the new property and close the Properties Editor For more information on deploying a Project see the Sun SeeBeyond Java Composite Application Platform Suite Deployment Guide 7 6 9 Creating the Deployment Profile A Deployment Profile is used to assign services and message destinations to the Integration Server and message server...

Page 111: ... you install the Sun Java Composite Application Platform Suite Steps required to create and start the domain 1 Navigate to your JavaCAPS51 logicalhost directory where JavaCAPS51 is the location of your Sun Java Composite Application Platform Suite installation 2 Double click the domainmgr bat file The Domain Manager appears 3 If you have already created a domain select your domain in the Domain Ma...

Page 112: ...fter the Build has succeeded you are ready to deploy your Project Deploy the Project 1 From the Deployment Editor toolbar click the Deploy icon Click Yes when the Deploy prompt appears 2 A message appears when the project is successfully deployed You can now test your sample 7 6 12 Running the Sample Additional steps are required to run the deployed sample Project Steps required to run the sample ...

Page 113: ...Sun Microsystems Inc 2 Verify the output data by viewing the sample output files See About the VSAM eWay Sample Projects on page 61 for more details on the types of output files used in this sample Project The output files may change depending on the number of times you execute the sample Project the input file and also the content of your database table ...

Page 114: ...ing sWhere 55 deleteRow 55 insert 55 insertRow 55 select String where 55 update String sWhere 55 updateRow 55 database OTD wizard about 34 add prepared statement 41 editing existing OTDs 47 review selections 45 select database objects 36 select tables views 37 select wizard type 35 Deployment Profile Automap 89 110 E eWay Connectivity Map 20 24 eWay environment properties 23 eWay operation general...

Page 115: ...s 29 32 eWay Connectivity Map 20 24 eWay environment properties 23 outbound eWay 25 SQL 55 SQL operations table 55 SQL operations table Delete 58 SQL operations table Insert 57 SQL operations table Select 56 SQL operations table Update 58 supporting documents 10 T Table SQL operations 55 SQL operations Delete 58 SQL operations Insert 57 SQL operations Select 56 SQL operations Update 58 text conven...

Search results

Summary of Contents for SUN SEEBEYOND eWAY

Reviews:

Related manuals for SUN SEEBEYOND eWAY

Brands by name

Popular brands

Sun Microsystems SUN SEEBEYOND eWAY, User Manual

Search results

Summary of Contents for SUN SEEBEYOND eWAY

Reviews:

Related manuals for SUN SEEBEYOND eWAY

Brands by name

Popular brands