Is there a way to return a sql query as a list of entities that has its @Id as null from a left outer join query? Maybe return query as detached or something similar.

Thanks,
Sam

Hi firehooper,

the ID of an entry is never null by definition. Otherwise it would not be an ID. The result set of you scenario would be empty since there are no entries with null for their IDs.

CU
Froestel

Sorry I guess I could have worded this differently. I do a left outer join on a two tables on the two fields making up a composite key to determine which rows are missing from a table therefore the generated surrogate id is null, but still a valid new entity without a Id. I am currently returning a Object[] then setting all fields except Id in my DAO then return a list of entities. I was just seeing if there was a built-in hibernate way of doing this.