java.sql.SQLException: Error converting data type decimal to decimal. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:85) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:108) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:726) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:269) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:234) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:151) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:114)

jtds | drand | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Failure when inserting Long into BIGINT PK column

    jtds | 1 decade ago | drand
    java.sql.SQLException: Error converting data type decimal to decimal. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:85) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:108) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:726) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:269) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:234) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:151) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:114)

    Root Cause Analysis

    1. java.sql.SQLException

      Error converting data type decimal to decimal. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:85) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:108) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:726) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:269) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:234) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:151) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:114)

      at db.TestBigintPK.run()
    2. db
      TestBigintPK.main
      1. db.TestBigintPK.run(TestBigintPK.java:66)
      2. db.TestBigintPK.main(TestBigintPK.java:30)
      2 frames