> -----Original Message----- > From: Jukka Zitting [mailto:[email protected]] > Sent: 30 March 2009 17:13 > To: [email protected] > Subject: Re: referential integrity in the DB BPM > > Hi, > > On Mon, Mar 30, 2009 at 5:52 PM, Connor, Brett (LNG-TWY) > <[email protected]> wrote: > > I've added a FK constraint from one of our tables to the BPM BUNDLE > > table, but AFAICT everything else is stored as binary data. > Has anyone > > explored or thought about the possibility of adding more > fundamental > > integrity checks here? > [JZ] > Doing something like that can easily get you in trouble. > Jackrabbit expects to be in full control of the underlying > database, and modifying the schemas Jackrabbit uses is an > easy way to to subtly break things. > > BR, > Jukka Zitting
Agreed, I'm certainly not proposing modifying the tables, I was kind of hoping that there is some ability planned to do this, or (very optimistically!) someone with knowledge could point at some cunning ideas that I haven't thought of. Data integrity doesn't strike me as something that should be outside the realm of a CMS, especially as you say because the tables should be black-box to applications. Regards Brett LexisNexis is a trading name of REED ELSEVIER (UK) LIMITED - Registered office - 1-3 STRAND, LONDON WC2N 5JR Registered in England - Company No. 02746621
