subselect « Schema « JPA Q&A





3. Mapping a subselect - variable property for schema name?    forum.hibernate.org

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: Select ACTID as actionId, SUM(EHTOTQTY) as totalQty, etc. etc. from $$VARIABLE$$.ENF110 group by ...