Hi Phillip, I have run into this too, and although it is a common problem when you have multiple data sources (jackrabbit, RDBMS, filesystem, XML database, etc) there is no available solution or best practice.
The only recommendation is to define one as the 'primary' datasource and create a check-program based on the 'primary' datasource to audit the peripherial datasources and identify items that are missing or may have discrepancies in dates based on expectation (the image is from 2004, but the item in the RDBMS is a new item in 2007). My two coppers, -D > -----Original Message----- > From: Phillip Rhodes [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 24, 2007 4:44 PM > To: users > Subject: associating jackrabbit content to your application > database objects? > > Hi everyone, > Just wondering if anyone has thought about this problem. I > store different types of objects in jackrabbit (e.g. Images, > Thumbnails, Galleries, Html Content, etc)... In my > application, I have a database model (e.g. products, > profiles). Each object in my database model is associated to > jackrabbit content. For example, a product may have images. > > I find myself having to create database objects that > represent my jackrabbit items. For example, I will create a > "Image" object that is a database object. This database > record that represents an image node in jackrabbit is > associated to products, and stores the path to the node that > stores the image... > > One problem that I am concerned about is the possiblity of my > jackrabbit repository getting out of sync with my database > table. There may be other issues that I haven't considered. > > I would appreciate some thoughts on this. > Thanks! > > Phillip > > >
