Hi,

We are using the database DB2/400 on OS/400 V5R4, IBM Iseries
Our Schema stucture and application structure is ofcourse tightly coupled as it is a legacy database.

Each user of the application has a specific schema/library specified.
All the DB operations performed/executed by that user should only effect in the specified schema.

We are planning to implement DB persistance using Hibernate3 and we are mandated to follow the same principle of specifying the schema for every user.

Perviously we used to build SQL statments dynamically as following.

String sql = "SELECT * FROM " + library + ".VENDORS";

where the library is a HTTPSession attribute maintained for every user when the user logs in.

I have gone through the documentation and some books on Hibernate regarding the Schema/Library. In that I could only find ways to mention the schema statically in mapping files using the schema attribute in the class entity. This will not cater our specific need on this issue.

I am looking for a way to dynamically mention the schema for a particular Hibernate session, by which I can make sure that all the DB operations are done on that schema objects.

Can anyone please help me out, by suggesting the right way and if not any work arounds on this issue.

Appreciate any help!!!

Thanks & Regards

Hi,

Can dynamic schema name can be set to all the HQL statements for a particular user. if yes, how????

Thanks & Regards,

I noticed this post is similar to post

http://forum.hibernate.org/viewtopic.ph ... ht=iseries

I am facing a similar situation where the same table name exists in different libraries. For example, table company will exist in mcparm, peparm, and myparm library. Based on what the company ID is what determines which library to read.

Company 1
Select name from mcparm.company
Company 2
Select name from peparm.company

Can anyone point me in the right direction as to how to map this? Do I need to map each table in each library?

I'm using Hibernate 3.1.

Any help would be great!! Thanks!