Subscribe to this APAR
By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.
| APAR (Authorized Program Analysis Report) |
Abstract
OSP-OTHER-INCORROUT TOOLBOX JDBC WITH BATCHED INPUT PARAMETERS
COMPRESSES INCORRECTLY
Error Description
If the Toolbox JDBC driver connects to an IBM i server at
current PTF levels, it will by default use varying length field
compression for input parameters. If any of the input
parameters are VARCHAR CCSID 65535 or VARCHAR FOR BIT DATA, the
compression routine will not properly compress these
parameters. This will result in data not aligning correctly, so
the error received from the host may vary. In the first
reported problem, the error was:
SQL0423 - Locator *N not valid
Problem Summary
If the Toolbox JDBC driver connects to an IBM i server at
current PTF levels, it will by default use varying length field
compression for input parameters. If any of the input parameters
are VARCHAR CCSID 65535 or VARCHAR FOR BIT DATA, the compression
routine will not properly compress these parameters. This will
result in data not aligning correctly, so the error received
from the host may vary. In the first reported problem, the error
was:
SQL0423 - Locator *N not valid
Problem Conclusion
The Toolbox JDBC driver has been updated to correctly compress
VARCHAR FOR BIT DATA and VARCHAR CCSID 65535 data types.
Temporary Fix
Comments
Circumvention
PTFs Available
R710 SI56273 
5317
R720 SI56274 
5310
Affected Modules
Affected Publications
Summary Information
| Status............................................ | CLOSED PER |
| HIPER........................................... | No |
| Component.................................. | 5770SS1ED |
| Failing Module.......................... | RCHMGR |
| Reported Release................... | R710 |
| Duplicate Of.............................. |
System i Support
IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information
Document Information
Modified date:
23 November 2015