beautypg.com

Jdbc connector settings – Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 38

background image

Chapter 3

Section 3.5

Setting Properties of the JDBC/ODBC eWay

eWay Environment Properties

JDBC/ODBC eWay Adapter User’s Guide

38

Sun Microsystems, Inc.

ƒ

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
driver that is used to implement the
ConnectionPoolDataSource or
XADataSource
interface. Change as
needed for your driver.

A valid class name.
For example:
com.attunity.jdbc.NvXADataSource

ClassNamefor
OtherInterfaces

For Sun Java Composite Application
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.

A valid class name.

ServerName

This setting specifies the host name
of the external database server.

Any valid string.

PortNumber

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

A valid port number.

DatabaseName

Specifies the name of the database
instance.

Any valid string.

User

Specifies the user name the eWay
uses to connect to the database.

Any valid string.

Password

Specifies the password used to
access the database.

Any valid string.

DriverProperties

The DataSource implementation may
need to execute additional methods
to assure a successful run. The
additional methods will need to be
identified in the Driver Properties.
You must ensure that the driver is
installed on both the Logical Host
machine and the Enterprise Designer
machine.

Set the driver properties according to
driver vendor's instruction. For
example:
setDefTdpName#DBSQL##setWorkspa
ce#Navigator##

Delimiter

This is the delimiter character to be
used in the DriverProperties prompt.

The default is #.