MySQL Bugs: #38336: The list of schema names could not be retrieved (error: 0)

Bug #38336	The list of schema names could not be retrieved (error: 0)
Submitted:	24 Jul 2008 8:20	Modified:	14 May 2009 11:05
Reporter:	david butali	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.1.9	OS:	IBM AIX
Assigned to:	Kyle Joiner	CPU Architecture:	Any
Tags:	db2/400, driver db2/400, The list of schema names could not be retrieved (error: 0)

Description:
hi, my problem is to connect a data source db2/400 with the migration toolkit.
my connection props are:
database system -> generic jdbc
classname-> com.ibm.as400.access.AS400JDBCDriver
connection string-> jdbc:as400://10.0.0.1
username: user
password: pwd

The driver is in the classpath system variable.
i must use a different driver?

Anyway the error message i got is :

Connecting to source database and retrieve schemata names.
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :com.ibm.as400.access.AS400JDBCDriver
Details: 
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
java.lang.ClassLoader.loadClass(Unknown Source)
sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
java.lang.ClassLoader.loadClass(Unknown Source)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:54)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(ReverseEngineeringGeneric.java:185)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

thks 
David

How to repeat:
just use a db2/400 as source database using the following props :
database system -> generic jdbc
classname-> com.ibm.as400.access.AS400JDBCDriver
connection string-> jdbc:as400://server
username: user
password: pwd

Thank you for a problem report. Please, try to repeat with a newer version of MT, 1.1.12, and inform about the results.

hi,
i've just tried with the newer version of Migration Toolkit  but i've got the same result.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Migration tool into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/