From: zigzagdna on


I am using JDK 1.6 on HP UNIX 11i. I developed a program which uses
lot of JDBC calls to an Oracle database. My program processes some
records from a file write information to Oracle. But after sometime it
gives some Java SQL Exception: Numeric Overflow. However, there is no
Oracle error given.

When I delete the rows from the file which were successful in 1st run;
then run the program again; it does not give any error for the rows it
was erroring earlier. Then after processing some rows it gives same
Numerical Exception error.
I was pretty sure that Numerical Overflow Exception is misleading;
something else is going on.

I ran the program on another machine with same Java version, same
memory parameters in java command line and my program works fine,

I looked in /var/admin/syslog.. on first machine; could not find
anything. Clearly, java is running out of some resource on 1st
machine; how can I troubleshoot this problem.

THANKS A LOT.