Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version: 3.0.3
Name and version of the database you are using: Oracle 10g
I am using a <formula> tag inside a property mapping to perform an aggregate sql function to populate a derived property on my bean. In this formula I do a select on tables by name. Hibernate does not prepend the default schema name to these which leads to "table or view does not exist" errors. If I hardcode the schema name in the formula, it works fine. The problem is that that's kind of a no-no on our project as we are using JNDI to look up the schema name and set it in the configuration, and don't want to have to go about doing copy and pastes each time we deploy to a new environment with a new schema name. Does anyone know of a better aproach to derived properties that would allow me to avoid this? Any chance a future version of hibernate will prepend the default or mapping-declared schema name to tables referenced inside a formula tag or attribute?
Any help is appreciated.