Open Source Document Management System | OpenKM

Hi All,

I am trying to work out how to connect to the default Derby(?) database. I see this in repository.xml:

<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager\">
<param name=\"url\" value=\"jdbc:derby:${wsp.home}/db;create=true\"/>
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\"/>
</PersistenceManager>

It seems that my database URL to connect with Derby might look like this:
jdbc:derby:${wsp.home}

How do I find the value of wsp.home?
Also, what username/password would be used by default?

Thanks for any advice,

Rob
:)

${wsp.home} is expanded to the workspace home. By default is located at $JBOSS_HOME/repository/workspaces/default. If you \"real\" database support, you should use MySQL, PostgreSQL, Oracle, etc.

OK, I worked out the URL:
jdbc:derby:C:/OpenKM-2.0b_JBoss-4.2.2.GA/repository/workspaces/default/db

But by default, what is the username/password to use for Derby access?

system/system didn\'t work.

Rob
:)

Hi All,

Anyone know what username/password the Derby db uses?

In repository.xml is located the repository definition. The tag <PersistenceManager> define all configuration params of any persistence manager. By default, we use DerbyPersistenceManager and there is no user/password additional parameters, so by default is null/null.