I'm trying to store a web page to table "pages" (whether or not that's a good idea for a separate thread, please). What would be a suitable type for the field which stores the actual page source?
When running my java application, the MySQL errors are as so: run: [java] [EL Info]: 2014-11-18 01:36:57.574--ServerSession(17148489)-- EclipseLink, version: Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd [java] [EL Info]: connection: 2014-11-18 01:36:58.798--ServerSession (17148489)--file:/home/thufir/NetBeansProjects/AggregatorJpaClient/build/ classes/_SeleniumIteratorPU login successful [java] [EL Warning]: 2014-11-18 01:37:46.084--UnitOfWork(29789888)-- Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'page' at row 1Exception in thread "main" javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'page' at row 1 [java] Error Code: 1406 [java] [java] Error Code: 1406 [java] Call: INSERT INTO rome_aggregator.pages (CREATED, link_id, PAGE, STATUS) VALUES (?, ?, ?, ?) [java] bind => [4 parameters bound] [java] Query: InsertObjectQuery(dur.Page[ id=null ]) [java] Call: INSERT INTO rome_aggregator.pages (CREATED, link_id, PAGE, STATUS) VALUES (?, ?, ?, ?) [java] bind => [4 parameters bound] [java] Query: InsertObjectQuery(dur.Page[ id=null ]) [java] at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit (EntityTransactionImpl.java:157) [java] at net.bounceme.dur.jpa.controllers.PageJpaController.create (PageJpaController.java:31) [java] at net.bounceme.dur.jpa.facades.PageFacade.create (PageFacade.java:22) and the table structure as so: mysql> mysql> describe pages; +---------+-----------+------+-----+------------------- +-----------------------------+ | Field | Type | Null | Key | Default | Extra | +---------+-----------+------+-----+------------------- +-----------------------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | created | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | page | text | NO | | NULL | | | link_id | int(11) | NO | | 0 | | | status | int(11) | NO | | 0 | | +---------+-----------+------+-----+------------------- +-----------------------------+ 5 rows in set (0.31 sec) mysql> mysql> select * from pages; Empty set (0.00 sec) mysql> The engine is: ENGINE=InnoDB DEFAULT CHARSET=latin1 I'll try some different options; thought I'd ask here to see how that error is interpreted here. It seems to me that the String is just too large for the field in the database...? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql