Eclipse Community Forums: EclipseLink » EclipseLink Cache Coordination with Oracle GoldenGate

Help

Home

Home » Eclipse Projects » EclipseLink » EclipseLink Cache Coordination with Oracle GoldenGate

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

EclipseLink Cache Coordination with Oracle GoldenGate [message #660750]

Mon, 21 March 2011 13:14

Moritz

Messages: 2
Registered: March 2011

Junior Member

Hello everyone,

we evaluate the following setup: in order to balance queries to our main database, we would like to create a "mirror" using Oracle GoldenGate.
Each mirror would be used by a separate application instance. Each application has an EclipseLink layer including caching.

Is it possible to update the cache of the "mirror" application instance every time a replication happens?

Thank you in advance.

Report message to a moderator

Re: EclipseLink Cache Coordination with Oracle GoldenGate [message #765281 is a reply to message #660750]

Tue, 13 December 2011 19:05

urkings Missing name

Messages: 8
Registered: December 2011

Junior Member

Moritz did you get a solution for this problem? Currently I have the same problem.

Report message to a moderator

Re: EclipseLink Cache Coordination with Oracle GoldenGate [message #768209 is a reply to message #765281]

Mon, 19 December 2011 19:04

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You would need to be able to receive events from GoldenGate in Java and either invalidate the EclipseLink cache directly using its invalidation APIs, or send EclipseLink cache coordination invalidation events to the server with the cache (or raise your own events through JMS or other).

GoldenGate does have a Java mechanism that can let you do this.

James : Wiki : Book : Blog : Twitter

Report message to a moderator