aspose file tools*
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

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 2476

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
I agree. Here's the link:
subject: Error Numeric Overflow-oracle
Similar Threads
collections: why duplicates arent getting eradicated?
Collection program not working as expected
Executors in Threads
ejbLoad is not getting called
doubts in setDate(i,date,cal) API of preparedStatement