This topic provides an overview and restrictions of database connections
that are created in the workbench.
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 Universal Database™ by
using the force applications all command), the workbench
cannot detect that the connection has been dropped.
- The SequeLink and DataDirect Connect JDBC drivers that are available from IBM® require
a pass code. The workbench sets the pass code so that you can use these drivers
when you use the New Database Connection wizard to import a data model to
build queries to run from the generated Web page. However, you cannot specify
one of these drivers in the Create Database Web Pages wizard where you are
asked to specify how to connect to the database from the generated Web page.
That is, these WebSphere branded
drivers cannot be used as the connection mechanism for the generated database
Web page.
- 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.
If you use more than one DataDirect SequeLink driver in a single
session, you might encounter problems with your connections.
If you
want to use a Merant JDBC driver, use either the DataDirect Connect JDBC type
4 driver or the DataDirect SequeLink type 3 driver. You can download these
JDBC drivers from the WebSphere Application Server site (ftp://ftp.software.ibm.com/software/websphere/info/tools/DataDirect/datadirect.htm).