IBM Support

PK17590; 6.0.2.5: cntr0019e: ejb threw an unexpected (non-declared) exception wh

Download


Abstract

The generated code for findByData() was incorrect

Download Description

PK17590 resolves the following problem:

ERROR DESCRIPTION:
Using Cloudscape v10 with WebSphere v6.0.2 produces an error. The specific error message is:
[10/3/05 13:56:50:608 EDT] 0000003c ExceptionUtil E CNTR0019E:
EJB threw an unexpected (non-declared) exception during invocation of method "findByStoreIdAndSystemDefined". Exception data: com.ibm.ejs. persistence.EJSPersistenceException: find failed:; nested exception is:
SQL Exception: An attempt was made to get a data value of type
'SMALLINT' from a data value of type 'java.lang.Short'.
at com.ibm.commerce.tickler.objects.
EJSJDBCPersisterCMPTicklerReasonBean_8678267d.findByStoreIdAndSystemDefined
(EJSJDBCPersisterCMPTicklerReasonBean_8678267d.java:444)

The finder code created by the EJB deployer needs to be updated to produce the proper code that calls setShort().

ejbDeploy L3 has produced a fix for the problem that needs to be included in WebSphere Application Server.

LOCAL FIX:
None

PROBLEM SUMMARY

USERS AFFECTED:
All WebSphere Application Server users.

PROBLEM DESCRIPTION:
The generated code for findByData() was incorrect

RECOMMENDATION:
None

The generated code for the findByData method may not be using the correct setters with PreparedStatements. In this particular case, setObject() was being used instead of setShort().

PROBLEM CONCLUSION:
The generated code for findByData() was incorrect and the problem was resolved.

The fix for this APAR is currently targeted for inclusion in fixpack 6.0.2.7.

Please refer to the recommended updates page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Prerequisites

Please download the UpdateInstaller below to install this fix.

[{"PRLabel":"UpdateInstaller","PRLang":"US English","PRSize":"7250000","PRPlat":{"label":"AIX","code":"PF002"},"PRURL":"http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991"}]

Installation Instructions

Please review the readme.txt for detailed installation instructions.

[{"INLabel":"Readme","INLang":"US English","INSize":"6041","INURL":"ftp://public.dhe.ibm.com/software/websphere/appserv/support/fixes/PK17590/readme.txt"}]
Off
[{"DNLabel":"6.0.2.5-WS-WAS-IFPK17590","DNDate":"02-23-2006","DNLang":"US English","DNSize":"11168","DNPlat":{"label":"AIX","code":"PF002"},"DNURL":"ftp://public.dhe.ibm.com/software/websphere/appserv/support/fixes/PK17590/6.0.2.5-WS-WAS-IFPK17590.pak","DNURL_FTP":null,"DDURL":"http://public.dhe.ibm.com:7618;sw_websphere;appserv/support/fixes/PK17590/6.0.2.5-WS-WAS-IFPK17590.pak"}]

Technical Support

Contact IBM Support using SR (http://www-306.ibm.com/software/support/probsub.html), visit the WebSphere Application Server Support Web site (http://www.ibm.com/software/webservers/appserv/was/support/), or contact 1-800-IBM-SERV(U.S. only).

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"EJBDeploy (WSAD)","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.0.2.5","Edition":"Base","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSNVBF","label":"Runtimes for Java Technology"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Java SDK","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg24011704