Menu

MySQL exception

Help
pan Marian
2009-05-24
2021-06-28
  • pan Marian

    pan Marian - 2009-05-24

    Has anybody tried to get J-Spider working with MySQL and got an exception like below:

    ERROR [core.storage.spi.ContentDAOSPI] SQLException
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'c
    ontent' at row 1
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3513)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
    va:1761)

    As far as i know, the 'content' column is a BLOB typy which is supposed to have 2GB storage.
    I do not think that the web page is that big.
    Any idea what can cause that exception?

    pan Marian

     
  • EJP

    EJP - 2021-06-28

    MySQL Blobs have 2^16-1 bytes. Change the column to a MEDIUMBLOB (2^24-1 bytes).

     

    Last edit: EJP 2021-07-03

Log in to post a comment.

MongoDB Logo MongoDB