Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#16 MS SQL Problem

open
nobody
None
5
2011-08-22
2011-08-22
Anonymous
No

Problem with validation Column (see attached file)
Problem with server communication :

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Arithmetic overflow error for data type smallint, value = 51457.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1488)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:633)
at org.opengts.dbtools.DBConnection._executeUpdate(DBConnection.java:938)
at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:885)
at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:866)
at org.opengts.dbtools.DBProvider.updateRecordInTable(DBProvider.java:2010)
at org.opengts.dbtools.DBRecord.update(DBRecord.java:1249)

Discussion

  • Problem with column and MS SQL

     
    Attachments