webMethods JDBC Adapter 6.0.3 Feature Pack 1 readme

(1-Q2NMY)
During configuration of the StoredProcedureWithSignature service, the Output Field’s values will change if the user changes an IN expression from '?' to a 'fixed value', or vice versa. To resolve this, after making changes to the IN expression field, the user will need to select or type the output field name again.

2.2 Driver Limitations

Database/Platform Affected	Driver	Limitation Description and Solution
DB2 UDB 7.2 and 8.1	Type 2 App, Type 3 Net	(1-Q1MPS/1-Q1N5I) Because StoredProcedureWithSignature introspects Character and Timestamp SQLTypes as NULL JDBCTypes, the service cannot be executed. Use the StoredProcedure service template.
DB2 UDB 7.2 and 8.1	Type 2 App, Type 3 Net	(1-Q1N2W) DB2 UDB drivers do not display Functions in the Procedure Name drop-down list. Use the StoredProcedure or StoredProcedureNotification service template and type the function name in the Procedure Name field.
DB2 UDB 7.2 and 8.1	Type 2 App	(1-Q1N7P) When using StoredProcedureWithSignature, only one result set is returned regardless of the number of result sets expected. Use the StoredProcedure service template.
DB2 UDB 7.2 and 8.1	Type 2 App	(1-Q4SQN/1-Q5HPF) If the StoredProcedureWithSignature or StoredProcedureNotificationWithSignature is configured with a stored procedure that has 10 IN, 10 INOUT, and 20 Result Sets, the service will crash the IS when it is invoked. Use the StoredProcedure or StoredProcedureNotification service template.
Oracle 8i, 9i, and 10g	Oracle 8i, 9i, and 10g Thin and OCI JDBC classes12 drivers	(1-Q5I30) StoredProcedureWithSignature and StoredProcedureNotificationWithSignature do not work with stored procedures containing a parameter of type Oracle Cursor whenthe ref cursor is declared as a cursor type defined as a strong type with the %ROWTYPE attribute. Define the ref cursor as a weak type.
DB2 for OS/390 V7	Type 3 Net	(1-Q7HNW) When using DB2 Connect 7.2, StoredProcedureWithSignature and StoredProcedureNotificationWithSignature are supported only on DB2 for OS/390 V6. Use the StoredProcedure or StoredProcedureNotification service template.

3.0 Usage Notes

None.

4.0 Feature Pack Contents

This feature pack contains the following new features:

StoredProcedureWithSignature - This template simplifies configuring a stored procedure service by providing automatic signature introspection. The user no longer needs to reference and enter the parameters. Signatures of in, out, inout, and oracle cursor parameter types and return values are automatically listed in the configuration tab.

StoredProcedureNotificationWithSignature - This template simplifies configuring stored procedure notifications by providing automatic signature introspection. The user no longer needs to reference and enter the parameters. Signatures of in, out, inout, and oracle cursor parameter types and return values are automatically listed in the configuration tab.

UpdateServiceSchema - This service programmatically changes the schema settings for an adapter service.

UpdateNotificationSchema - This service programmatically changes the schema settings for an adapter notification.

5.0 Feature Pack Requirements

The webMethods JDBC Adapter 6.0.3 Feature Pack 1 requires webMethods Integration Server version 6.1 or later.

6.0 Platform Support

The webMethods JDBC Adapter 6.0.3 Feature Pack 1 is supported on the same platforms as webMethods JDBC Adapter 6.0.3, and supports all the same databases except DB2 for AS/400 and Teradata.

7.0 Installation

7.1 Installation of the Feature Pack

1. Download the webMethods Installer from the webMethods Advantage Web site at http://advantage.webmethods.com.

2. If you are installing the Feature Pack on an existing installation of the Integration Server, shut down the server if it is running.

3. Start the webMethods Installer and follow the instructions in the wizard.

4. Choose the webMethods platform version. If you are installing the Feature Pack on an existing installation of the Integration Server, be sure to choose the same version of the webMethods platform as the existing installation of the Integration Server. Specify the webMethods Integration Platform installation directory (by default, webMethods6).

5. In the component selection list, navigate to webMethods Integration Platform > Adapters > webMethods JDBC Adapter and then select Feature Pack 1.

6. Complete the steps in the webMethods Installer wizard.

7. Restart the Integration Server if you stopped it in step 2.

7.2 Uninstallation of the Feature Pack

1. Shutdown the Integration Server on which you installed the Feature Pack.

2. Start the webMethods Uninstaller.

3. In the component selection list, navigate to webMethods Integration Platform > Adapters > webMethods JDBC Adapter and then select Feature Pack 1 as the component to uninstall.

4. Complete the steps in the webMethods Uninstaller wizard.

8.0 Globalization

webMethods JDBC Adapter 6.0.3 Feature Pack 1 conforms to the internationalization standards of webMethods and includes support for operation in any country, locale or language. This feature pack has been tested on non-English configurations, including common Japanese configurations, and with non-ASCII data.

This feature pack does not require an updated language pack. Existing installations that have installed a language pack may install this feature pack without any additional modifications.

If you expect to display non-English data in your webMethods tools, make sure an appropriate font is installed in your operating environment. If you see hollow boxes or black squares where you expect to see non-English data, modify your JRE font.properties file to reference the font. For information on modifying your font.properties file, go to Sun's Java website. For information on the JRE provided with this release, go to:

http://java.sun.com/j2se/1.4.2/docs/guide/intl/fontprop.html

Or refer to the document located at:

http://www.unicode.org/help/display_problems.html.

8.1 Database Configuration for Globalization

The configuration of the database you use with webMethods JDBC Adapter 6.0.3 affects the characters the database can contain. If you select a non-Unicode encoding for the database, characters from outside that encoding will be lost when you store webMethods JDBC Adapter 6.0.3 data in the database. webMethods recommends that you use the most appropriate Unicode encoding for your database character set. For instructions on choosing and setting the character encoding for your database and environment, see the webMethods Integration Platform Installation Guide and your database vendor's documentation.

8.2 Known Globalization Issues

None.

9.0 Documentation

The webMethods JDBC Adapter 6.0.3 Feature Pack 1 technical documentation can be found in the IntegrationServer\packages\WmJDBCAdapter\doc directory or on the webMethods Bookshelf. The following manual is provided as a PDF file:

- webMethods JDBC Adapter 6.0.3 Feature Pack 1 Addendum

To view the documentation, you must have Adobe Acrobat Reader 4.0 or later.

9.1 Documentation Changes

None.

10.0 Copyright Information

webMethods Administrator, webMethods Broker, webMethods Dashboard, webMethods Developer, webMethods Glue, webMethods Fabric, webMethods Installer, webMethods Integration Server, webMethods Mainframe, webMethods Manager, webMethods Mobile, webMethods Modeler, webMethods Monitor, webMethods Optimize, webMethods Portal, webMethods Trading Networks, webMethods Workflow, and the webMethods logo are trademarks of webMethods, Inc. "webMethods" is a registered trademark of webMethods, Inc.

All other marks are the property of their respective owners.

11.0 Contacting webMethods

Authorized technical support contacts can reach webMethods Technical Services for support via:

webMethods Advantage Web site

E-mail: support@webMethods.com

US Phone: 1-888-222-8215

Europe/EMEA Phone: +800-963-84-637 or +31-207783640

Asia/Pacific Phone: +612-8913-1198 or +656-389-3222

Self-service support is also available in the webMethods Advantage Knowledge Base and in the Advantage Customer Forums.

12.0 View the Product readme

You can view the readme for the current release of webMethods JDBC Adapter 6.0.3. To do so, see the readme on the webMethods Bookshelf.