Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Changing Tablename changes on-the-fly? (trying to determine if this is possible)
Changing Tablename changes on-the-fly? [message #1063235] Wed, 12 June 2013 18:53 Go to previous message
Adam Vainder is currently offline Adam VainderFriend
Messages: 2
Registered: June 2013
Junior Member
We have a reporting detail table that, due to performance concerns, we are considering refactoring to produce a new instance of the table for each individual report. The table names would end with "_<report_id>" e.g. details_1, details_2, etc

This is an Oracle 11g SE with no option to switch to Enterprise, nor to change to a different database with partitioning; the reason for the consideration is that as the table gets large and/or stale rows are deleted, the performance gets terrible.

One thing stopping us is that our Eclipselink entity has the @Table attribute.

Eclipselink 2.4.1
Glassfish 3.1
Eclipselink access is being made in web services in GF.

We also would have multiple user at once, so any solution would have to be entirely session-based.

I would like to know if, and how, we could change the table name for the entity on-the-fly (at startup is not an option because new reports can happen all the time)?


Thank you for your time.
 
Read Message
Read Message
Read Message
Previous Topic:v.2.6.0 and JGroups
Next Topic:Please vote to publish standard JPA 2.0 & 2.1 jars to Maven
Goto Forum:
  


Current Time: Sat Jul 22 09:07:09 GMT 2017

Powered by FUDForum. Page generated in 0.02573 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software