Manuals / Sun Microsystems / Computer Equipment / Network Card

Sun Microsystems JDBC/ODBC Adapter manual Building and Deploying the prjJDBCJCD Sample Project

Models: JDBC/ODBC Adapter

1 133

Download 133 pages 48.36 Kb

Page 74

Chapter 6	Section 6.5
Implementing the JDBC/ODBC eWay Sample Projects	Building and Deploying the prjJDBC_JCD Sample Project

Note: Make sure you save all unsaved work before importing a Project.

2From the Enterprise Designer’s Project Explorer pane, right-click the Repository and select Import Project from the shortcut menu. The Import Manager appears.

Figure 30 Import Manager Dialog Box

3Browse to the directory that contains the sample Project ZIP file. Select the sample file and click Import.

Click Close after successfully importing the sample Project.

6.5Building and Deploying the prjJDBC_JCD Sample Project

This section provides step-by-step instructions for manually creating the prjJDBC_JCD sample Project.

Steps required to create the sample project

Creating a Project on page 75

Creating the OTDs on page 75

Creating a Connectivity Map on page 76

JDBC/ODBC eWay Adapter User’s Guide

74

Sun Microsystems, Inc.

Image 74

Sun Microsystems JDBC/ODBC Adapter manual Building and Deploying the prjJDBCJCD Sample Project

Contents

EWAY JDBC/ODBC Adapter USER’S Guide Part Number Version Contents Transaction Support Levels Between Different Versions Activity Input and OutputCreate the Collaboration Business Rules Stored ProcedureCreating the Collaboration Definitions Java Building and Deploying the prjJDBCBPEL Sample Project Building and Deploying the Project Running the SampleWhat’s In This Chapter About Java Database Connectivity JdbcJdbc Drivers Type I JDBC-ODBC Bridge Type One DriverPros Type II Partial Java driverType Two Driver ConsPure Java driver for database middleware Type Three DriverTypical Type 3 Middleware Driver Configuration Type Four Driver Direct-to-database pure Java driverTypical Type 4 Driver Configuration New for Version About the JDBC/ODBC eWayWhat’s New in This Release Jdbc eWay Javadoc About This DocumentScope Intended Audience Related DocumentsSun Microsystems, Inc. Web Site Text ConventionsDocumentation Feedback Installing the JDBC/ODBC eWay Installing the Jdbc eWayInstalling the Jdbc eWay on an eGate supported system Extracting the Sample Projects and Javadocs Ican 5.0 Project Migration ProceduresAfter Installation Deploy the Project Install Java CapsImport the Project Installing Enterprise Manager eWay Plug-Ins To add plug-ins from the Enterprise ManagerAlert Codes for the JDBC/ODBC eWay Viewing Alert CodesTo View the eWay Alert Codes Alert Code\Description Description Details User ActionsDuncommitted Chapter Section Creating and Configuring a Jdbc eWay Configuring the eWay Connectivity Map PropertiesTo configure the eWay properties Connectivity Map with ComponentsTransaction Support Levels Between Different Versions ExampleTransaction Support Levels Configuring the eWay Environment Properties To Configure the Environment PropertiesOutbound eWay Configuration Sections Include EWay Connectivity Map PropertiesConnectivity Map Outbound eWay Properties Outbound XA eWay Configuration Settings IncludeEWay Environment Properties Connectivity Map Outbound non-Transactional eWay PropertiesOutbound Jdbc eWay Properties Inbound Jdbc eWay-Parameter SettingsInbound Jdbc eWay Properties Name Description Required ValueIs Jdbc Connection Pool Datasource Jdbc Connector SettingsOutbound Jdbc eWay-JDBC Connector Settings ConnectionPoolDataSourceXADataSource or ConnectionPoolDataSource Connection Retry SettingsOutbound Jdbc eWay-Connection Retry Settings Outbound non-Transactional eWay -JDBC Connector Settings Outbound non-Transactional Jdbc eWay PropertiesOutbound non-Transactional eWay -JDBC Connector Settings Outbound non-Transactional eWay-Connection Retry Settings Outbound XA Jdbc eWay PropertiesConnectionPoolDataSource or Outbound XA Jdbc eWay-JDBC Connector SettingsIs Jdbc XA Datasource Outbound XA Jdbc eWay-Connection Retry Settings Outbound XA Jdbc eWay-Connection Retry Settings About the Database OTD Wizard Creating a New Jdbc OTDSelect Wizard Type Connect To DatabaseSteps Required to Select Database Objects Include Select Database ObjectsRequired Database Connection Fields include Select Tables/Views/Aliases Steps Required to Select Table/Views/Aliases IncludeSelect Tables/Views/Aliases Database Wizard All Schemes Selected Tables/Views/Aliases window with a table selected Select Procedures Table/View ColumnsSteps Required to Select Stored Procedures Include Add Procedures Edit Resultset Add Prepared Statement Steps Required to Add Prepared Statements IncludePrepared Statement Edit the Prepared Statement Parameters Steps Required to Specify the OTD Name Specify the OTD NameReview Selections Steps Required to Review Your OTD SelectionsSteps to Edit an Existing Jdbc OTD Steps to Edit the OTD from the Enterprise Designer IncludeJdbc eWay Database Operations Bpel Activity Input and OutputJDBC.ODBC Operations EInsight Operations Activity Input Activity OutputJdbc eWay Database Operations JCD Query Select Operation To perform a query operation on a tableInsert Operation To perform an insert operation on a tableUpdate Operation To perform an update operation on a tableTo perform a delete operation on a table Stored ProcedureDelete Operation Executing Stored Procedures Steps for executing the Stored Procedure includeFileClient1.write Collaboration usability for a stored procedure ResultSet Prepared Statement Batch OperationsChapter Section Using JDBC/ODBC Operations Implementing the JDBC/ODBC eWay Sample Projects About the Jdbc eWay Sample ProjectsSample output Bpel files Sample input filesSample output JCD files Assigning Operations in JCD Sample Project DataOperations Used in the Jdbc Sample Projects Assigning Operations in BpelSample Projects Drivers Running the Sample ProjectsAbout the eInsight Engine and eGate Components Running the SQL Script Importing a Sample ProjectBuilding and Deploying the prjJDBCJCD Sample Project Steps required to create the sample projectSteps required to create a Jdbc Database OTD Creating a ProjectCreating the OTDs Creating a Connectivity Map Click Next the Add Prepared Statements Wizard appearsSteps required to select a Jdbc External System Populating the Connectivity MapSteps required to create a new Connectivity Map Steps required to create the jcdDelete Collaboration Creating the Collaboration Definitions JavaJcdDelete Collaboration Steps required to create the jcdInsert Collaboration JcdInsert CollaborationJcdPsSelect Collaboration Steps required to create the jcdPsSelect CollaborationJcdTableSelect Collaboration JcdPsUpdate CollaborationSteps required to create the jcdPsUpdate Collaboration Steps required to create the jcdTableSelect CollaborationCreating the jcdInsert Business Rules Create the Collaboration Business RulesCreating the jcdDelete Business Rules JcdInsert Business Rules Creating the jcdPsSelect Business Rules JcdPsSelect Business Rules Sample code from the jcdPsSelect IncludesCreating the jcdTableSelect Business Rules JcdTableSelect Business Rules Sample code from the jcdTableSelect IncludesCreating the jcdUpdate Business Rules Binding the eWay ComponentsCreating an Environment Steps required to bind eWay components togetherConfiguring the eWays Steps required to create an EnvironmentFileClientIN eWay Property Settings Configuring the eWay PropertiesSteps required to configure the eWay properties FileClientOUT eWay Property SettingsSection Property Name Required Value Configuring the Environment Explorer PropertiesJdbc eWay Environment Properties File eWay Environment Properties Configuring the Integration ServerCreating the Deployment Profile Creating and Starting the Domain Steps required to create the Deployment ProfileSteps required to create and start the domain Building and Deploying the ProjectRunning the Sample Build the ProjectBuilding and Deploying the prjJDBCBPEL Sample Project Steps required to create a Jdbc Database OTD include Steps required to create inbound and outbound DTD OTDs Creating the Business ProcessCreating the Business Process Flow Steps to create a business process flow includeBusiness Process Activity Configuring the bpelPsInsert Modeling ElementsBusiness Process Activities BpelPsInsert Business Process Configuring the bpelUpdate Modeling Elements BpelUpdate Business Process Steps required to configure the bpelUpdate business processConfiguring the bpelDelete Modeling Elements Steps required to configure the bpelDelete business process BpelDelete Business ProcessConfiguring the bpelTableSelect Modeling Elements BpelTableSelect Business ProcessBpelTableSelect Business Rule # BpelSelectTable Business Rule # To Select a Jdbc External System Creating the Connectivity MapSteps required to create the Connectivity Map Binding the eWay Components To Select a Jdbc Business Process109 FileClientOUT eWay FileClientIN eWay EaJDBCOUT eWay 111 112 113 114 Running the Sample Project 116 JDBC/ODBC Drivers OTD Wizard Database Connection Information Configuration PropertiesAS/400 Toolbox Driver AS/400 Database Connection InformationAS/400 Database Environment Properties Attunity DriverEnvironment Properties Attunity Driver Database Connection Information Attunity Driver Database Environment PropertiesMySQL Connector/J Driver Environment Properties MySQL Connector/J DriverMySQL Connector/J Driver Database Connection Information Parameter Value MaxIdleTime Default isPostgreSQL Driver PostgreSQL Driver Connection InformationPostgreSQL Driver Environment Properties Sybase JConnect Driver Environment Properties SyBase JConnect DriverSybase JConnect Driver Database Connection Information Sequelink DataDirect Informix Odbc Driver Sequelink DataDirect MS Access Odbc Driver MS Access Odbc Driver Database Connection Information MS Access Odbc Driver Environment PropertiesTeradata Driver Environment Properties Teradata DriverTeradata Driver Database Connection Information Installing JDBC/ODBC Drivers Troubleshooting Index Jdbc Update count