My notes/process:
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:
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 ....
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:
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 ....