Eclipse Community Forums: EclipseLink » Manage Bi-temporal Data

Help

Home

Home » Eclipse Projects » EclipseLink » Manage Bi-temporal Data

Show: Today's Messages :: Show Polls :: Message Navigator

Manage Bi-temporal Data [message #1626055]

Fri, 20 February 2015 20:07

Prashant Saraf

Messages: 10
Registered: February 2015

Junior Member

Hi

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.

Report message to a moderator

Re: Manage Bi-temporal Data [message #1633204 is a reply to message #1626055]

Tue, 24 February 2015 18:45

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

Have you seen http://java-persistence.blogspot.com/2010/08/eclipselink-filters-how-to.html ?

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:16:29 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter