XML Data Export: switching from Derby to MySQL

[Michele Orru]

Hi all,

I'm having some troubles on switching existing data from Derby to MySQL.

An Export All works perfectly except for one table, AudioDataResource, where Blobs of song are stored.
Then I run an Export only on the AudoDataResource entity, that generates the following:

2009-11-02 11:19:25,571 (http-0.0.0.0-8445-2) [        SqlJdbcUtil.java:670:WARN ] Got bytes back for Object field with length: 0 while getting value : audioData [AUDIO_DATA] (2):
2009-11-02 11:19:25,628 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@27abb00a
2009-11-02 11:19:25,680 (http-0.0.0.0-8445-2) [                       ?:?  :INFO ] Records written [AudioDataResource]: 1
2009-11-02 11:19:25,722 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@76cec888
2009-11-02 11:19:25,735 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@636a4985
2009-11-02 11:19:25,741 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@7df904df
2009-11-02 11:19:25,743 (http-0.0.0.0-8445-2) [        SqlJdbcUtil.java:670:WARN ] Got bytes back for Object field with length: 0 while getting value : audioData [AUDIO_DATA] (2):
2009-11-02 11:19:25,744 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@158412e1
2009-11-02 11:19:28,019 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@c36c8e6
2009-11-02 11:19:30,520 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@706b6c9
2009-11-02 11:19:32,760 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@323f6c10
2009-11-02 11:19:33,786 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@1e3c1a28
2009-11-02 11:19:35,780 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@29c40562
2009-11-02 11:19:36,408 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@faf73d2
2009-11-02 11:19:37,118 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@1a445dcf
2009-11-02 11:19:37,814 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@1fbd829e
2009-11-02 11:19:38,517 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@61d38439
2009-11-02 11:19:39,150 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@49a3a85d
2009-11-02 11:19:39,752 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@3050afdd
2009-11-02 11:19:40,415 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@3626afff
2009-11-02 11:19:47,713 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@209cf715
2009-11-02 11:19:48,287 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@787f189
2009-11-02 11:19:48,783 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@3104b646
2009-11-02 11:19:49,307 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@4ded1c32
2009-11-02 11:19:50,010 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@31a0eaf1
2009-11-02 11:19:50,769 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@67c8f3da
2009-11-02 11:19:51,312 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@8cb09b6
2009-11-02 11:19:51,981 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@75a713db
2009-11-02 11:19:52,709 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@72d47b5a
2009-11-02 11:19:53,339 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@1cb31074
2009-11-02 11:19:54,002 (http-0.0.0.0-8445-2) [      GenericEntity.java:1033:WARN ] Field:audioData is not of type 'byte[]'. obj: javax.sql.rowset.serial.SerialBlob@7f410293
2009-11-02 11:19:54,004 (http-0.0.0.0-8445-2) [                       ?:?  :INFO ] [1] [28] AudioDataResource wrote 28 records

The XML file is written, but the field AudioData is not written in it.

How can I circumvent this kind of problem?

Thanks for your time.

Michele Orru'