Datanode -> XML

From: Aristedes Maniatis (ar..sh.com.au)
Date: Fri Mar 09 2007 - 05:24:50 EST

  • Next message: Ahmed Mohombe: "Re: Datanode -> XML"

    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


    This archive was generated by hypermail 2.0.0 : Fri Mar 09 2007 - 05:25:35 EST