beautypg.com

Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 36

background image

Chapter 3

Section 3.5

Setting Properties of the JDBC/ODBC eWay

eWay Environment Properties

JDBC/ODBC eWay Adapter User’s Guide

36

Sun Microsystems, Inc.

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 #.

DataSource
name

Specifies the name of the
XADataSource or
ConnectionPoolDataSource
implementation, to which the
DataSource object delegates behind
the scenes when there is connection
pooling or distributed transaction
management being done.

The name of the XADataSource or
ConnectionPoolDataSource
implementation. This property is
Optional. In most cases, leave this box
empty.

MinPoolSize

Specifies the maximum number of
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.

A valid numeric value. The default is 0.

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

Name

Description

Required Value