Appendix A Target Types

Oracle targets

This section contains information about the following Oracle targets that are supported in the Component Builder:

The Oracle OCI and Oracle Thin targets both use the Oracle JDBC driver called oracle.jdbc.driver.OracleDriver , which is not provided with Application Integrator. To use Application Integrator with Oracle you must:

Install the Oracle JDBC driver on the machine where the Component Builder is running.
Install the Oracle JDBC driver on the machine where EAServer is running
Register the JDBC driver with the Component Builder. To do this, right-click the Stored Proc Component Builder, click Options, and enter the class path for the Oracle driver in the Stored Proc Component Builder Options window.

After you have installed and registered the Oracle JDBC driver, you can create connections for Oracle in the Component Builder.

Oracle OCI

The Oracle OCI connection type is used for connections to Oracle that use OCI networking. For these connections, the Oracle JDBC driver connects to Oracle using OCI.

The following values are needed to create a connection:

Table 3-4: Oracle OCI connection information
Information required	Valid values
Version	Valid values: 7 or 8
Address Type	TNSNAMES *SQLNET**
For an address type of TNSNAMES, you must provide the following information:
TNS Name	An entry from the TNSNAMES file
User Name	A valid Oracle user name
Password	A valid Oracle user password
For an address type of SQLNET, you must provide the following information:*
Host Name	Name of the machine where Oracle is running
Port Number	Port number Oracle is listening on
SID	Oracle system identifier
User Name	A valid Oracle user name
Password	A valid Oracle user password

For Oracle OCI, you can create methods automatically. Methods can use any of the following statement types:

Callable Statement
Prepared Statement
Statement

Oracle Thin

The Oracle Thin type is used for connections to Oracle that do not use OCI. For Oracle Thin connections, the Oracle JDBC driver functions like a pure Java Type IV JDBC driver.

The following values are needed to create a connection:

Table 3-5: Oracle Thin connection information
Information required	Valid values
Host Name	Name of the machine where Oracle is running
Port Number	Port number Oracle is listening on
SID	Oracle system identifier
User Name	A valid Oracle user name
Password	A valid Oracle user password

For Oracle Thin, you can create methods automatically. Methods can use any of the following statement types:

Callable Statement
Prepared Statement
Statement