Hi,
I want to migrate an old BASE installation (1.2) to an newer one (2) on another
machine/arch. During the run of migrate_from_1.2.sh there are many exceptions,
e.g.
17:50:28,656 ERROR migration:85 - getSampleById
net.sf.basedb.core.BaseException: could not load an entity:
[net.sf.basedb.core.data.SampleData#2]
at net.sf.basedb.core.HibernateUtil.loadData(HibernateUtil.java:1063)
at net.sf.basedb.core.DbControl.loadItem(DbControl.java:681)
at net.sf.basedb.core.Sample.getById(Sample.java:88)
at
net.sf.basedb.clients.migrate.SampleTransfer.getSampleById(SampleTransfer.java:143)
at
net.sf.basedb.clients.migrate.ExtractTransfer.createItem(ExtractTransfer.java:90)
at
net.sf.basedb.clients.migrate.ExtractTransfer.createItem(ExtractTransfer.java:44)
at net.sf.basedb.clients.migrate.Transfer.run(Transfer.java:346)
at
net.sf.basedb.clients.migrate.ExtractTransfer.start(ExtractTransfer.java:70)
at
net.sf.basedb.clients.migrate.Migrater.startTransfer(Migrater.java:218)
at net.sf.basedb.clients.migrate.Migrater.run(Migrater.java:125)
at net.sf.basedb.clients.migrate.Migrater.main(Migrater.java:478)
Caused by: org.hibernate.exception.DataException: could not load an entity:
[net.sf.basedb.core.data.SampleData#2]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1865)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3038)
at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179)
at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
at net.sf.basedb.core.HibernateUtil.loadData(HibernateUtil.java:1059)
... 10 more
Caused by: com.mysql.jdbc.exceptions.MySQLDataException: '8589934593' in column
'15' is outside valid range for the datatype INTEGER.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:893)
at com.mysql.jdbc.ResultSet.throwRangeException(ResultSet.java:7391)
at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3967)
at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3892)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2555)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2570)
at
com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2573)
at org.hibernate.type.IntegerType.get(IntegerType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.type.ComponentType.hydrate(ComponentType.java:560)
at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:275)
at
org.hibernate.type.SpecialOneToOneType.hydrate(SpecialOneToOneType.java:58)
at
org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2092)
at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1371)
at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1299)
at org.hibernate.loader.Loader.getRow(Loader.java:1197)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:568)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1851)
... 22 more
Is there a bug in the migrate-Tool?
Regards
Bernd
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
The BASE general discussion mailing list
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
