com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

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 Oracle Community by user4783187, 1 year ago
String or binary data would be truncated.
via Stack Overflow by Abraham Church
, 2 years ago
Arithmetic overflow error converting int to data type numeric.
via Google Groups by John Whish, 5 months ago
Error converting data type nvarchar to decimal. I don't get this on ACF9.0.1 against the same database. Looking into this a bit further, it seems that maybe under the hood Railo is using double for "1.11", but MS SQL Server expects a BigDecimal
via Stack Overflow by Nik
, 7 months ago
Procedure or function 'myInsert' expects parameter '@myId', which was not supplied.
via Server Fault by Jason B
, 1 year ago
Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
via Oracle Community by 774120, 1 year ago
String or binary data would be truncated.
com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
at com.sunopsis.sql.SnpsQuery.executeUpdate(Unknown Source)
at com.sunopsis.dwg.dbobj.generated.GeneratedSnpOrigTxt.insertAction(Unknown Source)
at com.sunopsis.dwg.DwgObject.insert(Unknown Source)
at com.sunopsis.dwg.DwgObject.insert(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpTxt.setString(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpTxt.a(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpTxt.setStringWithXRefs(Unknown Source)
at com.sunopsis.graphical.frame.b.it.bH(Unknown Source)
at com.sunopsis.graphical.frame.bp.r(Unknown Source)
at com.sunopsis.graphical.frame.b.fj.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

Users with the same issue

4 times, 3 months ago
14 times, 5 months ago
Once, 10 months ago
Once, 1 year ago
2667 times, 1 year ago

Write tip

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