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
  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)
  2. 0

    translateDate is not recognized function name

    jtds | 1 decade ago | jcfbike
    java.sql.SQLException: 'translateDate' is not a recognized function name. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:85) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:99) at net.sourceforge.jtds.jdbc.Tds.submitProcedure(Tds.java:332) at net.sourceforge.jtds.jdbc.PreparedStatement_base.submitProcedure(PreparedStatement_base.java:190) at net.sourceforge.jtds.jdbc.PreparedStatement_base.findOrCreateProcedure(PreparedStatement_base.java:175) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:131) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:114)
  3. 0

    Clob support

    jtds | 1 decade ago | peterdb
    java.sql.SQLException: Internal error. Unrecognized type 2005 at net.sourceforge.jtds.jdbc.ParameterUtils.createParameterMapping(ParameterUtils.java:244) at net.sourceforge.jtds.jdbc.PreparedStatement_base.findOrCreateProcedure(PreparedStatement_base.java:149) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:131) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:286) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:527) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:432) at net.sf.hibernate.impl.ScheduledIdentityInsertion.execute(ScheduledIdentityInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:906) at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:839) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:757) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720) at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1359) at com.swp.persistence.BaseDAO.storeObj(BaseDAO.java:136) at com.swp.persistence.AddressDAO.saveAddress(AddressDAO.java:16) at test.com.swp.persistence.AddressDAOTest.testCrud(AddressDAOTest.java:45) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Exception with Sybase and metaData.getTables()

    jtds | 1 decade ago | mrezaei
    java.sql.SQLException: Was expecting a result set at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeQuery(PreparedStatement_base.java:264) at net.sourceforge.jtds.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:1676)
  6. 0

    "ResultSet expected" problem

    jtds | 1 decade ago | alf239
    java.sql.SQLException: Was expecting a result set at net.sourceforge.jtds.jdbc. PreparedStatement_base. executeQuery(PreparedStatement_base.java:214)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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