113 | Sun Microsystems JDBC/ODBC Adapter specs

Chapter 6	Section 6.6
Implementing the JDBC/ODBC eWay Sample Projects	Building and Deploying the prjJDBC_BPEL Sample Project

Configuring the Integration Server

You must set your SeeBeyond Integration Server Password property before deploying your Project.

1From the Environment Explorer, right-click IntegrationSvr1 under your Logical Host, and select Properties from the shortcut menu. The Integration Server Properties Editor appears.

2Click the Password property field under Sun SeeBeyond Integration Server Configuration. An ellipsis appears in the property field.

3Click the ellipsis. The Password Settings dialog box appears.

4Enter STC as the Specific Value and as the Confirm Password, and click OK.

5Click 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.

6.6.7Creating the Deployment Profile

A Deployment Profile is used to assign services and message destinations to the Integration Server and message server. Deployment profiles are created using the Deployment Editor.

Steps required to create the Deployment Profile:

1From the Enterprise Explorer’s Project Explorer, right-click the prjJDBC_BPEL Project and select New > Deployment Profile.

2Enter a name for the Deployment Profile (for this sample dpJDBC_BPEL). Select envJDBCProj as the Environment and click OK.

3From the Deployment Editor toolbar, click the Automap icon. The Project’s components are automatically mapped to their system windows, as seen in Figure 62.

JDBC/ODBC eWay Adapter User’s Guide

113

Sun Microsystems, Inc.

Image 113

Sun Microsystems JDBC/ODBC Adapter manual 113

Contents

EWAY JDBC/ODBC Adapter USER’S Guide Part Number Version Contents Activity Input and Output Transaction Support Levels Between Different Versions Create the Collaboration Business Rules Stored ProcedureCreating the Collaboration Definitions Java Building and Deploying the Project Running the Sample Building and Deploying the prjJDBCBPEL Sample Project What’s In This Chapter About Java Database Connectivity JdbcJdbc Drivers Type One Driver Type I JDBC-ODBC Bridge Type Two Driver Type II Partial Java driverPros Cons Type Three Driver Pure Java driver for database middleware Type Four Driver Direct-to-database pure Java driver Typical Type 3 Middleware Driver Configuration Typical Type 4 Driver Configuration New for Version About the JDBC/ODBC eWayWhat’s New in This Release Jdbc eWay Javadoc About This DocumentScope Sun Microsystems, Inc. Web Site Related DocumentsIntended Audience Text Conventions Documentation Feedback Installing the Jdbc eWay Installing the JDBC/ODBC eWay Installing 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 To add plug-ins from the Enterprise Manager Installing Enterprise Manager eWay Plug-Ins To View the eWay Alert Codes Viewing Alert CodesAlert Codes for the JDBC/ODBC eWay Alert Code\Description Description Details User Actions Duncommitted Chapter Section Configuring the eWay Connectivity Map Properties Creating and Configuring a Jdbc eWay Connectivity Map with Components To configure the eWay properties Example Transaction Support Levels Between Different Versions Transaction Support Levels To Configure the Environment Properties Configuring the eWay Environment Properties EWay Connectivity Map Properties Outbound eWay Configuration Sections Include EWay Environment Properties Outbound XA eWay Configuration Settings IncludeConnectivity Map Outbound eWay Properties Connectivity Map Outbound non-Transactional eWay Properties Inbound Jdbc eWay Properties Inbound Jdbc eWay-Parameter SettingsOutbound Jdbc eWay Properties Name Description Required Value Outbound Jdbc eWay-JDBC Connector Settings Jdbc Connector SettingsIs Jdbc Connection Pool Datasource ConnectionPoolDataSource XADataSource or ConnectionPoolDataSource Connection Retry SettingsOutbound Jdbc eWay-Connection Retry Settings Outbound non-Transactional Jdbc eWay Properties Outbound non-Transactional eWay -JDBC Connector Settings Outbound non-Transactional eWay -JDBC Connector Settings Outbound XA Jdbc eWay Properties Outbound non-Transactional eWay-Connection Retry Settings ConnectionPoolDataSource 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 Creating a New Jdbc OTD About the Database OTD Wizard Connect To Database Select Wizard Type Steps Required to Select Database Objects Include Select Database ObjectsRequired Database Connection Fields include Steps Required to Select Table/Views/Aliases Include Select Tables/Views/Aliases Select Tables/Views/Aliases Database Wizard All Schemes Selected Tables/Views/Aliases window with a table selected Table/View Columns Select Procedures Steps Required to Select Stored Procedures Include Add Procedures Edit Resultset Steps Required to Add Prepared Statements Include Add Prepared Statement Prepared Statement Edit the Prepared Statement Parameters Review Selections Specify the OTD NameSteps Required to Specify the OTD Name Steps Required to Review Your OTD Selections Steps to Edit the OTD from the Enterprise Designer Include Steps to Edit an Existing Jdbc OTD Activity Input and Output Jdbc eWay Database Operations Bpel EInsight Operations Activity Input Activity Output JDBC.ODBC Operations Jdbc eWay Database Operations JCD To perform a query operation on a table Query Select Operation To perform an insert operation on a table Insert Operation To perform an update operation on a table Update Operation To perform a delete operation on a table Stored ProcedureDelete Operation Steps for executing the Stored Procedure include Executing Stored Procedures FileClient1.write Collaboration usability for a stored procedure ResultSet Batch Operations Prepared Statement Chapter Section Using JDBC/ODBC Operations About the Jdbc eWay Sample Projects Implementing the JDBC/ODBC eWay Sample Projects Sample output Bpel files Sample input filesSample output JCD files Operations Used in the Jdbc Sample Projects Sample Project DataAssigning Operations in JCD Assigning Operations in Bpel Sample Projects Drivers Running the Sample ProjectsAbout the eInsight Engine and eGate Components Importing a Sample Project Running the SQL Script Steps required to create the sample project Building and Deploying the prjJDBCJCD Sample Project Steps required to create a Jdbc Database OTD Creating a ProjectCreating the OTDs Click Next the Add Prepared Statements Wizard appears Creating a Connectivity Map Steps 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 JcdPsSelect Collaboration JcdInsert CollaborationSteps required to create the jcdInsert Collaboration Steps required to create the jcdPsSelect Collaboration Steps required to create the jcdPsUpdate Collaboration JcdPsUpdate CollaborationJcdTableSelect Collaboration Steps required to create the jcdTableSelect Collaboration Creating the jcdInsert Business Rules Create the Collaboration Business RulesCreating the jcdDelete Business Rules JcdInsert Business Rules Creating the jcdPsSelect Business Rules Sample code from the jcdPsSelect Includes JcdPsSelect Business Rules Creating the jcdTableSelect Business Rules Sample code from the jcdTableSelect Includes JcdTableSelect Business Rules Binding the eWay Components Creating the jcdUpdate Business Rules Steps required to bind eWay components together Creating an Environment Steps required to create an Environment Configuring the eWays Steps required to configure the eWay properties Configuring the eWay PropertiesFileClientIN eWay Property Settings FileClientOUT eWay Property Settings Section Property Name Required Value Configuring the Environment Explorer PropertiesJdbc eWay Environment Properties File eWay Environment Properties Configuring the Integration ServerCreating the Deployment Profile Steps required to create the Deployment Profile Creating and Starting the Domain Running the Sample Building and Deploying the ProjectSteps required to create and start the domain Build the Project Building and Deploying the prjJDBCBPEL Sample Project Steps required to create a Jdbc Database OTD include Creating the Business Process Flow Creating the Business ProcessSteps required to create inbound and outbound DTD OTDs Steps to create a business process flow include Business Process Activity Configuring the bpelPsInsert Modeling ElementsBusiness Process Activities BpelPsInsert Business Process Configuring the bpelUpdate Modeling Elements Steps required to configure the bpelUpdate business process BpelUpdate Business Process Configuring the bpelDelete Modeling Elements BpelDelete Business Process Steps required to configure the bpelDelete business process BpelTableSelect Business Process Configuring the bpelTableSelect Modeling Elements BpelTableSelect Business Rule # BpelSelectTable Business Rule # To Select a Jdbc External System Creating the Connectivity MapSteps required to create the Connectivity Map To Select a Jdbc Business Process Binding the eWay Components 109 FileClientOUT eWay FileClientIN eWay EaJDBCOUT eWay 111 112 113 114 Running the Sample Project 116 JDBC/ODBC Drivers AS/400 Toolbox Driver Configuration PropertiesOTD Wizard Database Connection Information AS/400 Database Connection Information AS/400 Database Environment Properties Attunity DriverEnvironment Properties Attunity Driver Database Environment Properties Attunity Driver Database Connection Information MySQL Connector/J Driver Database Connection Information MySQL Connector/J DriverMySQL Connector/J Driver Environment Properties Parameter Value MaxIdleTime Default is PostgreSQL Driver Connection Information PostgreSQL Driver PostgreSQL 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 Environment Properties MS Access Odbc Driver Database Connection Information Teradata Driver Environment Properties Teradata DriverTeradata Driver Database Connection Information Installing JDBC/ODBC Drivers Troubleshooting Index Jdbc Update count