473,411 Members | 2,164 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,411 software developers and data experts.

Migration from Mysql to db2 express-c

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
1 1549
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Mike Henley | last post by:
considering the recent changes to the mysql licensing terms, which meant the php5 team had to adopt sqlite instead into the php5 and drop mysql stuff from the standard language distro (as i...
1
by: Bungle | last post by:
Hi everyone Does anyone know or has anyone heard of any migration tools which are/might be available for converting SQL Server 2000 databases to SQL Server 2005 Express? I'm guessing it is...
41
by: Matt Alanzo | last post by:
Our SOHO 2 person compay sells furniture (not programmers). In '98 we paid $,$$$ for a VBA -Access '97 accounting application, including VBA source code .... an huge investment for us then (and...
27
by: Josh | last post by:
We have a program written in VB6 (over 100,000 lines of code and 230 UI screens) that we want to get out of VB and into a better language. The program is over 10 years old and has already been...
1
by: dtoffe | last post by:
Hi All !! I just want to know other's experiences in migrating from DB2 UDB 6.1 for Workgroup to DB2 UDB 8.2 Express Edition, is it possible to migrate the databases ? Will 8.2 Express accept...
10
by: Iain | last post by:
Hi Is it possible to get Visual Studio C# Express (beta 2) connecting to a MySQL database? TIA Iain
2
by: RivaCom | last post by:
Is this possible? I know you can do local connections but I have yet to see a remote connection though VB 2005 express. Can anyone help me out?
6
by: Cirene | last post by:
From my experience/undertanding SQL Server (and SQL Express) is the preferred db to use with Visual Studio and is very nicely integrated with it. It works well with the built in membership, etc......
15
by: Cirene | last post by:
I'm trying to convince my client that MySQL server is not the way to go for his project. Here are some reasons why... - If you use the MySQL Connector you are bound to GPL (unless you want to pay...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.