Hi,

I am implmenting one of the use case with spring and hibernate, I am having problem with mulitple schema of db2. Let me first give some details:

Database: DB2
Database name: ABC
Schemas: Under database ABC- I have four schemas IL,TX,NJ and CA (for each state different schema)
Under every schema I have tables like P,Q,R (same table definition under every schema)

Now data of each state should be stored under their schema.

As its clear that I have same database so I configured only one session factory pointing to this database. Now runtime I have decide in which schema I have to store data, so for that I have mapped my class with diffrent entity-names, my mapping for class P will be something like




Now when I have to save say my POJO in IL schema, I am using this


And so far this is working fine for saving data. But now I want to write finder methods using hql/criteria, but not sure how to use the entity-name into them. If I just use finder without any entity name then I think it will search on all tables. Not sure how come hibernate miss to handle this scenario of (Mutliple schema , same database, same table strcture problem).

And ya its very necessary to store data in seperate schema - its valid requirement that data of IL customer should be in IL schema.

Please advice how should I go for implementing finder methods.
Thanks,
patemir

Hi Patemir,

Did you try with criteria API provided. you can use following method,
https://www.hibernate.org/hib_docs/v3/a ... .String%29

public Criteria createCriteria(String entityName)

and create your queries.

yeah , thats works.

But so I think everybody is agree with the approach of solving my problem. (use of entity-name).

I thought , people reading this will first ask/suggest some other solution to solve the problem. But I think that is only way to solve problem (using entity-name).

-thanks