By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,573 Members | 3,017 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,573 IT Pros & Developers. It's quick & easy.

Migration from Mysql to db2 express-c

P: n/a
Hi there,

i currently evaluating db2 express-c and therefor i wanted to migrate my
current database from mysql5 to the express-c... i didn't get it working
with mysqldump, and finally found the ibm data migration toolkit. But
whenever i want to start the conversation i get this exception:

Sun Mar 23 23:07:28 CET 2008 ERROR MySQL TRANSLATOR Translator Internal Exception
java.lang.NullPointerException
at com.ibm.mtk.translation.source.common.types.Unsign edDoubleType.convert(UnsignedDoubleType.java:75)
at com.ibm.mtk.translation.source.common.ast.expr.Src Expression.translateToDB2WithContextForUnknown(Src Expression.java:125)
at com.ibm.mtk.translation.source.common.ast.expr.Src Expression.translateToDB2(SrcExpression.java:100)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC olumnDef.translateDefaultExpression(SrcColumnDef.j ava:448)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC olumnDef.translateToDB2(SrcColumnDef.java:328)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.translateColumns(SrcCreateTableStmt .java:777)
at com.ibm.mtk.translation.source.mysql.ast.sql.MySQL CreateTableStmt.translateColumns(MySQLCreateTableS tmt.java:88)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.TranslateToDB2Table(SrcCreateTableS tmt.java:746)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.translateCreateTable(SrcCreateTable Stmt.java:732)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.translateToDB2(SrcCreateTableStmt.j ava:429)
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.statement_check(MySQLASTWalker.java:240 )
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.statement_list(MySQLASTWalker.java:211)
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.dofile(MySQLASTWalker.java:192)
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.mysql_ast(MySQLASTWalker.java:150)
at com.ibm.mtk.translation.source.mysql.MySQLTranslat or.walkTree(MySQLTranslator.java:180)
at com.ibm.mtk.translation.source.common.Translator.c onvert(Translator.java:398)
at com.ibm.mtk.model.translation.MTKTranslationExtens ionMySQL.translateExecute(MTKTranslationExtensionM ySQL.java:294)
at com.ibm.mtk.model.translation.MTKTranslationModelE lement.translate(MTKTranslationModelElement.java:3 11)
at com.ibm.mtk.wizard.MTKWizardModel.startTranslator( MTKWizardModel.java:716)
at com.ibm.mtk.wizard.MTKWizardTaskToRun.startTransla tor(MTKWizardTaskToRun.java:289)
at com.ibm.mtk.wizard.MTKWizardTaskToRun.access$300(M TKWizardTaskToRun.java:30)
at com.ibm.mtk.wizard.MTKWizardTaskToRun$ActualTask.< init>(MTKWizardTaskToRun.java:194)
at com.ibm.mtk.wizard.MTKWizardTaskToRun$1.construct( MTKWizardTaskToRun.java:172)
at com.ibm.mtk.util.SwingWorker$2.run(SwingWorker.jav a:128)
at java.lang.Thread.run(Thread.java:595)

Does anybody has an hint, how to fix this?

--
MfG, Christian Welzel aka Gawain@Regenbogen

GPG-Key: http://www.camlann.de/key.asc
Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
Mar 23 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Christian Welzel wrote:
Hi there,

i currently evaluating db2 express-c and therefor i wanted to migrate my
current database from mysql5 to the express-c... i didn't get it working
with mysqldump, and finally found the ibm data migration toolkit. But
whenever i want to start the conversation i get this exception:

Sun Mar 23 23:07:28 CET 2008 ERROR MySQL TRANSLATOR Translator Internal Exception
java.lang.NullPointerException
at com.ibm.mtk.translation.source.common.types.Unsign edDoubleType.convert(UnsignedDoubleType.java:75)
at com.ibm.mtk.translation.source.common.ast.expr.Src Expression.translateToDB2WithContextForUnknown(Src Expression.java:125)
at com.ibm.mtk.translation.source.common.ast.expr.Src Expression.translateToDB2(SrcExpression.java:100)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC olumnDef.translateDefaultExpression(SrcColumnDef.j ava:448)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC olumnDef.translateToDB2(SrcColumnDef.java:328)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.translateColumns(SrcCreateTableStmt .java:777)
at com.ibm.mtk.translation.source.mysql.ast.sql.MySQL CreateTableStmt.translateColumns(MySQLCreateTableS tmt.java:88)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.TranslateToDB2Table(SrcCreateTableS tmt.java:746)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.translateCreateTable(SrcCreateTable Stmt.java:732)
at com.ibm.mtk.translation.source.common.ast.sql.SrcC reateTableStmt.translateToDB2(SrcCreateTableStmt.j ava:429)
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.statement_check(MySQLASTWalker.java:240 )
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.statement_list(MySQLASTWalker.java:211)
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.dofile(MySQLASTWalker.java:192)
at com.ibm.mtk.translation.source.mysql.grammars.MySQ LASTWalker.mysql_ast(MySQLASTWalker.java:150)
at com.ibm.mtk.translation.source.mysql.MySQLTranslat or.walkTree(MySQLTranslator.java:180)
at com.ibm.mtk.translation.source.common.Translator.c onvert(Translator.java:398)
at com.ibm.mtk.model.translation.MTKTranslationExtens ionMySQL.translateExecute(MTKTranslationExtensionM ySQL.java:294)
at com.ibm.mtk.model.translation.MTKTranslationModelE lement.translate(MTKTranslationModelElement.java:3 11)
at com.ibm.mtk.wizard.MTKWizardModel.startTranslator( MTKWizardModel.java:716)
at com.ibm.mtk.wizard.MTKWizardTaskToRun.startTransla tor(MTKWizardTaskToRun.java:289)
at com.ibm.mtk.wizard.MTKWizardTaskToRun.access$300(M TKWizardTaskToRun.java:30)
at com.ibm.mtk.wizard.MTKWizardTaskToRun$ActualTask.< init>(MTKWizardTaskToRun.java:194)
at com.ibm.mtk.wizard.MTKWizardTaskToRun$1.construct( MTKWizardTaskToRun.java:172)
at com.ibm.mtk.util.SwingWorker$2.run(SwingWorker.jav a:128)
at java.lang.Thread.run(Thread.java:595)

Does anybody has an hint, how to fix this?
Christian,

send a note to mt*@us.ibm.com.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 23 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.