search

slarson / wholebrain

Automatically exported from code.google.com/p/wholebrain
0 stars 0 forks source link

Populating Database problems #378

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Update to get the latest Server code changes (revision 1499)
2. Start the database
3. Start populating the Database

What is the expected output? What do you see instead?
Populating Database crashes. Unable to use local server. 
Building WholeBrainCatalogState.
Importing WholeBrainCatalogState.
Exception in thread "main" javax.persistence.PersistenceException: 
org.hibernate.exception.GenericJDBCException: could not insert: 
[org.wholebrainproject.wbc.generated.annotation.AnnotationRoot$Annotation]
    at 
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(Abstr
actEntityManagerImpl.java:614)
    at 
org.hibernate.ejb.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl
.java:244)
    at 
org.wholebrainproject.wbc.server.data.DataRepository.updateToDB(DataReposit
ory.java:827)
    at 
org.wholebrainproject.wbc.server.data.DataRepository.updateToDB(DataReposit
ory.java:296)
    at 
org.wholebrainproject.wbc.server.data.DataRepository.updateImportWholeBrain
CatalogState(DataRepository.java:284)
    at 
org.wholebrainproject.wbc.server.util.PopulateDatabaseFromXML.doPopulate(Po
pulateDatabaseFromXML.java:91)
    at 
org.wholebrainproject.wbc.server.util.PopulateDatabaseFromXML.main(Populate
DatabaseFromXML.java:114)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert: 
[org.wholebrainproject.wbc.generated.annotation.AnnotationRoot$Annotation]
    at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLSt
ateConverter.java:126)
    at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:11
4)
    at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.jav
a:66)
    at 
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractRet
urningDelegate.java:64)
    at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntit
yPersister.java:2186)
    at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntit
yPersister.java:2666)
    at 
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInser
tAction.java:71)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at 
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(Ab
stractSaveEventListener.java:321)
    at 
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveE
ventListener.java:204)
    at 
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(Abstr
actSaveEventListener.java:130)
    at 
org.hibernate.ejb.event.EJB3MergeEventListener.saveWithGeneratedId(EJB3Merg
eEventListener.java:43)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(Default
MergeEventListener.java:238)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultM
ergeEventListener.java:292)
    at 
org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEvent
Listener.java:167)
    at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:714)
    at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:696)
    at 
org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:268)
    at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:291)
    at 
org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:239)
    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
    at 
org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:319)
    at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:265)
    at 
org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:242)
    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
    at org.hibernate.engine.Cascade.cascade(Cascade.java:153)
    at 
org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(Abstract
SaveEventListener.java:479)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(Default
MergeEventListener.java:246)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultM
ergeEventListener.java:292)
    at 
org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEvent
Listener.java:167)
    at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:714)
    at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:696)
    at 
org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:268)
    at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:291)
    at 
org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:239)
    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
    at org.hibernate.engine.Cascade.cascade(Cascade.java:153)
    at 
org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(Abstrac
tSaveEventListener.java:454)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(Default
MergeEventListener.java:230)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultM
ergeEventListener.java:292)
    at 
org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEvent
Listener.java:167)
    at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:714)
    at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:696)
    at 
org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:268)
    at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:291)
    at 
org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:239)
    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
    at 
org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:319)
    at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:265)
    at 
org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:242)
    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
    at org.hibernate.engine.Cascade.cascade(Cascade.java:153)
    at 
org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(Abstract
SaveEventListener.java:479)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(Default
MergeEventListener.java:246)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultM
ergeEventListener.java:292)
    at 
org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEvent
Listener.java:167)
    at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:714)
    at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:696)
    at 
org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:268)
    at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:291)
    at 
org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:239)
    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
    at org.hibernate.engine.Cascade.cascade(Cascade.java:153)
    at 
org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(Abstrac
tSaveEventListener.java:454)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(Default
MergeEventListener.java:230)
    at 
org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultM
ergeEventListener.java:292)
    at 
org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEvent
Listener.java:167)
    at 
org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEvent
Listener.java:81)
    at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:704)
    at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:688)
    at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:692)
    at 
org.hibernate.ejb.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl
.java:235)
    ... 5 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too 
long for column 'ANNOTATIONCONTENT' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
    at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:173
4)
    at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
    at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
    at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
    at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPr
eparedStatement.java:105)
    at 
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtra
ct(IdentityGenerator.java:94)
    at 
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractRet
urningDelegate.java:57)
    ... 73 more

Please use labels and text to provide additional information.

Original issue reported on code.google.com by piperfl...@gmail.com on 5 Dec 2009 at 1:47

GoogleCodeExporter commented 9 years ago

Original comment by piperfl...@gmail.com on 5 Dec 2009 at 2:04