File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Using subselect tag or creating a view Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Using subselect tag or creating a view" Watch "Using subselect tag or creating a view" New topic
Author

Using subselect tag or creating a view

Fletcher Munson
Ranch Hand

Joined: May 16, 2007
Posts: 31
I have a query (below) that needs to pull the most recent activity by transactionId (FK in a transactions table).



The query works exactly how I want it, but when I try to use it in Hibernate I have trouble converting it over. I currently use the SQLQuery interface to run this, but I would like to use a criteria query though I can't seem to find any way to do it. The closest I've come was the <subselect> tag in the mapping file to attempt to create a view. I'm not seeing much documentation on this tag, and it's not totally clear how to use it or what I'm doing wrong. In fact, I'm not ever sure how to access/utilize the view via java after it's mapped properly (DetachedCritiera maybe?).


Can someone help understand how to use this subselect - and will it even do what I want it to?

Thank you in advance.


SCJP 5, SCWCD 1.4
Javid Jamae
Author
Ranch Hand

Joined: May 14, 2008
Posts: 198
This may not be the answer you're looking for, but I always use a view in a situation like this.


Author: JBoss in Action, javidjamae.com, @javidjamae on Twitter
Fletcher Munson
Ranch Hand

Joined: May 16, 2007
Posts: 31
That's what I'm trying to do. Only I don't have access to the DB to create one. Hibernate was supposed to have a way to create one using the subselect tag in the mapping file. Only problem is there isn't much documentation, and I can't seem to figure it out.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using subselect tag or creating a view