File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes entity loading blues Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "entity loading blues" Watch "entity loading blues" New topic

entity loading blues

Tudor Raneti
Ranch Hand

Joined: Nov 29, 2009
Posts: 145
I got this scenario:
a query from wich i need to return a list of beans, that i don't want persisted.

The question is:
Can i do that directly speifying the bean like:

w/o having to map the Person to a table?

Closest answer for that from what i found is the one below, but i need to know the answer to the above question, it makes the following solution redundant.
EDIT: shortest question would be: how can i externalize a named query w/o an entity, and also map the result set to a bean with the least configuring possible.
Tudor Raneti
Ranch Hand

Joined: Nov 29, 2009
Posts: 145
Well, the only way to populate non-entity beans is to use Transformers.aliasToBean() it seems. BTW, it only accepts the column name, not an alias of it. It only needs matching type with the bean fields / public accesor methods.

Otherwise externalizing a SQL query, is as simple as:

and registering it in the hibernate config file.
Shaun M. Smith

Joined: Jul 06, 2010
Posts: 1
Seeing your posting I blogged about how to do this in EclipseLink here:

I agree. Here's the link:
subject: entity loading blues
It's not a secret anymore!