com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1

Jive Software Open Source | Gaston Dombiak | 9 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.PreparedStatement$$EnhancerByProxool$$331bec1c.executeUpdate(<generated>) at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.insertProperty(JiveLiveProperties.java:118) at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.setProperty(JiveLiveProperties.java:60) at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveDataForm(FormManager.java:170) at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveWorkgroupForm(FormManager.java:83) at org.jivesoftware.openfire.plugin.enterprise.fastpath.forms.workgroup_002ddataform_jsp._jspService(workgroup_002ddataform_jsp.java:131)

    Jive Software Open Source | 9 years ago | Gaston Dombiak
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1
  2. 0

    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.PreparedStatement$$EnhancerByProxool$$331bec1c.executeUpdate(<generated>) at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.insertProperty(JiveLiveProperties.java:118) at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.setProperty(JiveLiveProperties.java:60) at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveDataForm(FormManager.java:170) at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveWorkgroupForm(FormManager.java:83) at org.jivesoftware.openfire.plugin.enterprise.fastpath.forms.workgroup_002ddataform_jsp._jspService(workgroup_002ddataform_jsp.java:131)

    JIRA | 9 years ago | Gaston Dombiak
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1
  3. 0

    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.PreparedStatement$$EnhancerByProxool$$331bec1c.executeUpdate(<generated>) at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.insertProperty(JiveLiveProperties.java:118) at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.setProperty(JiveLiveProperties.java:60) at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveDataForm(FormManager.java:170) at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveWorkgroupForm(FormManager.java:83) at org.jivesoftware.openfire.plugin.enterprise.fastpath.forms.workgroup_002ddataform_jsp._jspService(workgroup_002ddataform_jsp.java:131)

    Jive Software Open Source | 9 years ago | Gaston Dombiak
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Data truncation: Data too long for column hibernate

    Stack Overflow | 1 year ago | gogoru
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Data truncation: Data too long for column 'emailAddress' at row 1; SQL [n/a]; nested exception is org.hibernate.exception.DataException: Data truncation: Data too long for column 'emailAddress' at row 1
  6. 0

    Problem with adding time (JDBC and Relational Databases forum at JavaRanch)

    coderanch.com | 2 years ago
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '25-apr-2013' for column 'Time' at row 1
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. com.mysql.jdbc.MysqlDataTruncation

    Data truncation: Data too long for column 'propValue' at row 1

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    4. com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    5. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
    6. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
    7. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
    8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
    8 frames
  3. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  4. org.logicalcobwebs.proxool
    ProxyStatement.intercept
    1. org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    2. org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    2 frames
  5. $java.sql
    PreparedStatement$$EnhancerByProxool$$331bec1c.executeUpdate
    1. $java.sql.PreparedStatement$$EnhancerByProxool$$331bec1c.executeUpdate(<generated>)
    1 frame
  6. com.jivesoftware.xmpp
    JiveLiveProperties.setProperty
    1. com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.insertProperty(JiveLiveProperties.java:118)
    2. com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.setProperty(JiveLiveProperties.java:60)
    2 frames
  7. com.jivesoftware.openfire
    FormManager.saveWorkgroupForm
    1. com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveDataForm(FormManager.java:170)
    2. com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveWorkgroupForm(FormManager.java:83)
    2 frames
  8. org.jivesoftware.openfire
    workgroup_002ddataform_jsp._jspService
    1. org.jivesoftware.openfire.plugin.enterprise.fastpath.forms.workgroup_002ddataform_jsp._jspService(workgroup_002ddataform_jsp.java:131)
    1 frame