Products | Versions |
---|---|
TIBCO Hawk Database Adapter | - |
Not Applicable | - |
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 <Tibco home>\hawk\adapters\dbhma\oracle\samples, find the getMemoryUsage method, change the type of “Bytes” parameter from INTERGER to BIGINT.