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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
MySQL Blobs have 2^16-1 bytes. Change the column to a MEDIUMBLOB (2^24-1 bytes).
Last edit: EJP 2021-07-03