File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Error Numeric Overflow-oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error Numeric Overflow-oracle " Watch "Error Numeric Overflow-oracle " New topic

Error Numeric Overflow-oracle

archana gangaiah

Joined: Nov 02, 2010
Posts: 15
I'm using oracle 10g.

I am trying to get the sum of count of a column based on some collection column which is passed at run time using preparedStatement.
here is my code. The query works fine in sqldeveloper.

please help me....Thnks in adv

Many Thanks,
archana gangaiah

Joined: Nov 02, 2010
Posts: 15
Actually, I was trying to insert too big value for that column's datatype scale....:-)
Jan Cumps

Joined: Dec 20, 2006
Posts: 2491

Can you give us the complete error message?

And this line of code: collection1.add(resultSets.getString(2));
You select field 2 from the query, but the statement returns one field.

OCUP UML fundamental and ITIL foundation
youtube channel
archana gangaiah

Joined: Nov 02, 2010
Posts: 15
I forgot to comment that line while posting ... It is working..... Thanks for pointing out
It is sorta covered in the JavaRanch Style Guide.
subject: Error Numeric Overflow-oracle
Similar Threads
doubts in setDate(i,date,cal) API of preparedStatement
ejbLoad is not getting called
collections: why duplicates arent getting eradicated?
Executors in Threads
Collection program not working as expected