Messages posted by: Eric _t

When i try to migrate a large table from mysql (data only) using the online migration tool in the EnterpriseDB Migration Studio 8.3 i get the following error:

Exception in thread "Thread-22" java.lang.OutOfMemoryError: java heap space.

I have added the following to migrationstudio/runMigrationStudio.sh

../jre/bin/java -Xmx1024M -Xms1024m -jar edb-migrationstudio.jar&

to bump the heap space, but the problem still persists.

Although I have selected the Default Date column, when I try to migrate a table from MySQL that contains an invalid date-field, i get the following error:
Error Loading Data into Table: Value '0000-00-00' can not be represented as java.sql.Date.

Googling for this error I find the following solution:
http://community.eapps.com/showthread.php?t=8

which suggests adding '&zeroDateTimeBehavior=convertToNull' to the end of the url parameter in the server.xml connection pool resource section.
I can not find such an xml file in the migrationstudio folder.
How can I configure migration studio to have the desired handling of invalid dates ?