MySQL Bugs: #18050: Trying to Migrate from Oracle HTMLDB to MySQL

Bug #18050	Trying to Migrate from Oracle HTMLDB to MySQL
Submitted:	7 Mar 2006 21:34	Modified:	18 Jun 2006 21:47
Reporter:	Bernardino Lopez	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	HTMLDB 2.0 to MySQL 5.0	OS:	Linux (RHEL 4.0)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
I saw the product Oracle HTMLDB which is basically about 1628 or so PL/SQL Procedures creating a very easy Interface to Build Pages.

Works great on Oracle Express Edition. however is a very resource consuming. I like to migrate the HTMLDB 2.0 Database from Oracle to MySQL then compile Apache WebServer with the Module mod_plsql and voala we should have running HTMLDB on MySQL the problem is the migration fail.

How to repeat:
Install HTMLDB 2.0 in Oracle Application Server or Install Oracle Express Edition. as source, as Destination install MySQL 5.0.

Run the MySQL Migration tool login properly to both Databases use the properly JDBC Connector connect by SID then when start the Import will see the error:

##########
The schema could not be reverse engineered (error: 0).
ReverseEngineeringOracle.reverseEngineer :Java heap space
Details: 
##########

There is no way to workaround the issue.

Thank you for a problem report. What exact version of Migration Toolkit did you use?

Migration Toolkit 1.0.23 rc Running in Windows XP Professional [EN].

The Source is Oracle Application Express running in RHEL 4.0 => Includes by default HTMLDB [ Oracle Application Express ] Uses about 1.5 GB of HDD and at least 256MB Ram.

The Destination is the Same Machine Running MySQL 5.0 [ 5.0.15-standard ]

The possibility of running a small footprint or Apache compiled with the mod_plsql module makes me think is very possible to allow the execution of the HTMLDB PL/SQL scripts once the DB is migrated.

Keep doing the good job.

Brains R Like Books only work when they R Open
www.phpopenmonitor.com

Can you try to run MT on a separate machine, with more memory, and inform about the results?

After Run Source in 1 GB Memory XP SP 2 . Same Results.... Error when Reverse Engineering the DB.
##################

The schema could not be reverse engineered (error: 0).
ReverseEngineeringOracle.reverseEngineer :Java heap space
Details: 

##################
Will include all the log file for Documentation Purposes.

Log from the HTMLDB Migration to MySQL - error: 0 -Java heap space

Attachment: mt.txt (text/plain), 14.92 KiB.

Thanks for your bug report.  This problem seems to be caused by MT not being able to modify the java heap for lengthy operations.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

I have increased the maximum mem size usable for the Java stack to 512MB. A greater value will prevent the MT to start on a machine with 1GB.