Release Notes - IBM Data Studio pureQuery Runtime Version 1.1.2

Contents

About this release

For the most up to date versions of these release notes, see the IBM® Data Studio information center.

New in this release

This release adds support from annotated methods for the RowHandler interface. It also adds two new interfaces:
ParameterHandler
Use this interface to pass values into an SQL statement before that statement is run.
CallHandlerWithParameters
Use this interface when you want to map the results of a call to an SQL stored procedure to an object of type <T>. With this interface, you can also update the values of the OUT and INOUT parameters in the pureQuery bean or Map object that you used to pass values to the CALL statement.

Problems fixed in this release

pureQuery incorrectly identified the isolation level for bound packages
This problem caused an incorrect isolation level to be used, or a "Package not found" condition. The latter usually appears as SQLCODE -805.
pureQuery generated long package names by default for DB2® for z/OS® Version 8 (Compatibility Mode) data servers
For data servers that cannot accept names more than 8 characters long for packages, the generator truncates the root package name that you specify when you generate the implementation for an interface that defines annotated methods. The generator was not truncating the root package name for DB2 for z/OS Version 8 (Compatibility Mode) data servers.
Multi-row INSERT fails when run as static SQL against DB2 for z/OS
When running an INSERT statement using an annotated method that takes a collection of objects as input, pureQuery uses batch processing and, if possible, the data server's capability for performing multi-row inserts. Even if such an INSERT statement used the correct multi-row syntax when bound into a package, pureQuery did not build the correct command sequence when running the statement. This problem resulted in the underlying JDBC driver returning ERRORCODE -4228.
SQLCODE -104 error during the bind of a package containing a SELECT...INTO statement with a column function
When executing in static SQL, pureQuery uses a SELECT...INTO statement (singleton SELECT) if it detects that the application can receive a result set of only one row. Including column functions in the set of returned values for the statement could cause an SQLCODE -104 error during the bind of the package that contained the statement.

Hardware and software requirements

Information about supported platforms and disk space requirements.
Hardware requirements
Disk space
On Windows®: 80MB
On all other supported operating systems: 80MB
Memory
128MB
Software requirements
Supported operating systems
Microsoft® Windows 2000 Professional x86-32 with Service Pack 4
Microsoft Windows 2000 Advanced Server x86-32 with Service Pack 4
Microsoft Windows 2000 Server x86-32 with Service Pack 4
Microsoft Windows Server 2003 Enterprise Edition x86-32 with Service Pack 1
Microsoft Windows Server 2003 Enterprise Edition x86-64 (Run in 32 bit mode) with Service Pack 1
Microsoft Windows Server 2003 Standard Edition x86-32 with Service Pack 1
Microsoft Windows Server 2003 Standard Edition x86-64 (Run in 32 bit mode) with Service Pack 1
Microsoft Windows XP Professional x86-32 with Service Pack 1 or 2
Microsoft Windows XP Professional x86-64 Edition (Run in 32-bit mode) with Service Pack 1 or 2
Red Hat Enterprise Linux® (RHEL) 4.0 and 5.0 AS/ES x86-32
SuSE Linux Enterprise Server (SLES) Version 9 (all service packs; running in 32-bit mode) and Version 10
IBM AIX 5L™ (32-bit and 64-bit) Version 5.2 and Version 5.3
Sun Solaris SPARC Version 9 (32-bit and 64-bit)
Sun Solaris SPARC Version 10 (64-bit)
Java™ Development Kit
JDK 5 (1.5.0) or higher
Java Database Connectivity
For database connections, a driver that is compliant with JDBC 3.0 is required. If you use the "IBM DB2 Driver for JDBC and SQLJ" driver, use level 3.51 or higher of this driver.

Installing IBM Data Studio pureQuery Runtime Version 1.1.2

Instructions for installing this product are located in the installation guide in the product download and in the product information center, which is located at http://publib.boulder.ibm.com/infocenter/dstudio/v1r1m0/index.jsp.

Documentation for IBM Data Studio pureQuery Runtime 1.1.2

The documentation for this product is located in the IBM Data Studio information center under the topic Developing pureQuery applications.

Known problems

This release contains the following known limitations and problems:

pureQuery
  • When viewing license documents in the license directory of your installation, use text viewers that support your language.
    • On Windows, you can use Notepad as long as the support for your language is installed on your system.
    • On Linux and UNIX®, simple text editors such as vi do not display license documents correctly. Contact your system administrator to find out which viewer to use.
  • If you are using the annotated method programming style, a generated implementation class does not compile if both of these conditions are true:
    • One or more of the annotated methods in your interface contain parameters that are subclasses of the Map interface.
    • Your interface does not import the Map interface.
    The workaround is to add the statement import java.util.Map; to your interface and generate the implementation class again.
  • If you are using the annotated method programming style and none of the methods in an interface use annotations or if the interface contains no methods, the pureQuery Generator throws a null pointer exception when you try to generate an implementation of the interface. The workaround is to make sure you annotate at least one method in an interface.

Notices

This information was developed for products and services offered in the U.S.A.

IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not grant you any license to these patents. You can send license inquiries, in writing, to:IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106-0032, Japan

The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.

This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.

IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:

IBM Corporation
J46A/G4
555 Bailey Avenue
San Jose, CA 95141-1003
U.S.A.

Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.

The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement or any equivalent agreement between us.

Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.

All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.

COPYRIGHT LICENSE:

This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs.

Trademarks

The following terms are trademarks of International Business Machines Corporation in the United States, other countries, or both:

IBM
DB2
z/OS
iSeries
Informix
Rational
WebSphere
DB2 Universal Database

Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.

Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.

Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Other company, product, or service names may be trademarks or service marks of others.