Re: Java Toplink Essential - Change entities tables at runtime

From:

Martin Gregorie <martin@see.sig.for.address.invalid>

Newsgroups:

comp.lang.java.databases

Date:

Wed, 10 Sep 2008 21:52:33 +0000 (UTC)

Message-ID:

<ga9fj1$t22$2@localhost.localdomain>

On Wed, 10 Sep 2008 01:23:48 -0700, nicola wrote:

In my db there are some tables like

TABLE1_2006 (ID, CODE, VOLUME)
TABLE2_2007 (ID, CODE, VOLUME)
TABLE3_2008 (ID, CODE, VOLUME)

They are equal but have diffferent name. In fact these tables are
created
every year (as you can see).
In this sense they use the same entity

public class MyEntity implements Serializable {
    private static final long serialVersionUID = 1L; @Id
    @Column(name = "ID", nullable = false) private Integer id;
    @Column(name = "CODE")
    private String code;
    @Column(name = "VOUME")
    private String volume;

...
...
...
}

I need to obtain different list of entities relative to all tables in
the same database;
can I change table name of my entity at runtime ?

Declare a view over all the tables and enquire on that.

But, why on earth use multiple tables? They don't do anything that a
single table with a YEAR column couldn't do while managing to make at
least one task more difficult as you've just demonstrated.

--
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |