In the hibernate doc,, there is an "area&night" example, but I don't know how to use that NamedNativeQuery in Java.

@org.hibernate.annotations.NamedNativeQueries( {
@org.hibernate.annotations.NamedNativeQuery(
name="night&areaCached", query ="select night.id as nid, night.night_duration, night.night_date, area.id as aid, "
+ "night.area_id, area.name from Night night, tbl_area area where night.area_id = area.id",
resultSetMapping="joinMapping")
} )

@SqlResultSetMapping(name="joinMapping", entities={
@EntityResult(name="org.hibernate.test.annotations.query.Night", fields = {
@FieldResult(name="id", column="nid"),
@FieldResult(name="duration", column="night_duration"),
@FieldResult(name="date", column="night_date"),
@FieldResult(name="area", column="area_id")
}),
@EntityResult(name="org.hibernate.test.annotations.query.Area", fields = {
@FieldResult(name="id", column="aid"),
@FieldResult(name="name", column="name")
})
}
)

Say in java, I do:
List l = entityManager.createNamedQuery("area&night").getReaultList();
What will be the object type of the result list?

I dont think that query would run, you would probably need to do:

And then obviously make a ObjectWithConstructorToTakeAllTheseArgs class.

Actually Adam,

You are incorrect and you don't need to do that for the example the poster is asking about. You need to brush up on some of your Hibernate docs :)



You will get back a tuple Night and Area objects:



If you look at the ResultSet mappings, you'll see that the example returns multiple types in the result set. Whenever Hibernate does this, it comes back as an array of Objects in the order they are defined in the mapping.

Ryan-