MySQL Bugs: #20488: Oracle long raw column data not migrated to MySQL

Bug #20488	Oracle long raw column data not migrated to MySQL
Submitted:	15 Jun 2006 20:16	Modified:	22 Jun 2006 15:09
Reporter:	Robin Schumacher	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	1.0.25	OS:	Windows (Windows, Fedora core 4)
Assigned to:		CPU Architecture:	Any

Description:
Migrating an Oracle10g table with long raw datatypes results in no data being moved to MySQL

How to repeat:
create table in oracle with long raw datatype
insert data
Use migration toolkit and attempt to move table to MySQL
Table comes over but data does not (blank data)

Thank you for a problem report. What exact versions of Migration Toolkit/Oracle JDBC driver do you use?

I'm using 1.0.23 of migration toolkit.  Can't tell what JDBC driver I have; it's the one that's shipped with the latest Oracle10g version.  The Oracle java directories are labeled 1.4.2.

Did you use the BLOB streaming option during data transfer? Are you sure you are using the Oracle 10g JDBC driver? There is a know bug in older versions of the JDBC driver that does not allow the transfer of long raw column data.

I did try the blob streaming option but I still get blank data in my MySQL blob column.  The only Installation I have on the WIN machine I'm using (where Oracle is) is 10g, so I should be OK in terms of using their latest JDBC driver.  How can I tell what MigToolkit is using after I specify one?

Verified just as described on Windows XP while migrating schema from Oracle XE (10.2.0, with JDBC driver included) to MySQL 5.0.22. Simple table in Oracle:

create table t_lob(c1 int, c2 long raw);
insert into t_lob values(1, hextoraw('abc'));
insert into t_lob values(2, hextoraw('abcdef'));

is not migrated properly (neither with BLOB streaming nor without it). O row(s) transfered for t_lob table.

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