JR43211: CMVC 223666 - AVOID GETTING AN SQL ERROR WHEN SEARCHING THE CATALOG FOR A LONG STRING IN CMC
Closed as program error.
When searching for a long string in the catalog search field an unfriendly exception appears on the CMC UI. This unfriendly exception is unclear to business users and they are unable to understand it. The problem occurs when the search string is longer than the database column definition.
USERS AFFECTED: WebSphere Commerce Users who use the catalog search field when the database type is DB2 and the search string is longer than the corresponding column in the database. PROBLEM ABSTRACT: When using the catalog search capability of the Commerce Management Center, an exception appears in the tool if the database is DB2 and the search value is a long string. BUSINESS IMPACT: The unfriendly exception is not clear for business users who are unfamiliar with SQL exception syntax RECOMMENDATION:
The code was updated to return no search result instead of printing the exception when searching for a long search string which exceeds the column length in database. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Reported component name
WC BUS EDITION
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
WC BUS EDITION
Fixed component ID
Applicable component levels