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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error Numeric Overflow-oracle " Watch "Error Numeric Overflow-oracle " New topic
Author

Error Numeric Overflow-oracle

archana gangaiah
Greenhorn

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,
archu
archana gangaiah
Greenhorn

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

Joined: Dec 20, 2006
Posts: 2510
    
  10

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
Greenhorn

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: http://aspose.com/file-tools
 
subject: Error Numeric Overflow-oracle