Appendix A Target Types

JDBC-ODBC Bridge Targets

The JDBC-ODBC Bridge connection type allows you to create connections for any ODBC driver. These connections use a JDBC driver called the Sun JDBC-ODBC bridge (sun.jdbc.odbc.JdbcOdbcDriver ). Because the JDBC-ODBC bridge is provided with AI for Stored Procedures, you do not need to register it in the Component Builder. You must install and configure ODBC drivers for any connections that use the bridge on the machines where the Component Builder and Jaguar are running.

The following values are needed to create connections:

Table 3-6: JDBC-ODBC Bridge connection information
Information required	Valid values
ODBC Data Source	Name of an ODBC data source. To obtain this value: From the Start menu, point to Settings, then click Control Panel. Double-click the ODBC Icon. Select the User DSN tab. Enter the name for the driver shown in the Name column of the User Data Sources field in the ODBC Data Source field.
User Name	User name for the target database.
Password	Password for the target database.

For JDBC-ODBC bridge connections, your ability to create methods automatically depends on the underlying ODBC driver and database. The best way to determine whether methods can be created automatically is to try doing so for several stored procedures, and then verify that the resulting method definitions are correct.

Support for different statement types also depends on the underlying ODBC driver and database. Most JDBC-ODBC bridge drivers support all statement types, and all support the type Statement.