Java Heap Space Error During Migration
Posted by: Kyle Heath
Date: July 09, 2012 12:29PM

I'm trying to migration a large mssql 2005 database to MySQL. During the migration, I'm getting a Java Heap Space error

Starting online data bulk transfer ...
Initializing source JDBC driver ...
Initializing JDBC driver ...
Driver class MS SQL JDBC Driver
Opening connection ...
Connection jdbc:jtds:sqlserver://sql1:1433/glmain;user=sa;password=feTw8;charset=utf-8;domain=

Initializing target JDBC driver ...
Initializing JDBC driver ...
Driver class MySQL JDBC Driver 5.0
Opening connection ...
Connection jdbc:mysql://localhost:3306/?user=root&password=jkh222&useServerPrepStmts=false&characterEncoding=UTF-8

Processing schema dbo ...

Getting the number of rows of table CW_OP_FILTER_TEMPLATE
SELECT count(*) AS total_num FROM "dbo"."CW_OP_FILTER_TEMPLATE"

Transfering data from table CW_OP_FILTER_TEMPLATE (0/0 rows)
SELECT "OFT_KEY", "OFT_NAME" FROM "dbo"."CW_OP_FILTER_TEMPLATE"



Getting the number of rows of table CW_GROUP_NAME
SELECT count(*) AS total_num FROM "dbo"."CW_GROUP_NAME"

Transfering data from table CW_GROUP_NAME (5418747/5418747 rows)
SELECT "GL_KEY", "GL_GR_KEY", "GL_NA_KEY", "GL_CONTROL", "GL_TIMESTAMP" FROM "dbo"."CW_GROUP_NAME"

The SQL create statements could not be created (error: 0).
MigrationMssql.dataBulkTransfer :Java heap space
Details:
java.lang.AbstractStringBuilder.expandCapacity(Unknown Source)
java.lang.AbstractStringBuilder.append(Unknown Source)
java.lang.StringBuffer.append(Unknown Source)
com.mysql.grt.modules.MigrationGeneric.doDataBulkTransferTableToMysql(MigrationGeneric.java:1999)
com.mysql.grt.modules.MigrationGeneric.doDataBulkTransfer(MigrationGeneric.java:1552)
com.mysql.grt.modules.MigrationMssql.dataBulkTransfer(MigrationMssql.java:90)
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 know that I need to increase the Java Memory, But I can't figure out how. I was hoping that someone could help me. I've done so many googles searches and I'm lost.

Options: ReplyQuote


Subject
Written By
Posted
Java Heap Space Error During Migration
July 09, 2012 12:29PM


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.