Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (herse.apache.org: domain of ari@ish.com.au designates
 59.167.240.32 as permitted sender)
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Transfer-Encoding: 7bit
Message-Id: <E8EB76D4-D480-4EE4-8733-172522CFFBB5@ish.com.au>
Content-Type: multipart/signed; protocol="application/pgp-signature";
 micalg=pgp-sha1; boundary="Apple-Mail-109--292320730"
To: cayenne-user@apache.org
From: Aristedes Maniatis <ari@ish.com.au>
Subject: Datanode -> XML
Date: Fri, 9 Mar 2007 21:24:50 +1100

--Apple-Mail-109--292320730
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed

I am looking at a way to export and import data from a Derby  
database. Built into Derby itself is a tool which exports CSV or tab  
delimited data, but this has a range of problems with binary data and  
with compatibility across platforms and different databases, as well  
as across upgrades of the schema.

Another option is to use Cayenne itself to perform the migration,  
with an XML dataNode as the repository for the data. I know that EOF  
does this sort of thing natively, but I don't believe XML datanodes  
are available in Cayenne. Has anyone attempted something similar with  
one of the JDBC-XML drivers (for example: https://xlsql.dev.java.net/)?

Speed is likely to be awful, but that is OK for this purpose. It also  
comes to mind that this approach might be a great way to write unit  
tests for our system, testing the code against a standard set of  
sample data.


Thanks
Ari Maniatis


-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001   fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A


--Apple-Mail-109--292320730
content-type: application/pgp-signature; x-mac-type=70674453;
	name=PGP.sig
content-description: This is a digitally signed message part
content-disposition: inline; filename=PGP.sig
content-transfer-encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (Darwin)

iD8DBQFF8TXz72p9Lj5JECoRAnVvAJ4tlGLoYQI1LRjI1n4o8DNZBF5mQACeMziV
WVGL6Thwv38TlOBgz+qp3y8=
=DJss
-----END PGP SIGNATURE-----

--Apple-Mail-109--292320730--