beautypg.com

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

Page 33

background image

Chapter 3

Section 3.5

Setting Properties of the JDBC/ODBC eWay

eWay Environment Properties

JDBC/ODBC eWay Adapter User’s Guide

33

Sun Microsystems, Inc.

JDBC Connector Settings

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

Table 7 Outbound JDBC eWay—JDBC Connector Settings

Name

Description

Required Value

Description

The description of the database.

A valid string. The configured default
is JDBC Connection Pool Datasource.

ClassName

Specifies the Java class in the JDBC
driver that is used to implement the
ConnectionPoolDataSource,
XADataSource interface. Change as
needed for your driver.

A valid class name.
For example:
com.ibm.as400.access.AS400JDBCCon
nectionPoolDataSource
See

JDBC/ODBC Drivers

on

page 117 for some of the popular
drivers you can use with this eWay.

ClassNamefor
OtherInterfaces

For Sun Java Composite Application
Platform Suite components such as
eTL that do not use
ConnectionPoolDataSource, use this
entry to enter the name of the driver
class. This entry is not used by the
JDBC 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 Connection Pool 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 #.