[hibernate-dev] subselect mappings

Steve Ebersole steve at hibernate.org
Mon Feb 20 16:22:24 EST 2012


Another subselect usage that does not currently appear to be supported 
in annotations is for collection mappings.  In hbm.xml you can specify 
a subselect as the table for collections.


On Mon 20 Feb 2012 01:21:35 PM CST, Steve Ebersole wrote:
> Also, annotations currently do not support the full breadth of 
> subselect mappings available in hbm.xml.
>
> For example, secondary tables in annotations cannot be defined using 
> these subselecty mappings while they can in hbm.xml. If its important, 
> it should be avilable everywhere no?
>
> On Mon 20 Feb 2012 01:09:57 PM CST, Steve Ebersole wrote:
>> for the "completeness" argument, the corollary to those others is 
>> actually loader, which is the ability to name a query to use for 
>> loading an entity/collection.
>>
>>
>> On Mon 20 Feb 2012 12:57:36 PM CST, Emmanuel Bernard wrote:
>>> I find the second reason important. In some organizations, the idea 
>>> of developers owning a schema especially on legacy database is 
>>> harder than climbing the Himalaya bare foot.
>>> Having access to the subselect views helps.
>>>
>>> I also like it for completeness since we can override insert / 
>>> update / delete statements.
>>>
>>> On 20 févr. 2012, at 18:52, Steve Ebersole wrote:
>>>
>>>> subselects are a feature that was originally put in place to support
>>>> databases without view support and/or application developers which did
>>>> not have access to create views on their target database.
>>>>
>>>> I am contemplating whether we want to continue to support this.
>>>>
>>>> At this time I all real databases out there support views. Anyone know
>>>> of any that do not?
>>>>
>>>> I am not inclined to leave the feature in place just for the second
>>>> reason. They could always define the view in a schema in which they do
>>>> have access to create views.
>>>>
>>>> Thoughts?
>>>>
>>>> -- 
>>>> steve at hibernate.org
>>>> http://hibernate.org
>>>> _______________________________________________
>>>> hibernate-dev mailing list
>>>> hibernate-dev at lists.jboss.org
>>>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>>
>>
>

-- 
steve at hibernate.org
http://hibernate.org



More information about the hibernate-dev mailing list