wood burning stoves 2.0*
The moose likes JDBC and the fly likes ResultSet Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSet Question" Watch "ResultSet Question" New topic

ResultSet Question

jacq carballo
Ranch Hand

Joined: Feb 10, 2002
Posts: 42
This error came out when i called resultSet.next(). I do not know what could have caused it. Maybe someone could explain what just happened and how to take care of this error.
Thanks in advance.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Ari
thmetic overflow error converting numeric to data type numeric.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(
Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplResultSet.positionCursor(Un
known Source)
at com.microsoft.jdbc.base.BaseResultSet.next(Unknown Source)
at Parse.uploadUsageRecord(ParseData.java:119)
at Parse.CheckData(ParseData.java:78)
at ParseData.main(ParseData.java:29)
Snigdha Solanki
Ranch Hand

Joined: Sep 07, 2000
Posts: 128
There can be serveral reasons for this exception.
Can you post your code which is throwing this exception. It will be easier to find out then.

Snigdha<br />Sun Certified Programmer for the Java™ 2 Platform
I agree. Here's the link: http://aspose.com/file-tools
subject: ResultSet Question
Similar Threads
Getting Exception as Could not find stored procedure 'sp_getNextMainGroup'
java.rmi.UnmarshalException: Please Help
database errror
"Could not find stored procedure" Error
JRUN Error