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
