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? >>>> >>>> -- >>>> st...@hibernate.org >>>> http://hibernate.org >>>> _______________________________________________ >>>> hibernate-dev mailing list >>>> hibernate-dev@lists.jboss.org >>>> https://lists.jboss.org/mailman/listinfo/hibernate-dev >>> >> > -- st...@hibernate.org http://hibernate.org _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev