Appendix A Target Types

Sybase targets

All Sybase targets use the jConnect. Because jConnect is provided with Application Integrator and EAServer, you do not need to register it with the Component Builder.

JDBC metadata support

Application Integrator for Stored Procedures provides a feature that makes it possible to automatically create component methods that invoke stored procedures. This feature creates methods by connecting to a database and retrieving information about stored procedures through JDBC metadata calls. The ability to create methods automatically requires that your JDBC driver correctly supports the metadata calls defined in the JDBC interface java.sql.DatabaseMetaData. Some drivers do not provide accurate metadata about stored procedures, and cause methods to be defined incorrectly. Some metadata problems can be recognized by the Component Builder. When problems are recognized, they are listed in the Creation Progress dialog, and in the Messages tab after methods are created. However, in some cases, the JDBC driver returns metadata that has a valid form but is incorrect. These kinds of metadata errors cannot be caught by the Component Builder, and result in incorrect method definitions.

For Sybase targets that support JDBC metadata, including Sybase Adaptive Server Anywhere and Adaptive Server Enterprise, the automatic method creation feature gives correct method definitions. For other targets, the correctness of method definitions is limited by the underlying JDBC driver.

Adaptive Server Anywhere

Components that invoke Adaptive Server Anywhere (ASA) stored procedures use connections of the type Sybase ASA. You must provide the following values to create a Sybase ASA connection:

Table 3-1: Sybase ASA connection information
Information required	Valid values
Host Name	Name of the machine running ASA.
Port Number	Port number that ASA is listening on.
Database	Database the connection accesses. This database is optional. If you do not specify a value, the connection accesses the default database for the specified user name.
User Name	User name for ASA.
Password	User password for ASA.

For Sybase ASA, methods can be created automatically and can use any of the following statement types:

Callable Statement
Prepared Statement
Statement

Sybase ASA does not return information about whether parameters can accept null values when methods are created automatically. Method parameters for ASA stored procedures are set to not nullable by default.

Adaptive Server Enterprise

Components that invoke Sybase Adaptive Server Enterprise stored procedures use connections of the type Sybase ASE. You must provide the following values to create a Sybase Adaptive Server Enterprise connection:

Table 3-2: Sybase ASE connection information
Information required	Valid values
Host Name	Name of the machine running Adaptive Server Enterprise.
Port Number	Port number that Adaptive Server Enterprise is listening on.
Database	Database containing the target stored procedure. This value is optional. If it is not specified, the connection accesses the default database for the specified user name.
User Name	User name for Adaptive Server Enterprise.
Password	User password for Adaptive Server Enterprise.

For Sybase Adaptive Server Enterprise, methods can be created automatically and can use any of the following statement types:

Callable Statement
Prepared Statement
Statement

Sybase Adaptive Server Enterprise does not return information about whether parameters can accept null values when methods are created automatically. Method parameters for Adaptive Server Enterprise stored procedures are set to not nullable by default.

DirectConnect

Sybase DirectConnect gateways provide access to heterogeneous data sources. This section includes information on creating Application Integrator components that access procedures through DirectConnect.

Components that access DirectConnect use connections of the type Sybase DirectConnect. The following values are needed to create a connection:

Table 3-3: Sybase DirectConnect connection information
Information required	Valid values
Host Name	Name of the host machine running DirectConnect.
Port Number	Port number DirectConnect is listening on.
Service Name	Name of the DirectConnect service that the connection accesses. When the connection is created, the Component Builder sets the jConnect SERVICENAME property to the value you specify.
User Name	User name for DirectConnect.
Password	User password for DirectConnect.

You must manually create methods for DirectConnect target stored procedures. When you create methods manually, the best source of information for defining the method correctly is the source code for the target stored procedures.