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

Jive Software Open Source | Gaston Dombiak | 9 years ago
  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 | 9 months 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 | 1 year 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