Jdbc Drivers | Sun Microsystems JDBC/ODBC Adapter specification

Chapter 1

Introducing the JDBC/ODBC eWay

Welcome to the Sun SeeBeyond eWay™ JDBC/ODBC Adapter User’s Guide. This document includes information about installing, configuring, and using the Sun Java Composite Application Platform Suite JDBC/ODBC eWay™ Adapter, referred to as the JDBC eWay throughout this guide.

This chapter provides an overview of database connectivity (JDBC) and open database connectivity (ODBC) APIs. This chapter also introduces the JDBC/ODBC eWay.

What’s In This Chapter

About Java Database Connectivity (JDBC) on page 7

About the JDBC/ODBC eWay on page 13

What’s New in This Release on page 13

About This Document on page 14

Related Documents on page 15

Sun Microsystems, Inc. Web Site on page 15

Documentation Feedback on page 15

1.1About Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC) is an implementation of the Java programming language that dictates how databases communicate with each other. Through a standardized application programming interface (API), connectivity from database management systems (DBMS) to a wide range of SQL databases is accomplished. By deploying database drivers laced with JDBC technology, it is possible to connect to any database -- even in a heterogeneous environment -- and access tables, tabular data, flat files and more. When using JDBC, Java programmers have the ability to request connections to a database, send queries to the database using SQL statements, and receive results for advanced processing.

1.1.1JDBC Drivers

To connect with individual databases, JDBC requires drivers for each database. Those drivers come in four varieties. Driver types 1 and 2 are typically intended for programmers that write applications. Driver types 3 and 4 are typically used by

JDBC/ODBC eWay Adapter User’s Guide

7

Sun Microsystems, Inc.

Image 7

Sun Microsystems JDBC/ODBC Adapter manual About Java Database Connectivity Jdbc, Jdbc Drivers, What’s In This Chapter

Contents

EWAY JDBC/ODBC Adapter USER’S Guide Part Number Version Contents Activity Input and Output Transaction Support Levels Between Different Versions Creating the Collaboration Definitions Java Stored ProcedureCreate the Collaboration Business Rules Building and Deploying the Project Running the Sample Building and Deploying the prjJDBCBPEL Sample Project Jdbc Drivers About Java Database Connectivity JdbcWhat’s In This Chapter Type One Driver Type I JDBC-ODBC Bridge Cons Type II Partial Java driverType Two Driver Pros 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 What’s New in This Release About the JDBC/ODBC eWayNew for Version Scope About This DocumentJdbc eWay Javadoc Text Conventions Related DocumentsSun Microsystems, Inc. Web Site Intended Audience Documentation Feedback Installing the Jdbc eWay Installing the JDBC/ODBC eWay Installing the Jdbc eWay on an eGate supported system After Installation Ican 5.0 Project Migration ProceduresExtracting the Sample Projects and Javadocs Import the Project Install Java CapsDeploy the Project To add plug-ins from the Enterprise Manager Installing Enterprise Manager eWay Plug-Ins Alert Code\Description Description Details User Actions Viewing Alert CodesTo View the eWay Alert Codes Alert Codes for the JDBC/ODBC eWay 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 Connectivity Map Outbound non-Transactional eWay Properties Outbound XA eWay Configuration Settings IncludeEWay Environment Properties Connectivity Map Outbound eWay Properties Name Description Required Value Inbound Jdbc eWay-Parameter SettingsInbound Jdbc eWay Properties Outbound Jdbc eWay Properties ConnectionPoolDataSource Jdbc Connector SettingsOutbound Jdbc eWay-JDBC Connector Settings Is Jdbc Connection Pool Datasource Outbound Jdbc eWay-Connection Retry Settings Connection Retry SettingsXADataSource or ConnectionPoolDataSource 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 Is Jdbc XA Datasource Outbound XA Jdbc eWay-JDBC Connector SettingsConnectionPoolDataSource or 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 Required Database Connection Fields include Select Database ObjectsSteps Required to Select Database Objects 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 Steps Required to Review Your OTD Selections Specify the OTD NameReview Selections Steps Required to Specify the OTD Name 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 Delete Operation Stored ProcedureTo perform a delete operation on a table 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 JCD files Sample input filesSample output Bpel files Assigning Operations in Bpel Sample Project DataOperations Used in the Jdbc Sample Projects Assigning Operations in JCD About the eInsight Engine and eGate Components Running the Sample ProjectsSample Projects Drivers Importing a Sample Project Running the SQL Script Steps required to create the sample project Building and Deploying the prjJDBCJCD Sample Project Creating the OTDs Creating a ProjectSteps required to create a Jdbc Database OTD Click Next the Add Prepared Statements Wizard appears Creating a Connectivity Map Steps required to create a new Connectivity Map Populating the Connectivity MapSteps required to select a Jdbc External System JcdDelete Collaboration Creating the Collaboration Definitions JavaSteps required to create the jcdDelete Collaboration Steps required to create the jcdPsSelect Collaboration JcdInsert CollaborationJcdPsSelect Collaboration Steps required to create the jcdInsert Collaboration Steps required to create the jcdTableSelect Collaboration JcdPsUpdate CollaborationSteps required to create the jcdPsUpdate Collaboration JcdTableSelect Collaboration Creating the jcdDelete Business Rules Create the Collaboration Business RulesCreating the jcdInsert 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 FileClientOUT eWay Property Settings Configuring the eWay PropertiesSteps required to configure the eWay properties FileClientIN eWay Property Settings Jdbc eWay Environment Properties Configuring the Environment Explorer PropertiesSection Property Name Required Value Creating the Deployment Profile Configuring the Integration ServerFile eWay Environment Properties Steps required to create the Deployment Profile Creating and Starting the Domain Build the Project Building and Deploying the ProjectRunning the Sample Steps required to create and start the domain Building and Deploying the prjJDBCBPEL Sample Project Steps required to create a Jdbc Database OTD include Steps to create a business process flow include Creating the Business ProcessCreating the Business Process Flow Steps required to create inbound and outbound DTD OTDs Business Process Activities Configuring the bpelPsInsert Modeling ElementsBusiness Process Activity 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 # Steps required to create the Connectivity Map Creating the Connectivity MapTo Select a Jdbc External System 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 Database Connection Information Configuration PropertiesAS/400 Toolbox Driver OTD Wizard Database Connection Information Environment Properties Attunity DriverAS/400 Database Environment Properties Attunity Driver Database Environment Properties Attunity Driver Database Connection Information Parameter Value MaxIdleTime Default is MySQL Connector/J DriverMySQL Connector/J Driver Database Connection Information MySQL Connector/J Driver Environment Properties PostgreSQL Driver Connection Information PostgreSQL Driver PostgreSQL Driver Environment Properties Sybase JConnect Driver Database Connection Information SyBase JConnect DriverSybase JConnect Driver Environment Properties 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 Database Connection Information Teradata DriverTeradata Driver Environment Properties Installing JDBC/ODBC Drivers Troubleshooting Index Jdbc Update count