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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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.serialb...@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' -- View this message in context: http://n4.nabble.com/XML-Data-Export-switching-from-Derby-to-MySQL-tp360721p360721.html Sent from the OFBiz - User mailing list archive at Nabble.com.
