Patterns for exposing JackRabbit data for joins to relational data

[Shaun Barriball <sb...@yahoo.co.uk>]

Hi all,
JackRabbit provides an ideal repository for structured data.
In some applications you may wish to lookup JackRabbit data as part of a
relational query on an external relational database. For example, assume I'm
displaying content items on distinct web pages. I'm using a relational db to
record page requests for that content:

Table PAGE_REQUESTS
-------------------
Id 		  (int)
createdDate   (Date)
contentItemId (String)

Lets assume I then want to generate a report including fields from the
Content Item in JackRabbit e.g. name, path etc. I effectively need a
transient table I can join to access data from JackRabbit in a relational
world.

Can anyone recommend an effective way to solve this?

My initial thoughts are:
 * use the EventListener model to register an observer which synchronises
the required fields in a separate database table, or
 * run a nightly export to generate the data warehouse tables
Both not ideal.

All help appreciated.
Regards,
Shaun.



	
	
		
___________________________________________________________ 
All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of use." - PC Magazine 
http://uk.docs.yahoo.com/nowyoucan.html