Use the New Database Connection wizard or pages that are embedded
in other wizards to create a JDBC connection to a database.
Every database vendor has its own list of available JDBC drivers. To use
an unsupported JDBC driver, in the New Database Connection wizard or the Database
Connection page of another wizard, select the appropriate database vendor,
and then select Other from the JDBC driver pull-down
list. To connect by using this option, you must enter the name of the JDBC
driver class, the location of the class, and the correct form of the connection
URL. Because unsupported drivers are not tested, they are not recommended.
You can also create a generic JDBC connection to any database, by selecting Generic
JDBC from the list of database managers on the Connection Parameters
page and filling in the connection details.
The following restrictions apply to database connections in the workbench.
- Database connections that are created from the New Database
Connection wizard can be used only with the WebSphere® Application Server tools
that are packaged with this product.
- The New Database Connection wizard and the pages that are embedded in
other wizards do not create connections that can be used at run time.
- If you create a connection to a database and that connection is cancelled
in some way from outside this product (for example, in DB2® by using the force applications
all command), the workbench cannot detect that the connection has
been dropped.
- The JDBC catalog loader cannot determine whether a schema
object identifier should be delimited for locales other than English. For
identifiers that should be delimited, after you import a schema object, open
the schema or table editor to rename the schema object. Refer to your database
server documentation to determine when an identifier should be delimited.