Sun Microsystems JDBC/ODBC Adapter instruction

Chapter 3	Section 3.5
Setting Properties of the JDBC/ODBC eWay	eWay Environment Properties

Table 9 Outbound non-Transactional eWay —JDBC Connector Settings (Continued)

Name	Description	Required Value

PortNumber	Specifies the I/O port number on	A valid port number.
	which the server is listening for
	connection requests.

DatabaseName	Specifies the name of the database	Any valid string.
	instance.

User	Specifies the user name the eWay	Any valid string.
	uses to connect to the database.

Password	Specifies the password used to	Any valid string.
	access the database.

DriverProperties	The Connection Pool DataSource	Set the driver properties according to
	implementation may need to execute	driver vendor's instruction. For
	additional methods to assure a	example:
	successful run. The additional	setDefTdpName#DBSQL##setWorkspa
	methods will need to be identified in	ce#Navigator##
	the Driver Properties. You must
	ensure that the driver is installed on
	both the Logical Host machine and
	the Enterprise Designer machine.

Delimiter	This is the delimiter character to be	The default is #.
	used in the DriverProperties prompt.

DataSource	Specifies the name of the	The name of the XADataSource or
name	XADataSource or	ConnectionPoolDataSource
	ConnectionPoolDataSource	implementation. This property is
	implementation, to which the	Optional. In most cases, leave this box
	DataSource object delegates behind	empty.
	the scenes when there is connection
	pooling or distributed transaction
	management being done.

MinPoolSize	Specifies the maximum number of	A valid numeric value. The default is 0.
	physical connections the pool
	should keep available at all times. 0
	(zero) indicates that there is no
	maximum.
	The pool size you set depends on the
	transaction volume and response
	time of the application. If the pool
	size is too big, you may end up with
	too many connections with the
	database.

JDBC/ODBC eWay Adapter User’s Guide

36

Sun Microsystems, Inc.

Image 36

Sun Microsystems JDBC/ODBC Adapter manual Outbound non-Transactional eWay -JDBC Connector Settings

Contents

EWAY JDBC/ODBC Adapter USER’S Guide Part Number Version Contents Transaction Support Levels Between Different Versions Activity Input and Output Stored Procedure Creating the Collaboration Definitions JavaCreate the Collaboration Business Rules Building and Deploying the prjJDBCBPEL Sample Project Building and Deploying the Project Running the Sample About Java Database Connectivity Jdbc Jdbc DriversWhat’s In This Chapter Type I JDBC-ODBC Bridge Type One Driver Type II Partial Java driver Type Two DriverPros Cons Pure Java driver for database middleware Type Three Driver Typical Type 3 Middleware Driver Configuration Type Four Driver Direct-to-database pure Java driver Typical Type 4 Driver Configuration About the JDBC/ODBC eWay What’s New in This ReleaseNew for Version About This Document ScopeJdbc eWay Javadoc Related Documents Sun Microsystems, Inc. Web SiteIntended Audience Text Conventions Documentation Feedback Installing the JDBC/ODBC eWay Installing the Jdbc eWay Installing the Jdbc eWay on an eGate supported system Ican 5.0 Project Migration Procedures After InstallationExtracting the Sample Projects and Javadocs Install Java Caps Import the ProjectDeploy the Project Installing Enterprise Manager eWay Plug-Ins To add plug-ins from the Enterprise Manager Viewing Alert Codes To View the eWay Alert CodesAlert Codes for the JDBC/ODBC eWay Alert Code\Description Description Details User Actions Duncommitted Chapter Section Creating and Configuring a Jdbc eWay Configuring the eWay Connectivity Map Properties To configure the eWay properties Connectivity Map with Components Transaction Support Levels Between Different Versions Example Transaction Support Levels Configuring the eWay Environment Properties To Configure the Environment Properties Outbound eWay Configuration Sections Include EWay Connectivity Map Properties Outbound XA eWay Configuration Settings Include EWay Environment PropertiesConnectivity Map Outbound eWay Properties Connectivity Map Outbound non-Transactional eWay Properties Inbound Jdbc eWay-Parameter Settings Inbound Jdbc eWay PropertiesOutbound Jdbc eWay Properties Name Description Required Value Jdbc Connector Settings Outbound Jdbc eWay-JDBC Connector SettingsIs Jdbc Connection Pool Datasource ConnectionPoolDataSource Connection Retry Settings Outbound Jdbc eWay-Connection Retry SettingsXADataSource or ConnectionPoolDataSource Outbound non-Transactional eWay -JDBC Connector Settings Outbound non-Transactional Jdbc eWay Properties Outbound non-Transactional eWay -JDBC Connector Settings Outbound non-Transactional eWay-Connection Retry Settings Outbound XA Jdbc eWay Properties Outbound XA Jdbc eWay-JDBC Connector Settings Is Jdbc XA DatasourceConnectionPoolDataSource or Outbound XA Jdbc eWay-Connection Retry Settings Outbound XA Jdbc eWay-Connection Retry Settings About the Database OTD Wizard Creating a New Jdbc OTD Select Wizard Type Connect To Database Select Database Objects Required Database Connection Fields includeSteps Required to Select Database Objects Include Select Tables/Views/Aliases Steps Required to Select Table/Views/Aliases Include Select Tables/Views/Aliases Database Wizard All Schemes Selected Tables/Views/Aliases window with a table selected Select Procedures Table/View Columns Steps Required to Select Stored Procedures Include Add Procedures Edit Resultset Add Prepared Statement Steps Required to Add Prepared Statements Include Prepared Statement Edit the Prepared Statement Parameters Specify the OTD Name Review SelectionsSteps Required to Specify the OTD Name Steps Required to Review Your OTD Selections Steps to Edit an Existing Jdbc OTD Steps to Edit the OTD from the Enterprise Designer Include Jdbc eWay Database Operations Bpel Activity Input and Output JDBC.ODBC Operations EInsight Operations Activity Input Activity Output Jdbc eWay Database Operations JCD Query Select Operation To perform a query operation on a table Insert Operation To perform an insert operation on a table Update Operation To perform an update operation on a table Stored Procedure Delete OperationTo perform a delete operation on a table Executing Stored Procedures Steps for executing the Stored Procedure include FileClient1.write Collaboration usability for a stored procedure ResultSet Prepared Statement Batch Operations Chapter Section Using JDBC/ODBC Operations Implementing the JDBC/ODBC eWay Sample Projects About the Jdbc eWay Sample Projects Sample input files Sample output JCD filesSample output Bpel files Sample Project Data Operations Used in the Jdbc Sample ProjectsAssigning Operations in JCD Assigning Operations in Bpel Running the Sample Projects About the eInsight Engine and eGate ComponentsSample Projects Drivers Running the SQL Script Importing a Sample Project Building and Deploying the prjJDBCJCD Sample Project Steps required to create the sample project Creating a Project Creating the OTDsSteps required to create a Jdbc Database OTD Creating a Connectivity Map Click Next the Add Prepared Statements Wizard appears Populating the Connectivity Map Steps required to create a new Connectivity MapSteps required to select a Jdbc External System Creating the Collaboration Definitions Java JcdDelete CollaborationSteps required to create the jcdDelete Collaboration JcdInsert Collaboration JcdPsSelect CollaborationSteps required to create the jcdInsert Collaboration Steps required to create the jcdPsSelect Collaboration JcdPsUpdate Collaboration Steps required to create the jcdPsUpdate CollaborationJcdTableSelect Collaboration Steps required to create the jcdTableSelect Collaboration Create the Collaboration Business Rules Creating the jcdDelete Business RulesCreating the jcdInsert Business Rules JcdInsert Business Rules Creating the jcdPsSelect Business Rules JcdPsSelect Business Rules Sample code from the jcdPsSelect Includes Creating the jcdTableSelect Business Rules JcdTableSelect Business Rules Sample code from the jcdTableSelect Includes Creating the jcdUpdate Business Rules Binding the eWay Components Creating an Environment Steps required to bind eWay components together Configuring the eWays Steps required to create an Environment Configuring the eWay Properties Steps required to configure the eWay propertiesFileClientIN eWay Property Settings FileClientOUT eWay Property Settings Configuring the Environment Explorer Properties Jdbc eWay Environment PropertiesSection Property Name Required Value Configuring the Integration Server Creating the Deployment ProfileFile eWay Environment Properties Creating and Starting the Domain Steps required to create the Deployment Profile Building and Deploying the Project Running the SampleSteps 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 Creating the Business Process FlowSteps required to create inbound and outbound DTD OTDs Steps to create a business process flow include Configuring the bpelPsInsert Modeling Elements Business Process ActivitiesBusiness Process Activity BpelPsInsert Business Process Configuring the bpelUpdate Modeling Elements BpelUpdate Business Process Steps required to configure the bpelUpdate business process Configuring the bpelDelete Modeling Elements Steps required to configure the bpelDelete business process BpelDelete Business Process Configuring the bpelTableSelect Modeling Elements BpelTableSelect Business Process BpelTableSelect Business Rule # BpelSelectTable Business Rule # Creating the Connectivity Map Steps required to create the Connectivity MapTo Select a Jdbc External System Binding the eWay Components To Select a Jdbc Business Process 109 FileClientOUT eWay FileClientIN eWay EaJDBCOUT eWay 111 112 113 114 Running the Sample Project 116 JDBC/ODBC Drivers Configuration Properties AS/400 Toolbox DriverOTD Wizard Database Connection Information AS/400 Database Connection Information Attunity Driver Environment PropertiesAS/400 Database Environment Properties Attunity Driver Database Connection Information Attunity Driver Database Environment Properties MySQL Connector/J Driver MySQL Connector/J Driver Database Connection InformationMySQL Connector/J Driver Environment Properties Parameter Value MaxIdleTime Default is PostgreSQL Driver PostgreSQL Driver Connection Information PostgreSQL Driver Environment Properties SyBase JConnect Driver Sybase JConnect Driver Database Connection InformationSybase JConnect Driver Environment Properties Sequelink DataDirect Informix Odbc Driver Sequelink DataDirect MS Access Odbc Driver MS Access Odbc Driver Database Connection Information MS Access Odbc Driver Environment Properties Teradata Driver Teradata Driver Database Connection InformationTeradata Driver Environment Properties Installing JDBC/ODBC Drivers Troubleshooting Index Jdbc Update count