Restrictions for database connections

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 Database Connection page that is 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).