This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored Procedures + Hibernate + Xml mapping

 
Matheus Mendes
Ranch Hand
Posts: 68
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ranches !


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



 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic