How to deal with the Numeric Overflow error when invoking the GetMemoryUsage method to an Oracle database?

How to deal with the Numeric Overflow error when invoking the GetMemoryUsage method to an Oracle database?

book

Article ID: KB0088940

calendar_today

Updated On:

Products Versions
TIBCO Hawk Database Adapter -
Not Applicable -

Description

Resolution:
Description:
============
When invoking the GetMemoryUsage method to an Oracle database using TIBCO Hawk™ Database Adapter, the following error pops up, “Application method failed because of  java.sql.SQLException:”
If you run the SQL command “select pool, name, bytes from v$sgastat” which is used by the GetMemoryUsage method, you will find that some returned value is larger than the length of INTERGER (2147483648), so it will throw the Numeric overflow error


Environment:
============
o TIBCO Hawk™ Database Adapter v4.6

Resolution:
===========
Please open the oracleDBHma.xml under &ltTibco home>\hawk\adapters\dbhma\oracle\samples, find the getMemoryUsage method, change the type of “Bytes” parameter from INTERGER to BIGINT.

Issue/Introduction

How to deal with the Numeric Overflow error when invoking the GetMemoryUsage method to an Oracle database?