The DDL is in .properties and .ddl files in the jackrabbit-core jar (look in packages ending in .db), but you're better off letting Jackrabbit run as a privileged user because it dynamically creates tables based on your configuration. We use Oracle and generally we have a non-privileged user that the application connects as. This turned out to be a giant pain in the a$$ with Jackrabbit. There are several namespace hurdles to overcome and even if you get everything working, Jackrabbit can't create tables for new workspaces and the like. I gave up and connect as the schema owner now. If anyone has had a different experience, I'd love to hear it.
On 2/12/09 4:03 PM, "Rogue" <[email protected]> wrote: Hi All, As part of my project development, I am trying to locate all the Jackrabbit DB scripts. Where can I find all the scripts, so that I don't have to ask for additional permissions for the JCR schema? Thanks, Rogue Please consider the environment before printing this e-mail.
