People I already search in a lot of google sites and do not found any solution that fits my problem. I have the following SP in SQL Server 2005 Express:
Isn't a very well designed procedure, It just returns me a result set. Well I tried to map this procedure as a nativeNamedQuery(annotation) and as a xml mapping. But I have the problem in the return type. I have a bean :
Well on my procedur I did return the sum(field1), field2, these both fields are on my bean but I wont to return it on my queries, so I must create a bean with only 2 attributes mapped as my procedure's return columns ???
Following is my namedQuery and my orm.xml mapping
The Death of one is a tragedy, but the Death of a million is just a statistic. Joseph Stalin
SCJP 6.0, SCJD
subject: Stored Procedures + Hibernate + Xml mapping