Hi - I need to add a restriction to a Criteria-style query like this:

Restrictions.sqlRestriction(
"{alias}.CUST_ID in (
select distinct SYNM_CUST_ID
from CDIR.SYNM where SYNM_NAME like ?
)"
);

The issue is that I don't want to hard code the schema of the SYNM table (in this case, CDIR). Is there a way for an SQLRestriction to reference the default_schema from the Hibernate configuration?

Is there another way to skin this cat?

jon.