Migrating HSQL to MySQL
Posted by: Sheila Loring
Date: September 24, 2009 12:18PM

I'm using the MySQL Migration Tool to migrate an Alfresco HSQL database to MySQL. My computer is a Windows XP box with 2.5 GB RAM. The JRE version is 1.6.0_16.

When I try to convert the database, I get these errors:

Connection jdbc:hsqldb:file:C:\alfrescoBU\alf_data\hsql_data\alfresco
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :Out of Memory
Details:
org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
org.hsqldb.jdbcDriver.getConnection(Unknown Source)
org.hsqldb.jdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:138)
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've tried starting the migration tool by specifying a maximum heap size of 512m, but that has no affect, and I don't think setting the max heap is the answer anyway.

Does anyone have any suggestions?

Options: ReplyQuote


Subject
Written By
Posted
Migrating HSQL to MySQL
September 24, 2009 12:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.