java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred while converting the varchar value to JDBC data type DECIMAL.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by Bhavesh Shah
, 1 year ago
com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred while converting the varchar value to JDBC data type DECIMAL.
java.lang.NumberFormatException:
at java.math.BigDecimal.(BigDecimal.java:459)
at java.math.BigDecimal.(BigDecimal.java:728)
at com.microsoft.sqlserver.jdbc.DDC.convertStringToObject(DDC.java:285)
at com.microsoft.sqlserver.jdbc.DDC.convertStreamToObject(DDC.java:436)
at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2474)
at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:176)
at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:113)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1981)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1966)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBigDecimal(SQLServerResultSet.java:2596)
at com.cloudera.sqoop.tool.ImportTool.getMaxColumnId(ImportTool.java:187)
at com.cloudera.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:230)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:345)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:134)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:69)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:170)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:196)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:205)

Users with the same issue

6 times, 2 days ago
Once, 3 weeks ago
109 times, 1 month ago
2 times, 2 months ago
2 times, 10 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.