[Hibernate-issues] [Hibernate-JIRA] Created: (HBI-7) Allow mapping class to more than one table/view

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

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HBI-7
    Summary: Allow mapping class to more than one table/view
       Type: Improvement

     Status: Unassigned
   Priority: Major

    Project: Hibernate 1.2

   Assignee: 
   Reporter: Frank Calfo

    Created: Mon, 28 Jul 2003 10:16 AM
    Updated: Mon, 28 Jul 2003 10:16 AM

Description:
I have multiple views that return different results, but all share a common structure 

I have a class defined to represent one row from the view 

I can map this class to the view and use a hibernate query to get a collection of objects 

Now I want to be able to define the second query that returns data from the second view. It seems like I would need to be able to map the same class to a different view but I don't think that will be allowed in Hibernate. 

For example: 

Here's the common class mapped to the first view: 

<class name="ResultSetRow" 
table="VW_REQUESTS_MANAGER" 
mutable="false"> 
<id name="reqId" column="req_id" type="long" unsaved-value="null"> 
<generator class="assigned"/> 
</id> 
<property name="name" column="name" type="string"/> 
<property name="date" column="date" type="timestamp"/> 
<property name="type" column="type" type="string"/> 
</class> 

and here's the Hibernate query that returns a collection of objects for each row returned by the view: 

<query name="PendingRequests.ForManager"> 
from ResultSetRow as list 
where list.managerId = :manager_id 
</query> 

The key issues are these: 
1) The structure of each result set will always 
be the same, only the contents will differ 
2) A set of different database views will be created that share the same structure but return different content according to their purpose 
3) I'd like to be able to share a common class instead of defining a different class for each different result set 
4) I'd like to be able to create a set of mappings for each database view that returns the common class that defines the structure of the result set 

Can I use a common class and map it to different table/views - or does the rule that one class maps to only one table prevent it ? 

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