Hibernate Community • View topic - how to map a stored proc using nhibernate

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

how to map a stored proc using nhibernate

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

sandipandeb

Post subject: how to map a stored proc using nhibernate

Posted: Mon Oct 17, 2005 2:06 am

Beginner

Joined: Mon Oct 17, 2005 1:58 am
Posts: 27

Is it possible to map a stored procedure using nhibernate? If yes, how?
If no then what is the alternative solution? Any illustrative example will be greatly appreciated.

Top

lmcpferreira

Post subject:

Posted: Tue Oct 18, 2005 9:23 am

Beginner

Joined: Tue Aug 09, 2005 9:43 am
Posts: 30
Location: Lisbon, Portugal

From what I read that will be sometime after the 1.0 release (which already happened).

If you'd like to see this implemented, like I would, you can vote for it here:
http://jira.nhibernate.org/browse/NH-258
:wink:

Top

jnapier

Post subject:

Posted: Tue Oct 18, 2005 1:28 pm

Senior

Joined: Sat Sep 10, 2005 3:46 pm
Posts: 178

I have a workaround for complicated list queries that require a sproc and cant be done with HQL.

What I do is have the sproc return the identifiers of the entities I am querying for. I store these identifiers in an array. Then I use ICriteria with an InExpression and pass in the Identifiers that I got from the sproc.

Granted two queries are required, but I think performanc is acceptable until sproc support is provided.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum