From: Hank Ratzesberger <hankr_at_crustal.ucsb.edu>
Date: Wed, 16 May 2007 09:12:54 -0700

Disclaimer: I haven't done this on an application of any
size.

Since you already have a schema, Oracle can "shred" your
schema to tables, and you can annotate your schema to
control table names and other aspects.

You can use XQuery to get XMLType data.

You would unmarshall the data to store it, and marshal
your query results -- not saving objects, but XML.

For a considerable fee, Oracle consultants will get the
whole thing configured.

http://www.oracle.com/technology/tech/xml/xmldb/index.html

Cheers,
Hank

Hank Ratzesberger
http://nees.ucsb.edu/
Institute for Crustal Studies
University of California, Santa Barbara

  ----- Original Message -----
  From: William Saxton
  To: users_at_jaxb.dev.java.net
  Sent: Wednesday, May 16, 2007 7:36 AM
  Subject: Storing JAXB structured XML in Oracle


  Hi all,

    Fairly new JAXB user here with a question.

    What is the best way to store XML data handled by JAXB objects? Currently, I marshal the object to a string, use XMLType.createXML to convert it to an XMLType, then store it as an object using stmt.setObject(). Is this the right approach?

    I also have the context path somewhat "hard-coded" in the java code in order to marshal/unmarshall the data. Do you think I should also save this in the database along with the XML or read it from a config file?

    Thanks.

  -Bill