Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Configuring: Inbound JDBC Adapter 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

Using the Environment Properties Editor

To Configure the Environment Properties

Configuring DB2 Adapter Environment Properties

Inbound DB2 Adapter Environment Properties

Outbound DB2 Adapter Environment Properties

eTL Environment Properties

Configuring DB2 Connect Adapter Environment Properties

Inbound DB2 Connect Adapter - Parameter Settings

Outbound DB2 Connect Adapter - JDBC Connector Settings

Outbound DB2 Connect Adapter - Connection Retry Settings

Outbound DB2 Connect non-Transactional Adapter - JDBC Connector Settings

Outbound DB2 Connect non-Transactional Adapter - Connection Retry Settings

Outbound DB2 Connect XA Adapter - JDBC Connector Settings

Outbound DB2 Connect XA Adapter - Connection Retry Settings

Inbound DB2 Connect Type 4 Adapter - Parameter Settings

Outbound DB2 Connect Type 4 Adapter - JDBC Connector Settings

Outbound DB2 Connect Type 4 Adapter - Connection Retry Settings

Outbound DB2 Connect non-Transactional Type 4 Adapter - JDBC Connector Settings

Outbound DB2 Connect non-Transactional Type 4 Adapter - Connection Retry Settings

Outbound DB2 Connect Type 4 XA Adapter - JDBC Connector Settings

Outbound DB2 Connect Type 4 XA Adapter - Connection Retry Settings

Configuring the Informix Adapter Environment Properties

Informix Adapter External System Properties

Inbound Informix Adapter External System Properties

Outbound Informix Adapter External System Properties

Outbound non-Transactional InformixAdapter External System Properties

Outbound XA Informix Adapter External System Properties

Configuring Oracle Adapter Environment Properties

Inbound Oracle Adapter Environment Properties

Outbound Oracle Adapter Environment Properties

Outbound Oracle Adapter Environment Properties with XA support

Configuring SQL Server Adapter Environment Properties

Inbound SQL Server Adapter Properties

Outbound SQL Server Adapter Properties

Outbound SQL Server Non-Transactional Adapter Properties

Outbound SQL Server XA Adapter Properties

Configuring the Sybase Adapter Environment Properties

Sybase Adapter External Properties

Inbound Sybase Adapter

Outbound Sybase Adapter

Outbound XA Sybase Adapter

Outbound Sybase non-Transactional Adapter

Configuring JDBC/ODBC Adapter Environment Properties

To Configure the Environment Properties

JDBC Adapter Environment Properties

Inbound JDBC Adapter Properties

Outbound JDBC Adapter Properties

Outbound non-Transactional JDBC Adapter Properties

Outbound XA JDBC Adapter Properties

Configuring VSAM Adapter Environment Properties

Inbound VSAM Adapter Properties

Outbound VSAM CP Adapter Properties

Outbound VSAM non-Transactional Adapter Properties

Configuring Java CAPS Environment Components for Web Server Adapters

Configuring 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

Inbound JDBC Adapter Properties

Before deploying your adapter, you will need to set the Environment properties. The Inbound JDBC Adapter includes the following configuration section:

Details for the Inbound JDBC Adapter Parameter Settings are listed in the following table.

Inbound JDBC Adapter—Parameter Settings

Name
Description
Required Value
Description
The description of the database.
A valid string.
ClassName
Displays the Java class in the JDBC driver that is used to implement the Driver Manager interface. Change this as needed for your driver.
A valid class name.

See the JDBC/ODBC Drivers section for some of the popular drivers you can use with this adapter.

URL
This is the JDBC URL required to gain access to the database. The URL usually starts with jdbc; followed by <subprotocol> and ends with information that identifies the data source, as follows:

jdbc:<driver>:<data-source-name>[;<attribute-name>=<attribute-value>]

If you do not select URL in the connection method this parameter is ignored. For more information on the JDBC URL, please consult the documentation of your specific driver.

The applicable JDBC URL.

See the JDBC/ODBC Drivers section for some of the popular drivers you can use with this adapter.

User
Specifies the user name the adapter uses to connect to the database.
Any valid string.
Password
Specifies the password used to access the database.
Any valid string.