Appendix A Target Types

About JDBC URLs

A JDBC URL is an address used by JDBC drivers to connect to a database or server. When you create connections in the Component Builder, you are prompted for information needed to derive the URL. The Generic connection type in the Component Builder allows you to enter an URL manually.

Different JDBC drivers have slightly different URL formats.
The following example shows the Sybase JDBC protocol and subprotocol information contained in the URL:

Figure 3-1: Sybase JDBC URL composition

The driver portion is always jdbc.

The protocol (in this case is sybase.Tds) specifies the JDBC driver and the native database protocol.

The host name and port number identify the machine that contains the database where the target stored procedures reside.

For Sybase, you can also specify a database name as part of the URL. For example:

jdbc:sybase:Tds:localhost:5000/dbase1

where the database name (dbase1) is appended to the URL.