In @Table(name = "tableName") - make "tableName" a variable in JPA

Question

I am using JPA and I need to make the "tableName" a variable.

In a database, I have many tables, and my code needs to access the table where I specify it to read.

@Entity
@Table(name = "tableName")
public class Database implements Serializable {...............}

Any ideas?

Answer 1

You can do something like this, if thats your concern, I guess. Never tried it, its just a wild guess. But thats the usual practice, I follow for Named Queries, yes thats different thing altogether.

@Entity
@Table(name = Database.tableName)
public class Database implements Serializable {
    public static String tableName = "TABLE_1";
    ...............
}

But I don't see why anyone would do that. Could you tell us what are you up to? Why you have few tables exactly same definition?

[Edited]

I tried your solution. It did not work, it says: The value for annotation attribute Table.name must be a constant expression.

So, isn't that clear enough? I mean you can't do that. And I believe its quite logical. If you want Hibernate to generate your schema then you can define all the entities you want, in the schema, and with the appropriate relationships.

Answer 2

Specifying the table name at runtime is not possible, this is simply not how JPA works (and I'm still not sure to get your requirement). Either map different entities on your set of tables and run various queries or build them dynamically (maybe using the Criteria API) depending on the input from the client side or use something else than JPA (like iBATIS).

Answer 3

I'm going to try modifying orm.xml at runtime before loading the entitymanager