Relational database tools - release notes


1.0 Changes from the previous release
2.0 Limitations
   2.1 Editing a Java stored procedure imported from an EAR file
   2.2 SQL Server embedded drivers must be unlocked before first use
3.0 Known problems
   3.1 Multi-table graphs on Informix
   3.2 Repeated connections or disconnections from Cloudscape causes an error
   3.3 New Table wizard generates bad SQL if reserved words are used as column names

1.0 Changes from the previous release

If you get this message IWAS0126E and you are trying to use "ojdbc14.jar" from data connection wizard, this is because this driver is meant to use JDK 1.4.x . You can use this driver on test environment runtime 5.1 or above where JDK level is appropreate but not from base WSAD using connection wizard WSAD 5.1.x where it's JDK is 1.3.1.

2.0 Limitations

2.1 Editing a Java stored procedure imported from an EAR file

When you edit a JavaTM stored procedure that is contained in a web project that was imported from an EAR file, the Java stored procedure source shown is retrieved from the DB2® server. If the source does not exist in the DB server, a file dialog opens to prompt you for the location of the source file.

If the web project was exported to an EAR file with the option to export source files, then the Java stored procedure source file can be found in the JavaSource folder.

2.2 SQL Server embedded drivers must be unlocked before first use

The SQL Server embedded drivers that are shipped with WebSphere Application Server cannot be used unless they are first unlocked by the WebSphere Application Server runtime. If you want to use these drivers, you must obtain your Connection object through the WebSphere Application Sever connection manager, rather than obtaining it directly.

3.0 Known problems

3.1 Multi-table graphs on Informix

Multi-table graphs are not supported on Informix® Dynamic Server 9.3

3.2 Repeated connections or disconnections from Cloudscape causes an error

When you make repeated connections and/or disconnections from a CloudscapeTM database, you get a catalog error.

There are some other problems with Cloudscape on the J9 JVM.

Work around - Try J9 2.1.2, or switch to a different JVM

3.3 New Table wizard generates bad SQL if reserved words are used as column names

The New Table wizard will generate SQL that contains a syntax error when exported to the server if: a) Reserved words are entered for column names, and b) The user does not manually enter double-quotes as part of the column name

Work around - Do not use reserved words for column names.

Return to the main readme file