This happens every time we add another LOB to the database. The JPA spec doesn't provide an annotation for defining LOB lengths, so we need to set this in the DDL, and encourage people to use the DDL scripts rather than using the auto-generated tables.
Speaking of the DDL scripts, has anyone been keeping these up to date? I imagine the 1.2 release won't run against the contents of its DDL scripts. This should be tested, and release blockers filed for any problems. I won't be available to work on this until next week Wednesday at the earliest, so for the sake of a speedy QA for 1.2, I'd recommend someone else take on these tasks. Josh On Jun 3, 2011, at 5:33 PM, Greg Logan wrote: > Bug created at http://opencast.jira.com/browse/MH-7840 > > Josh, this seems like something up your alley... > > G > > On 11-06-03 03:16 PM, Greg Logan wrote: >> Hi folks, >> >> When starting Matterhorn and using a MySQL DB I see the following error >> for each of the ten hardcoded series on startup: >> >> 15:12:00 ERROR (SeriesServiceDatabaseImpl:275) - Could not update >> series: Exception [EclipseLink-4002] (Eclipse Persistence Services - >> 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException >> Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: >> Data too long for column 'DUBLIN_CORE' at row 1 >> Error Code: 1406 >> Call: INSERT INTO SERIES (SERIES_ID, ACCESS_CONTROL, DUBLIN_CORE) VALUES >> (?, ?, ?) >> bind => [SERIES_1, null, <?xml version="1.0" encoding="UTF-8" >> standalone="no"?><dublincore >> xmlns="http://www.opencastproject.org/xsd/1.0/dublincore/" >> xmlns:dcterms="http://purl.org/dc/terms/"><dcterms:creator>Creator >> #1</dcterms:creator><dcterms:contributor>Contributor >> #1</dcterms:contributor><dcterms:identifier>SERIES_1</dcterms:identifier><dcterms:title>Series >> #1</dcterms:title></dublincore>] >> Query: >> InsertObjectQuery(org.opencastproject.series.impl.persistence.SeriesEntity@47d44d0d) >> 15:12:00 ERROR (SeriesServiceImpl:149) - Could not store series dublin >> core: org.opencastproject.series.impl.SeriesServiceDatabaseException: >> javax.persistence.RollbackException: Exception [EclipseLink-4002] >> (Eclipse Persistence Services - 2.0.2.v20100323-r6872): >> org.eclipse.persistence.exceptions.DatabaseException >> Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: >> Data too long for column 'DUBLIN_CORE' at row 1 >> Error Code: 1406 >> Call: INSERT INTO SERIES (SERIES_ID, ACCESS_CONTROL, DUBLIN_CORE) VALUES >> (?, ?, ?) >> bind => [SERIES_1, null, <?xml version="1.0" encoding="UTF-8" >> standalone="no"?><dublincore >> xmlns="http://www.opencastproject.org/xsd/1.0/dublincore/" >> xmlns:dcterms="http://purl.org/dc/terms/"><dcterms:creator>Creator >> #1</dcterms:creator><dcterms:contributor>Contributor >> #1</dcterms:contributor><dcterms:identifier>SERIES_1</dcterms:identifier><dcterms:title>Series >> #1</dcterms:title></dublincore>] >> Query: >> InsertObjectQuery(org.opencastproject.series.impl.persistence.SeriesEntity@47d44d0d) >> 15:12:00 WARN (UserAndSeriesLoader$Loader:127) - Unable to create >> series dublin core >> >> Is this something worth filing a bug over, or is it going away shortly >> with the upcoming 1.2 release? >> >> G >> >> >> >> >> _______________________________________________ >> Matterhorn mailing list >> [email protected] >> http://lists.opencastproject.org/mailman/listinfo/matterhorn >> >> >> To unsubscribe please email >> [email protected] >> _______________________________________________ > > > _______________________________________________ > Matterhorn mailing list > [email protected] > http://lists.opencastproject.org/mailman/listinfo/matterhorn > > > To unsubscribe please email > [email protected] > _______________________________________________ _______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
