Chapter 3

Section 3.5

Setting Properties of the JDBC/ODBC eWay

eWay Environment Properties

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

A valid class name.

 

driver that is used to implement the

For example:

 

ConnectionPoolDataSource,

com.ibm.as400.access.AS400JDBCCon

 

XADataSource interface. Change as

nectionPoolDataSource

 

needed for your driver.

See JDBC/ODBC Drivers on

 

 

page 117 for some of the popular

 

 

drivers you can use with this eWay.

 

 

 

ClassNamefor

For Sun Java Composite Application

A valid class name.

OtherInterfaces

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.

 

 

 

 

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

 

 

 

 

JDBC/ODBC eWay Adapter User’s Guide

33

Sun Microsystems, Inc.

Page 33
Image 33
Sun Microsystems JDBC/ODBC Adapter manual Jdbc Connector Settings, Outbound Jdbc eWay-JDBC Connector Settings