I'm working with as AS400 DB2 setup where the library file/schema name is different for each environment.

Using Hibernate3, I wish to use the same mapping for each environment, thus I need to externalize the schema property.

This is fine (using default schema) until this subselect object:

<class>
<subselect>Select ACTID as actionId, SUM(EHTOTQTY) as totalQty, etc. etc. from $$VARIABLE$$.ENF110 group by ACTID </subselect>
</class>

$$VARIABLE$$ is what I want to externalize. Is this possible?

(Potentially, there is another solution entirely, please let me know)
Thanks.,