Hi david I inserted those ActionNodes manually as you suggested, I presume what you mean by user nodes, is adding '/users/root' (and so on) to the objects table as SubjectNodes? I have had another look at Domain.xml and I can see '/files' defined as a SubjectNode also, should I add this to objects table too?
The only place I can see any mention of LinkNodes are where you link users together, to say (from what I can gather) that say /users/john and /users/groupA/john are the same user... Yet, it still throws that big exception at the start, when it can't find any uri's that are linked to /actions. i.e.: SELECT * FROM links WHERE linkto='/actions'; This seems a bit weird to me... any ideas?! It will start up after this exception, but I have just tried to access Slide in this situation, and it then throws a 500-error (as before) and on the server console it looks as if it was trying to execute this statement: SELECT * FROM links WHERE linkto='/'; It is getting further than it was before though... I am making progress! Anyone have any ideas what this links table is all about, and what needs to go in it?! Cheers stu -----Original Message----- From: David Leahy [mailto:[EMAIL PROTECTED] Sent: 14 August 2003 17:46 To: Slide Users Mailing List Subject: Re: JDBCDescriptorsStore setup Hi Stuart, For some reason you are missing the /actions/read, /actions/write, and /actions/manage ActionNodes from your objects table. They should be created by the default Domain.xml -- and weirdly enough, these nodes appear in the children table (which describes the hierarchy), but not in the objects table! I bet you could fix this by grabbing an original Domain.xml and seeing how those sub-nodes should be created; it must have been deleted or commented out or something in your Domain.xml file. Also, you have no user nodes. Examples of these (root, john) appear in the out-of-the-box Domain.xml. You'll need a user node to be able to authenticate and to be authorized to see content. Once these nodes are created in your persistent store by Domain.xml, then you don't need them in Domain.xml anymore, unless you want to start over. OTOH, it doesn't do any harm if Slide tries to re-create these nodes on subsequent start ups. Your 500 errors are coming from the missing action nodes, though, methinks. Dave Leahy Sandia National Labs 925-294-2678 [EMAIL PROTECTED] Stuart MacPherson wrote: > Here is the lowdown on my DB schema contents - I presume there is more wrong > with it that I know about - please advise! It looks very empty to me... > what else needs to go in there? Anyone have any ideas why it's not updated > automatically? Also, does anyone know which table JDBCContentStore puts the > documents in to? > > > > Branches - empty > > Children - uri childuri > / /users > / /tempaction > / /actions > /actions /read > /actions /write > /actions /manage > > label - empty > > links - empty > > locks - empty (I presume this is ok at the mo) > > objects - uri classname > / > org.apache.slide.structure.SubjectNode > /tempaction > org.apache.slide.structure.ActionNode > /users org.apache.slide.structure.SubjectNode > /actions > org.apache.slide.structure.ActionNode > > permissions - lots of stuff in this one - looks ok! > > Property - empty > > Revision - empty > > Revisioncontent - empty > > Revisions - empty > > Workingrevision - empty > > > > Thanks again in advance > stu > > > > -----Original Message----- > From: Stuart MacPherson [mailto:[EMAIL PROTECTED] > Sent: 14 August 2003 15:44 > To: 'Slide Users Mailing List' > Subject: JDBCDescriptorsStore setup > > Hi everybody > > I am having bother setting up JDBCDescriptorsStore... > > I have had a flash of inspiration, and have ripped JDBCDescriptorsStore > source to shreds trying to find out what makes it tick. I have added in > loads of debug code, and I have found that it is throwing a > NullPointerException because it is trying to retrieve stuff from the > database that isn't there... I know I went the roundabout route to figure > that out when it should have been obvious, but at least now I know! > > More specifically, it is trying to do the following statement: > > SELECT * FROM links WHERE linkto='/actions'; > > I have had a look at the links table, and it's empty... This is definitely > what is causing me grief! > > Now, I am know that the 'linkto' column should have uri's in it like > '/actions', but what others?! Also, I am guessing that there should also be > uri's in the 'link' column, and this is how Slide determines what uri's are > linked to each other ;o) > > As my links table is empty... what are the basics that need to go in there? > If I knew what '/actions' is linked to, I could do it myself! I presume > there is other stuff to go in there aswell tho... > > I am working through all the things that need to be added to the DB (so far > I have sorted stuff relating to /actions in both the objects and children > tables) and I am creating a patch SQL script, for anyone that experiences > the same problems (I have seen a couple of similar queries on the forum, but > no solutions). > > > > Many thanks > Stuart > > > > > -----Original Message----- > From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] > Sent: 14 August 2003 11:09 > To: [EMAIL PROTECTED] > Subject: Re: weird error on file PUT > > Hi Stuart, > > I just compiled 1.0.16 slide-stores.jar including XMLDescriptorsStore > and additionally necessary files. Maybe this gets it working. Maybe you > will need a up to date copy of JDOM, just try. > > Of course I can not guaranty for anything. If this does not work, don't > blame me ;) > > Oliver > > Stuart MacPherson wrote: > > >>Hi Oliver >> >>Do you think it would be possible to pull XMLDescriptorsStore.java out of >>the CVS, compile it, and then slot the class into the slide-stores.jar > > file? > >>I suppose that would just be a case of playing it by ear ;o) > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
