Document Outline

• eWAY™ JDBC/ODBC ADAPTER USER’S GUIDE
  • Contents
  • Introducing the JDBC/ODBC eWay
    • 1.1 About Java Database Connectivity (JDBC)
      • 1.1.1 JDBC Drivers
        • Type I: JDBC-ODBC Bridge
        • Type One Driver
        • Type II: Partial Java driver
        • Type Two Driver
        • Pure Java driver for database middleware
        • Type Three Driver
        • Type Four Driver: Direct-to-database pure Java driver
    • 1.2 About the JDBC/ODBC eWay
    • 1.3 What’s New in This Release
    • 1.4 About This Document
      • JDBC eWay Javadoc
      • 1.4.1 Scope
      • 1.4.2 Intended Audience
      • 1.4.3 Text Conventions
    • 1.5 Related Documents
    • 1.6 Sun Microsystems, Inc. Web Site
    • 1.7 Documentation Feedback
  • Installing the JDBC/ODBC eWay
    • 2.1 Installing the JDBC eWay
      • 2.1.1 Installing the JDBC eWay on an eGate supported system
        • Adding the eWay to an Existing Sun Java Composite Application Platform Suite Installation
        • After Installation
      • 2.1.2 Extracting the Sample Projects and Javadocs
    • 2.2 ICAN 5.0 Project Migration Procedures
    • 2.3 Installing Enterprise Manager eWay Plug-Ins
      • 2.3.1 Viewing Alert Codes
  • Setting Properties of the JDBC/ODBC eWay
    • 3.1 Creating and Configuring a JDBC eWay
    • 3.2 Configuring the eWay Connectivity Map Properties
      • 3.2.1 Transaction Support Levels Between Different Versions
    • 3.3 Configuring the eWay Environment Properties
    • 3.4 eWay Connectivity Map Properties
      • 3.4.1 Connectivity Map Outbound eWay Properties
      • 3.4.2 Connectivity Map Outbound non-Transactional eWay Properties
      • 3.4.3 Connectivity Map Outbound XA eWay Properties
    • 3.5 eWay Environment Properties
      • 3.5.1 Inbound JDBC eWay Properties
      • 3.5.2 Outbound JDBC eWay Properties
        • JDBC Connector Settings
        • Connection Retry Settings
      • 3.5.3 Outbound non-Transactional JDBC eWay Properties
        • JDBC Connector Settings
        • Connection Retry Settings
      • 3.5.4 Outbound XA JDBC eWay Properties
        • JDBC Connector Settings
        • Connection Retry Settings
  • Using the JDBC/ODBC eWay Database Wizard
    • 4.1 About the Database OTD Wizard
    • 4.2 Creating a New JDBC OTD
      • 4.2.1 Select Wizard Type
      • 4.2.2 Connect To Database
      • 4.2.3 Select Database Objects
      • 4.2.4 Select Tables/Views/Aliases
      • 4.2.5 Select Procedures
      • 4.2.6 Add Prepared Statement
      • 4.2.7 Specify the OTD Name
      • 4.2.8 Review Selections
    • 4.3 Steps to Edit an Existing JDBC OTD
  • Using JDBC/ODBC Operations
    • 5.1 JDBC eWay Database Operations (BPEL)
      • 5.1.1 Activity Input and Output
    • 5.2 JDBC eWay Database Operations (JCD)
      • 5.2.1 The Table
        • The Query (Select) Operation
        • The Insert Operation
        • The Update Operation
        • The Delete Operation
      • 5.2.2 The Stored Procedure
        • Executing Stored Procedures
        • Manipulating the ResultSet and Update Count Returned by Stored Procedure
        • Prepared Statement
        • Batch Operations
  • Implementing the JDBC/ODBC eWay Sample Projects
    • 6.1 About the JDBC eWay Sample Projects
      • 6.1.1 Sample Project Data
      • 6.1.2 Operations Used in the JDBC Sample Projects
        • Assigning Operations in JCD
        • Assigning Operations in BPEL
      • 6.1.3 About the eInsight Engine and eGate Components
      • 6.1.4 Sample Projects Drivers
    • 6.2 Running the Sample Projects
    • 6.3 Running the SQL Script
    • 6.4 Importing a Sample Project
    • 6.5 Building and Deploying the prjJDBC_JCD Sample Project
      • 6.5.1 Creating a Project
      • 6.5.2 Creating the OTDs
      • 6.5.3 Creating a Connectivity Map
        • Populating the Connectivity Map
      • 6.5.4 Creating the Collaboration Definitions (Java)
        • jcdDelete Collaboration
        • jcdInsert Collaboration
        • jcdPsSelect Collaboration
        • jcdTableSelect Collaboration
        • jcdPsUpdate Collaboration
      • 6.5.5 Create the Collaboration Business Rules
        • Creating the jcdDelete Business Rules
        • Creating the jcdInsert Business Rules
        • Creating the jcdPsSelect Business Rules
        • Creating the jcdTableSelect Business Rules
        • Creating the jcdUpdate Business Rules
      • 6.5.6 Binding the eWay Components
      • 6.5.7 Creating an Environment
      • 6.5.8 Configuring the eWays
        • Configuring the eWay Properties
        • Configuring the Environment Explorer Properties
        • Configuring the Integration Server
      • 6.5.9 Creating the Deployment Profile
      • 6.5.10 Creating and Starting the Domain
      • 6.5.11 Building and Deploying the Project
      • 6.5.12 Running the Sample
    • 6.6 Building and Deploying the prjJDBC_BPEL Sample Project
      • 6.6.1 Creating a Project
      • 6.6.2 Creating the OTDs
      • 6.6.3 Creating the Business Process
        • Creating the Business Process Flow
        • Configuring the bpelPsInsert Modeling Elements
        • Configuring the bpelUpdate Modeling Elements
        • Configuring the bpelDelete Modeling Elements
        • Configuring the bpelTableSelect Modeling Elements
      • 6.6.4 Creating the Connectivity Map
        • Populating the Connectivity Map
        • Binding the eWay Components
      • 6.6.5 Creating an Environment
      • 6.6.6 Configuring the eWays
        • Configuring the eWay Properties
        • Configuring the Environment Explorer Properties
        • Configuring the Integration Server
      • 6.6.7 Creating the Deployment Profile
      • 6.6.8 Creating and Starting the Domain
      • 6.6.9 Building and Deploying the Project
      • 6.6.10 Running the Sample Project
  • JDBC/ODBC Drivers
    • A.1 AS/400 Toolbox Driver
      • A.1.1 OTD Wizard: Database Connection Information
      • A.1.2 Environment Properties
    • A.2 Attunity Driver
      • A.2.1 OTD Wizard: Database Connection Information
      • A.2.2 Environment Properties
    • A.3 MySQL Connector/J Driver
      • A.3.1 OTD Wizard: Database Connection Information
      • A.3.2 Environment Properties
    • A.4 PostgreSQL Driver
      • A.4.1 OTD Wizard: Database Connection Information
      • A.4.2 Environment Properties
    • A.5 SyBase JConnect Driver
      • A.5.1 OTD Wizard: Database Connection Information
      • A.5.2 Environment Properties
    • A.6 Sequelink DataDirect Informix ODBC Driver
      • A.6.1 OTD Wizard: Database Connection Information
      • A.6.2 Environment Properties
    • A.7 Sequelink DataDirect MS Access ODBC Driver
      • A.7.1 OTD Wizard: Database Connection Information
      • A.7.2 Environment Properties
    • A.8 Teradata Driver
      • A.8.1 OTD Wizard: Database Connection Information
      • A.8.2 Environment Properties
    • A.9 Installing JDBC/ODBC Drivers
    • A.10 Troubleshooting
  • Index
    • A
    • B
    • C
    • D
    • E
    • I
    • J
    • M
    • O
    • P
    • R
    • S
    • T
    • U