For the mail list archives, here are some approaches suggested (thank
you!) that we will be investigating further:
* Connect Cayenne to an XML database source [1] and using a Cayenne
script called cdataport move data [2] between the main SQL database
and the XML 'database'. Looks like we'd need to write a Cayenne db
adapter to do this. Pretty neat though and other options such as
Excel files might also be options.
* Write some code using Cayenne's XML import/export features [3].
Lots of control over the output. But a bit more work upfront.
* xstream is a project designed to move java objects to XML and back
[4]. Very simple and it produces nice looking XML. Plenty of nice
features like being able to write Converters which understand how to
deal with specific field types. Somewhat similar is Apache Xmlbeans. [5]
* dbunit [6] This is a toolset specifically designed for testing -
taking a JDBC data source, moving it into XML and then being able to
restore it on demand. Then it can tie into junit to allow tests to be
performed on the system with the database in a known state, checking
to the see if the final state of the database is as expected. Pretty
nice idea. This is the one option which would effectively bypass
Cayenne and make direct JDBC connections of its own.
Thanks for everyone's suggestions.
Ari Maniatis
[1] http://xlsql.dev.java.net
[2] http://thread.gmane.org/gmane.comp.apache.db.derby.user/2655/
focus=2739
[3] http://somap.svn.sourceforge.net/viewvc/somap/sobf_tool/src/org/
somap/sobf/database/backuprestore/Backup.java?revision=175&view=markup
[4] http://xstream.codehaus.org
[5] http://xmlbeans.apache.org
[6] http://dbunit.sourceforge.net/
-------------------------->
Aristedes Maniatis
phone +61 2 9660 9700
PGP fingerprint 08 57 20 4B 80 69 59 E2 A9 BF 2D 48 C2 20 0C C8
This archive was generated by hypermail 2.0.0 : Sat Mar 10 2007 - 20:12:44 EST