Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1.6

Mapping documents: n/a for now

Code between sessionFactory.openSession() and session.close(): n/a

Full stack trace of any exception that occurs: n/a

Name and version of the database you are using: Oracle 9i

The generated SQL (show_sql=true): n/a

Debug level Hibernate log excerpt: n/a

Hello all,

I have a question on how to interact Hibernate with data stored in XML format using Oracle's XDB feature.

Description: I have registered my XML schema with Oracle XDB. Data will be stored into Oracle in XML format. I am now in the process of creating database views which maps to the xpaths so that other processes can manipulate these XML data using relational queries, without knowing or understanding the structure of the XML documents.

Question: I am not sure how to provide surrogate keys and version columns for these views so that Hibernate can perform its magic. Specifically, the complex types in my XML schema currently do not have elements for the surrogate keys or the version columns defined. Do I need to provide surrogate key and version elements for each complex type in the XML schema so that each database view can include the surrogate key and version columns? I guess my general question is: if Hibernate were to interact only with database views, should these views include surrogate key and version columns as well (so I can still take advantage of Hibernate's managed versioning, transient vs. detached instances, and all that good stuff)? Or is there something entirely different that I should focus on such that Hibernate can handle structured XML data in Oracle XDB?

Thanks in advance for any comments/suggestions. Please let me know if I should provide more clarification.

IK