Originally posted by Nathan Hook:
<sarcasm>
I would think that the schema would be identified by the database connection string found in the hibernate properties file.
You are right. What really is needed is how in the .hbm.xml file we do configurations in such a way that we terminate the schema. For ex..the SQL that hibernate generates from the XML is
select mmsservice0_.SERVICE as col_0_0_ from PROD40.PR.MMS_SERVICE mmsservice0_
where PROD40 is the schema name and PR is the username. I need to have the SQL as follows
select mmsservice0_.SERVICE as col_0_0_ from PR.MMS_SERVICE mmsservice0_