url and driver
To establish a database connection, the URL and driver must be provided.
The Application Server Version 3 supports connection to JDBC databases and ODBC databases.
JDBC database
For a JDBC database, the URL consists of the following colon-separated elements: jdbc, the sub-protocol name, and the name of the database to be accessed. An example for a connection to the Sample database included with IBM DB2 is:
url="jdbc:db2:sample"
driver="COM.ibm.db2.jdbc.app.DB2Driver"
ODBC database
Use the Sun JDBC-to-ODBC bridge driver included in the Java Development Kit (JDK) or
another vendor's ODBC driver.
The url attribute specifies the location of the database. The driver attribute specifies the name of the driver to be used to establish the database connection.
If the database is an ODBC database, you can use an ODBC driver or the Sun JDBC-to-ODBC bridge included with the JDK. If you want to use an ODBC driver, refer to the driver documentation for instructions on specifying the database location (the url attribute) and the driver name.
In the case of the bridge, the url syntax is jdbc:odbc:database. An example is:
url="jdbc:odbc:autos"
driver="sun.jdbc.odbc.JdbcOdbcDriver"
To enable the Application Server to access the ODBC database,
use the ODBC Data Source Administrator to add the ODBC data source to the System DSN
configuration. To access the ODBC Administrator, click the ODBC icon on the Windows
NT Control Panel.