Re: how to initiate jackrabbit in oracle?

[Marcin Nowak]

Thanks, repository works fine now, and what about storing data in oracle? is there a possibility to use oracle indexing rather than lucene's?

Stefan Guggisberg napisał(a):

hi marcin

that's your problem:

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

ojdbc14.jar and your can find it in your oracle server home directory.

cheers
stefan

On 1/26/07, Marcin Nowak <[EMAIL PROTECTED]> wrote:

you need to add the oracle jdbc driver to your class path. it's usually named

Hi,
I have a problem with setting up a repository in Oracle. I'm using
settings.xml as follows:

<?xml version="1.0" encoding="ISO-8859-1"?>
<Repository>
<FileSystem class =
"org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name = "path" value = "${rep.home}/repository"/>
</FileSystem>
<Security appName = "Jackrabbit">
<AccessManager class =

<LoginModule class =
"org.apache.jackrabbit.core.security.SimpleLoginModule"></LoginModule>
</Security>
<Workspaces rootPath = "${rep.home}/workspaces" defaultWorkspace =
"default"/>
<Workspace name = "${wsp.name}">
<FileSystem class =
"org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name = "path" value = "${wsp.home}"/>
</FileSystem>
<PersistenceManager class =
"org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
<param name = "url" value =
"jdbc:oracle:thin:@127.0.0.1:1521:mybase"/>
<param name = "user" value = "login"/>
<param name = "password" value = "password"/>
<param name = "schemaObjectPrefix" value = "${wsp.name}_"/>
<param name = "externalBLOBs" value = "false"/>
</PersistenceManager>
<SearchIndex class =
"org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name = "path" value = "${wsp.home}/index"/>
</SearchIndex>
</Workspace>
<Versioning rootPath = "${rep.home}/version">
<FileSystem class =
"org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name = "path" value = "${rep.home}/version"/>
</FileSystem>
<PersistenceManager class =
"org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
<param name = "url" value =
"jdbc:oracle:thin:@127.0.0.1:1521:mybase"/>
<param name = "user" value = "login"/>
<param name = "password" value = "password"/>
<param name = "schemaObjectPrefix" value = "version_"/>
<param name = "externalBLOBs" value = "false"/>
</PersistenceManager>
</Versioning>
<SearchIndex class =
"org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name = "path" value = "${rep.home}/repository/index"/>
</SearchIndex>
</Repository>

While I'm initializing the server I have this errors:

javax.jcr.RepositoryException: Cannot instantiate persistence manager
org.apache.jackrabbit.core.state.db.OraclePersistenceManager:
oracle.jdbc.OracleDriver: oracle.jdbc.OracleDriver
at


at


...
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
...
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)

BR,
Nowak Marcin

"org.apache.jackrabbit.core.security.SimpleAccessManager"></AccessManager> org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1184) org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:359)

smime.p7s
Description: S/MIME Cryptographic Signature