View Issue Details

IDProjectCategoryView StatusLast Update
0002644SymmetricDSBugpublic2024-04-22 20:10
Reporterchenson Assigned Tochenson  
Status closedResolutionfixed 
Product Version3.7.34 
Target Version3.7.35Fixed in Version3.7.35 
Summary0002644: Large float values fail to load on Sql Server
Description2016-06-22 08:32:08,882 INFO [client] [DefaultDatabaseWriter] [client-data-loader-1] Failed to process a insert event in batch 14.
Failed sql was: insert into "chenson"."dbo"."test" ("id", "col1") values (?,?)
Failed sql parameters: [1, 9.092000000000001E+40]
Failed sql parameters types: [4, 3]
Failed row data was: "1","9.092000000000001e+040"

2016-06-22 08:32:08,903 ERROR [client] [DataLoaderService] [client-data-loader-1] Failed to load batch server-14
org.jumpmind.db.sql.SqlException: BigDecimal value has more than 38 digits of precision.
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(
    at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
Caused by: java.sql.SQLException: BigDecimal value has more than 38 digits of precision.
    at net.sourceforge.jtds.jdbc.Support.normalizeBigDecimal(
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setBigDecimal(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDecimal(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDecimal(
    at org.springframework.jdbc.core.StatementCreatorUtils.setValue(
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(
    at org.jumpmind.db.sql.JdbcSqlTemplate.setDecimalValue(
    at org.jumpmind.db.sql.JdbcSqlTemplate.setValues(
    at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(
    ... 16 more
TagsNo tags attached.


related to 0006347 closedelong Support SQLServer float positive negative infinity value 


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.7 c7b523a6

2016-06-30 14:26:05


Details Diff
0002644: Large float values fail to load on Sql Server Affected Issues
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/ Diff File

Issue History

Date Modified Username Field Change
2016-06-22 15:19 chenson New Issue
2016-06-22 15:19 chenson Status new => assigned
2016-06-22 15:19 chenson Assigned To => chenson
2016-06-22 15:22 chenson Status assigned => resolved
2016-06-22 15:22 chenson Fixed in Version => 3.8.0
2016-06-22 15:22 chenson Resolution open => fixed
2016-06-22 15:23 chenson Fixed in Version 3.8.0 => 3.7.35
2016-06-22 15:23 chenson Target Version 3.8.0 => 3.7.35
2016-06-30 19:00 chenson Changeset attached => SymmetricDS 3.7 c7b523a6
2016-07-11 14:23 elong Status resolved => closed
2024-04-22 20:10 elong Relationship added related to 0006347