Appendix A Target Types

Generic Targets

The Generic connection type allows you to create connections that use third-party JDBC drivers. This type allows you to enter a JDBC driver class and JDBC URL for a connection explicitly.

To use Application Integrator with a non-Sybase JDBC driver you must do the following:

Install the JDBC driver on the machine where the Component Builder is running
Install the JDBC driver on the machine where Jaguar 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 driver in the Stored Proc Component Builder Options window.

The following values are needed to create connections:

Table 3-7: Generic connection information
Information required	Valid values
JDBC Driver	Java class name of the JDBC driver.
URL	A valid JDBC URL for the JDBC driver specified. See "About JDBC URLs" for detailed information.
User Name	User name for the database or machine that contains the target stored procedure.
Password	User password for the database or machine that contains the target stored procedure.

For generic connections, the ability to create methods automatically depends on whether the JDBC driver supports metadata calls. The best way to determine whether methods can be created automatically is to try doing so for several stored procedures, and verify whether the resulting method definitions are correct.

Support for different statement types also depends on the underlying JDBC driver and database. See the documentation for the JDBC driver for information about supported driver types.