MySQL

MySQL Migr Toolkit, Generic JDBC ".. schema names could not be retrieved (error: 0)."

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2008

Posts: 1

Reputation: bz029 is an unknown quantity at this point

Solved Threads: 0

bz029

Offline

Newbie Poster

MySQL Migr Toolkit, Generic JDBC ".. schema names could not be retrieved (error: 0)."

Nov 3rd, 2008

What I have done/tried:

1) Download JDBC driver from Centura/Gupta/Unify website. Called and confirmed the JDBC driver is backwards compatable with sqlbase 7.6
2) Put jdbc file into mysql migration toolkit lib directory: C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib\SQLBaseJDBC.jar
3) Open MySQL Migration Manager, configure:
- source database
Database System: Generic JDBC
Class Name: SQLBaseJDBC.jar
Connection String: jdbc:sqlbase://localhost[:2155]/pos [;ims=;cms=]
-target database
Direct MySQL, etc...

4) Result Log:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
Connecting to source database AND retrieve schemata names.
The list of schema names could NOT be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :SQLBaseJDBC.jar
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:84)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(ReverseEngineeringGeneric.java:230)
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)
Connecting to source database and retrieve schemata names.
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :SQLBaseJDBC.jar
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:84)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(ReverseEngineeringGeneric.java:230)
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)

I am not sure how to troubleshoot this from here, do i need to troubleshoot the JDBC class code? Can anyone provide deeper insight into this issue for me?

Before it was not using the driver, since i configure the Class Name this way and put the file in the lib/ dir of the toolkit, it appears its using the correct driver (and connecting? It's not giving the same error about the driver not loading .... ) but cannot pull the database schema ....