Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Configuring: Environment Properties
 

Classic Java CAPS

Configuring JMS Clients

Configuring Java CAPS for SSL Support

Configuring Java CAPS Business Processes

Configuring Environment Components for the Sun Business Process Manager

Configuring Sun Master Indexes (Repository)

Configuring Java CAPS Project Components for Application Adapters

Configuring Java CAPS Project Components for Communication Adapters

Configuring Java CAPS Project Components for Database Adapters

Configuring Java CAPS Project Components for Web Server Adapters

Configuring Java CAPS Environment Components for Application Adapters

Configuring Java CAPS Environment Components for Communications Adapters

Configuring Java CAPS Environment Components for Database Adapters

Configuring Java CAPS Environment Components for Web Server Adapters

Configuring JDBC/ODBC Drivers

About JDBC/ODBC Drivers

Configuring JDBC/ODBC Drivers

AS/400 Toolbox Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Attunity Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

MySQL Connector/J Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

PostgreSQL Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

SyBase JConnect Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sequelink DataDirect Informix ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sequelink DataDirect MS Access ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Teradata Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Troubleshooting

Installing JDBC/ODBC Drivers

Configuring SAP R/3 for the SAP BAPI Adapter

Configuring Secure Network Communications for SAP

Configuring Siebel EAI Workflows

Importing an SNA Custom Handshake Class

Configuring WebLogic for Asynchronous Communication

Configuring Master Index (Repository) Connectivity and Environments

Related Topics for Sun Adapter for Batch/FTP

Java EE Based Components

Broadcasting Master Index Updates to External Systems

Configuring Sun Master Indexes

Environment Properties

Use Table 6 to configure the environment properties for the specified JDBC/ODBC driver.

MySQL Connector/J Driver Environment Properties

Parameter
Value
Description
JDBC Connection Pool Datasource
ClassName
ccom.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
ClassNamefor

OtherInterfaces

ServerName
Server name of the machine hosting the database.
PortNumber
server-port

Note - NOTE: Default server port is 3306.

DatabaseName
database-name
User
Login name of the account used to access the database.
Password
Password associated with the login account name used to connect to the database.
DriverProperties
Delimiter
The default is #.
DataSourceName
MinPoolSize
The default is 0.
MaxPoolSize
The default is 10.
MaxIdleTime
The default is 0.

Note - It is not mandatory to enter driver properties in the Outbound JDBC eWay Environment properties for MySQL.