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]



Reply via email to