Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

3.1.3:

Mapping documents:
[b] How do we map view query in hibernate mapping file

This is my view.
create view con_metrix as
select trans_log.CONTRACT_NAME contractName,
avg(trans_log.PROVIDER_WS_TOTAL_TIME) averageTime ,
MAX(trans_log.PROVIDER_WS_TOTAL_TIME) maxRespTime,
MIN(trans_log.PROVIDER_WS_TOTAL_TIME) minRespTime,
COUNT(trans_log.STATUS) status from CON_TRANSACTION_LOG trans_log
GROUP by
trans_log.CONTRACT_NAME, trans_log.STATUS;
How can i map this to mapping xml

Thanks
Shanmugam.VE

You could map it like any other entity. However the catch is that data in a view is really not a "persistent" entity.

There are some approaches to solve your problem:
1. Declare the query for the viewas HQL and use it in your application. However if the view is being used for other JOINs this might not work out.

2. Declare the view as a Persistent Entity. The downside is that you are forced to define a "id" element for the <class> even though you can never insert or update to the view. You can prevent INSERT and UPDATE of other properties using the "insert=false update=false" attributed of <property> but <id> does'nt support that. There are definitely loop holes to making this a persistent entity.

3. Do no make this a persistent entity. You can have standalone class representing the results and use can ask Hibernate to type case the result into that class using the "select new Metrics(.....) from.." syntax of HQL. This way the Metrics Java class is not required to be Persistent and will not be managed by Hibernate.