Hi ,

I have a requirement to support one entity class to map to mutliple tables using hibernate annotations , so how i can i change the table name dynamically ?? , i want to change the table name "persons" to "<dynamic value>" , how can we change that value , if changed then how to reload the session factory ?

Sample example :



Thanks & Regards,
Veena

You can map an entity to multiple tables, using @SecondaryTable annotation, but you cannot change the underlying table(s) on-the-fly.

I wonder why do you even need that because the table names are usually given by a database schema that doesn't change.

However, you can use a custom NamingStartegy (pre-Hibernate 5) or a PhysicalNamingStrategy (Hibernate 5+) so that you can change the entity-table mapping at run-time. But this cannot happen while the SessionFactory is running. You have to switch to a new SessionFactory that takes the custom naming strategy.

Hi mihalcea ,

Thanks for replying , Essentially my problem is I have 1 database containing all of my tables of different basic types, Users, Groups, Addresses. Now to save on performance those 3 types have been split into the respective state of where they are located. Exampe as follows.
---Arizona Users---
Agent_AZ
Groups_AZ
Addresses_AZ
---California Users---
Agent_CA
Groups_CA
Addresses_CA

Example Agent Entity class will be same , and it has to support for (Agent_AZ & Agent_CA) , my entities are tightly binded with annotations , how we can change the @table(name=<dynamically>) and build the session factory again.

Kindly please do need full.

Hi Veena22

I have had to implement the same strategy in one of my projects.
Below is the pattern that I followed.

Create a entity pointing to a base table of Agent, Group etc. with the @Table annotation. Remember that the base tables need to exist. I have a Token table



Lets say I name the Token table Token_SA I need to query that table in my code.
Below is how I do it.

Create the SQL (Native)


Replace the %s with the table (TOKEN_SA) that you want to query. You can use String.format(QUERY, "TOKEN_SA")

Then I create a native query using the sql



Not sure if the solution above is perfect, but it did solve my problem of changing the tables in Runtime

Hi Rentius,

Your solution works only for select queries, but, if you want to have CRUD as well, you need the Naming Strategy option.

You might be interested in a solution such as this one.

Vlad

mihalcea_vlad ,

Can you please expalin about Naming Strategy option , i didnot understand with below mentioned link.


Thanks & Regards,
Veena

What exactly you did not understand?

Well, I am solving similar problem, however, with usage of table partitioning provided by PostgreSQL.

for your case you should create the following structure:
single table USER with field where it belongs (belongs_to) (AZ, TX etc.) (this table will be empty)
create inherited table USER_AZ like
create inherited table USER_TX like


provide trigger if you need to insert data: trigger is applied on USER table, and makes a real insert into partition-specific table. Another trigger is required to trick Hibernate, to make him fill that the data was inserted. If needed I will show you.

All the details you can find in comprehensive PostgreSQL documentation.

Then You can map USER table to your User Entity, and make transparent queries, either on all users (this will make PostgreSQL to work with each tables), or with specifying to which partition it belongs (adding another query option belongs_to = 'AZ' for example), and in this case PostgreSQL will work strait forward with your single table USER_AZ, but you will be querying same hibernate entity and all your logic will be implemented once.

The problem in your case could be, your database is at the moment already partitioned, so you have to create some pl/sql script to efficiently dump and recreate your structure based on partitioning.

and I guess same features could be achieved using other databases. However I would recommend to stick to PostgreSQL - for last 10 years it never let me down.

Rentius, i'm in similar sittuation, but i implement hibertnate annotation, can i use this solution?? if the answer is YES, how?.

Dear Rentius,

i have the same problem, but i implement hibernate annotations, can you say me if it works or i need another solution.