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.