Upgrade From FW 2.1 To FW 2.2: SQL Count Can No Longer Be Casted Into Integer
Last updated on OCTOBER 18, 2016
Applies to:Oracle Utilities Customer Care and Billing - Version: 2.2.0
Oracle Utilities SDK - Version: 18.104.22.168 and later [Release: 2.2 and later]
Oracle Utilities Framework - Version: 2.2.0 and later [Release: 2.2 and later]
Oracle Enterprise Taxation Management - Version: 2.2.0 and later ]
Information in this document applies to any platform.
HQL change: CMPNIDAO.java: selecting count in sql can no longer be casted into (Integer). Instead of returning an integer, a long type is returned.
The workaround is to replace the following code in the CM java class:
count = (Integer)iter.next();
Long l = (Long)iter.next();
count = Integer.valueOf(l.intValue());
Is this workaround feasible? Is there a way to recover from the problem without modifying the current CM code?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms