hi ,

i have a very large DB that holds complete life cycles with intraday data in 1 minute intervals of stock options , now all the tables are the same (same columns , same column names) but each of them is named with the paper's id and i have one java class that i want to change it's table's reference according to what i choose i want to see is that possible ?

allso maybe u guys know how more efficient (if at all) is it to keep data like that and not in one huge table (of cours i will have to use paperId+DateTime as PK as appose to just DateTime)
thanks in advance.

guys it's realy important to me , i'm aware of @Secondarytable but i have something in the area of 1000 tables and each month 20 more added so it's not practical .

Hi,

All these records are going to be a referenced as a collection in your paper class may be ?

If thats the case try using a stored procedure to load these, it can be referenced using "loader" tag inside set tag in hibernate.

Regards,
Jitendra