[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-298) Mapping of Oracle`s XMLType datatype into class

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Thu, 28 Aug 2003 2:32 PM
       Body:
Certainly you can use createSQLQuery() for this.

However, what you did with the formula attribute SHOULD have worked. Hibernate should not have aliased the function call. Can you show the _exact_ mapping you used?
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-298


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-298
    Summary: Mapping of Oracle`s XMLType datatype into class
       Type: Improvement

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
   Versions:
             2.1

   Assignee: 
   Reporter: Marc Villeneuve

    Created: Thu, 28 Aug 2003 10:34 AM
    Updated: Thu, 28 Aug 2003 10:34 AM
Environment: Oracle 9ir2, patchset 9.2.0.3. and Hibernate 2.x

Description:
Hi,

There is no simple way to currently map data provided from an XMLType (xml document) into a class without rewritting a serious amount of code in EntityPersister ( please tell me if I am wrong). Extraction requires using xpath through proprietary functions (extract and extracValue).

The new formula attribute might have improve the current situation since it is now possible to call for the function, but the Oracle syntax looks more like "extractValue( alias.column, xpathExpression)" and "alias.extractValue( alias.column, xpathExpression)" as generated is invalid.

If this can be achieved otherwise (by sending a direct SQL query ?), please be nice enough to point me in the right direction.

Thanks


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira