Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Manage Bi-temporal Data
Manage Bi-temporal Data [message #1626055] Fri, 20 February 2015 20:07 Go to next message
Prashant Saraf is currently offline Prashant SarafFriend
Messages: 10
Registered: February 2015
Junior Member

I have a bitemporal database, each table will have active record and expired record( active record is record with current date is between stDate and endDate), below is example

Seller has items..

now item table has start and end date when we want to expire item we simply change the expire date to past date.

While writing Named query we can write stDate >current date and endDate <current Date. But I want to generalized this so every time I query any table it will bring only active record. I have more than 100 table so I am looking for way to configure so my JPA will always fetch active record.

What I mean is database has a star table if I query with JPA eager fetch it is getting all the record(active as well as expired) from all the joined table.

Note this is read only service so I am not worried about write/update operation.

Any suggestion will be great help.
Re: Manage Bi-temporal Data [message #1633204 is a reply to message #1626055] Tue, 24 February 2015 18:45 Go to previous message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1389
Registered: July 2009
Senior Member
Have you seen ?
Previous Topic:EclipseLink-6112 : Fetch group cannot be set on report query
Next Topic:SQL generation fails - Resource '/<project-root>/createDDL.sql' does not exist.
Goto Forum:

Current Time: Sat Apr 20 03:45:25 GMT 2024

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

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

Back to the top