Is Jdbc XA Datasource | Sun Microsystems JDBC/ODBC Adapter specs

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

Connection Retry Settings

JDBC Connector Settings

Details for the JDBC Connector Settings used by the external database are detailed in Table 11.

Table 11 Outbound XA JDBC eWay—JDBC Connector Settings

Name	Description	Required Value

Description	The description of the database.	A valid string. The configured default
		is JDBC XA Datasource.

ClassName	Specifies the Java class in the JDBC	A valid class name.
	driver that is used to implement the	For example:
	ConnectionPoolDataSource or	com.attunity.jdbc.NvXADataSource
	XADataSource interface. Change as
	needed for your driver.

ClassNamefor	For Sun Java Composite Application	A valid class name.
OtherInterfaces	Platform Suite components that do
	not use ConnectionPoolDataSource,
	use this entry to enter the name of
	the driver class. This class will not be
	used by the eWay.

ServerName	This setting specifies the host name	Any valid string.
	of the external database server.

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 DataSource implementation may	Set the driver properties according to
	need to execute additional methods	driver vendor's instruction. For
	to assure a successful run. The	example:
	additional methods will need to be	setDefTdpName#DBSQL##setWorkspa
	identified in the Driver Properties.	ce#Navigator##
	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.

JDBC/ODBC eWay Adapter User’s Guide

38

Sun Microsystems, Inc.

Image 38

Sun Microsystems JDBC/ODBC Adapter manual Outbound XA Jdbc eWay-JDBC Connector Settings, Is Jdbc XA Datasource

Contents

EWAY JDBC/ODBC Adapter USER’S Guide Part Number Version Contents Transaction Support Levels Between Different Versions Activity Input and Output Create the Collaboration Business Rules Stored ProcedureCreating the Collaboration Definitions Java Building and Deploying the prjJDBCBPEL Sample Project Building and Deploying the Project Running the Sample What’s In This Chapter About Java Database Connectivity JdbcJdbc Drivers Type I JDBC-ODBC Bridge Type One Driver Pros Type II Partial Java driverType Two Driver 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 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 Conventions Documentation Feedback Installing the JDBC/ODBC eWay Installing the Jdbc 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 Installing Enterprise Manager eWay Plug-Ins To add plug-ins from the Enterprise Manager Alert Codes for the JDBC/ODBC eWay Viewing Alert CodesTo View the eWay Alert Codes 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 Connectivity Map Outbound eWay Properties Outbound XA eWay Configuration Settings IncludeEWay Environment Properties Connectivity Map Outbound non-Transactional eWay Properties Outbound Jdbc eWay Properties Inbound Jdbc eWay-Parameter SettingsInbound Jdbc eWay Properties Name Description Required Value Is Jdbc Connection Pool Datasource Jdbc Connector SettingsOutbound Jdbc eWay-JDBC Connector Settings ConnectionPoolDataSource XADataSource or ConnectionPoolDataSource Connection Retry SettingsOutbound Jdbc eWay-Connection Retry Settings 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 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 About the Database OTD Wizard Creating a New Jdbc OTD Select Wizard Type Connect To Database Steps Required to Select Database Objects Include Select Database ObjectsRequired Database Connection Fields 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 Steps Required to Specify the OTD Name Specify the OTD NameReview Selections 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 To perform a delete operation on a table Stored ProcedureDelete Operation 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 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 Bpel Sample Projects Drivers Running the Sample ProjectsAbout the eInsight Engine and eGate Components Running the SQL Script Importing a Sample Project Building and Deploying the prjJDBCJCD Sample Project Steps required to create the sample project Steps required to create a Jdbc Database OTD Creating a ProjectCreating the OTDs Creating a Connectivity Map Click Next the Add Prepared Statements Wizard appears 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 Steps required to create the jcdInsert Collaboration JcdInsert CollaborationJcdPsSelect Collaboration Steps required to create the jcdPsSelect Collaboration JcdTableSelect Collaboration JcdPsUpdate CollaborationSteps required to create the jcdPsUpdate 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 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 FileClientIN eWay Property Settings Configuring the eWay PropertiesSteps required to configure the eWay properties 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 Creating and Starting the Domain Steps required to create the Deployment Profile Steps required to create and start the domain Building and Deploying the ProjectRunning the Sample Build the Project Building 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 include Business 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 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 # 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 Process 109 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 Information AS/400 Database Environment Properties Attunity DriverEnvironment Properties Attunity Driver Database Connection Information Attunity Driver Database Environment Properties MySQL Connector/J Driver Environment Properties MySQL Connector/J DriverMySQL Connector/J Driver Database Connection Information Parameter Value MaxIdleTime Default is PostgreSQL Driver PostgreSQL Driver Connection Information 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 Database Connection Information MS Access Odbc Driver Environment Properties Teradata Driver Environment Properties Teradata DriverTeradata Driver Database Connection Information Installing JDBC/ODBC Drivers Troubleshooting Index Jdbc Update count