Hibernate version: 2.1.7

Mapping documents:

Code between sessionFactory.openSession() and session.close(): N/A

Name and version of the database you are using: Oracle 9.2.0.5


Hello all,

I have a class that I am persisting in a table, and I have added some attributes that are calculated via a stored procedure in the database using the formula attribute.

This works fine, except in my more complex cases where some of the parameters to the stored procedure are not available from properties of the class itself. I would like to be able to pass them in as parameters to my query. But it appears that Hibernate does not see them as parameters.

For example:


and:




Apart from resorting to a native SQL query (which I am not 100% will work), is there someway to achieve what I want?

Thanks in advance for any help,
David Sykes

Maybe not the correct forum, but I'll just kick this topic, as it is exactly what I'm looking for: named parameters in calculated properties. Are there any updates on this?

Me myself, I'm using NHibernate 1.0.2.0 on Sql Server 2000.

Hi Grimace,

I never received an answer to my original query, so in the end we solved the problem using views.

So, let's say that I have table A, with columns A,B,C. When I select from this table I want to also retrieve the result of calling function F.

Now, I can get the values for function F from the columns of table A, and from the columns of table B, which are D,E,G.

So I create a view:

CREATE VIEW v AS
SELECT a.a., a.b, a.c, b.g, f(a.c, b.d, b.e) f
FROM a, b;

I then map v to a class using hibernate, and set it as read-only. To query from v I need to make sure that I define a condition for B.G, otherwise I end up with a cartesian join.

This has worked very well for us. The obvious downside is that you need to map to two different classes if you need to also write records to table a.

I hope that helps you out,
Dave