Hello,

I am currently facing an issue while trying to select some records out of a table. For insertion i have used some properties which not directly map with a column from a table, but i am using this property as a parameter in a stored procedure.

===
<property name="organizationId"/>
===

The problem is that while trying to select records from the database Hibernate expects a mapping to a column.

Does somebody know how i can tell hibernate that when i select something from the database, it should not get that property, so it will not throw an exception?

Please let me know.

Regards,
Martijn

If you don't want hibernate to fetch a property, then don't specify the property in the hbm.xml file?

No, that's no option. Like i said, i am using the property as a parameter for a stored procedure which inserts data to my table.

Any other suggestions?

Is organizationId a foreign key in your database ?

If it is, how about having a many to one relationship between your class (the one you try to map) and a class named 'Organization' which primary key is mapped to the organizationId column of the ORGANIZATION table in the database

So you can access the organizationId as follow :
myObject.getOrganization().getId()

In an object model, foreign key does not exists, only association does.

Then maybe you should have a look at interceptors, especially the onload method. I suppose you could filter out unwanted properties there.