Hi all.


This is my very first post here, so please forgive any redundancy.

I am a DBA, and my company is using H.E.M. (Hibernate Entity Manager). I was told by an engineer that H.E.M. prefixes the schema name of accessed database tables to that of the connecting user. For example, if my DB2 database account username is MICKEYMOUSE, and I connect a database called DISNEY, then all tables that I try to access within DISNEY will be accessed as MICKEYMOUSE.*.

The issue is that I need to change/set the schema name of accessed tables to something other than the name of the connecting user. For example, I need the schema name to be DONALDDUCK.* instead of MICKEYMOUSE.*. However, I was told that H.E.M. fixes the schema name to that of the connecting user, and there is no way to change this. I do not believe this statement.

Within H.E.M., is there a setting or a file in which a setting can be changed to allow schemas to be different from the name of the connecting user?


Thanks in advance for any assistance.

-Z