jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chirag.Jakha...@zycus.com
Subject Jackrabbit not working on Oracle
Date Thu, 28 Aug 2008 11:30:23 GMT
Below is the repository.xml

<?xml version="1.0"?>
        <!--
                Licensed to the Apache Software Foundation (ASF) under one 
or more
                contributor license agreements. See the NOTICE file 
distributed with
                this work for additional information regarding copyright 
ownership.
                The ASF licenses this file to You under the Apache 
License, Version
                2.0 (the "License"); you may not use this file except in 
compliance
                with the License. You may obtain a copy of the License at
                http://www.apache.org/licenses/LICENSE-2.0 Unless required 
by
                applicable law or agreed to in writing, software 
distributed under the
                License is distributed on an "AS IS" BASIS, WITHOUT 
WARRANTIES OR
                CONDITIONS OF ANY KIND, either express or implied. See the 
License for
                the specific language governing permissions and 
limitations under the
                License.
        -->
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD 
Jackrabbit 1.4//EN"
                            
"http://jackrabbit.apache.org/dtd/repository-1.4.dtd">
<!-- Example Repository Configuration File -->
<Repository>
        <!--
                virtual file system where the repository stores global 
state (e.g.
                registered namespaces, custom node types, etc.)
        -->
        <!--
                <FileSystem
 class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param
                name="path" value="${rep.home}/repository"/> </FileSystem>
        -->
        <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
                <param name="driver" value=
"oracle.jdbc.driver.OracleDriver" />
                <param name="url" value=
"jdbc:oracle:thin:@192.168.2.13:1521:ORCL2034" />
                <param name="user" value="GENESIS_QA" />
                <param name="password" value="GENESIS_QA" />
                <param name="schema" value="oracle" />
                <param name="schemaObjectPrefix" value="JCR_FS_" />
        </FileSystem>

    <!--
        security configuration
    -->
        <Security appName="Jackrabbit">
                <!--
                        access manager: class: FQN of class implementing 
the AccessManager
                        interface
                -->
                <AccessManager
                        class=
"org.apache.jackrabbit.core.security.SimpleAccessManager">
            <!-- <param name="config" value="${rep.home}/access.xml"/> -->
                </AccessManager>
                <LoginModule class=
"org.apache.jackrabbit.core.security.SimpleLoginModule">
           <!-- anonymous user name ('anonymous' is the default value) -->
           <!-- <param name="anonymousId" value="anonymous"/> -->
                        <!--
                                default user name to be used instead of 
the anonymous user when no
                                login credentials are provided (unset by 
default)
                        -->
           <!-- <param name="defaultUserId" value="superuser"/> -->
                </LoginModule>
        </Security>
        <!--
                location of workspaces root directory and name of default 
workspace
        -->
        <Workspaces rootPath="${rep.home}/workspaces"
                defaultWorkspace="default" />
        <!--
                workspace configuration template: used to create the 
initial workspace
                if there's no workspace yet
        -->
        <Workspace name="workName">
                <!--
                        virtual file system of the workspace: class: FQN 
of class
                        implementing the FileSystem interface
                -->
                <!--
                        <FileSystem
 class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param
                        name="path" value="${wsp.home}"/> </FileSystem>
                -->
                <FileSystem class=
"org.apache.jackrabbit.core.fs.db.DbFileSystem">
                        <param name="driver" value=
"oracle.jdbc.driver.OracleDriver" />
                        <param name="url" value=
"jdbc:oracle:thin:@192.168.2.13:1521:ORCL2034" />
                        <param name="user" value="GENESIS_QA" />
                        <param name="password" value="GENESIS_QA" />
                        <param name="schema" value="oracle" />
                        <param name="schemaObjectPrefix" value=
"JCR_FS_WORK_workName" />
                </FileSystem>
                <!--
                        persistence manager of the workspace: class: FQN 
of class
                        implementing the PersistenceManager interface
                -->
                <!--
                        <PersistenceManager
 
class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
                        <param name="url" 
value="jdbc:derby:${wsp.home}/db;create=true"/>
                        <param name="schemaObjectPrefix" 
value="workName_"/>
                        </PersistenceManager>
                -->
                <PersistenceManager
                        class=
"org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
                        <param name="driver" value=
"oracle.jdbc.driver.OracleDriver" />
                        <param name="url" value=
"jdbc:oracle:thin:@192.168.2.13:1521:ORCL2034" />
                        <param name="user" value="GENESIS_QA" />
                        <param name="password" value="GENESIS_QA" />
                        <param name="schema" value="oracle" />
                        <param name="schemaObjectPrefix" value=
"jcr_workName_" />
                        <param name="externalBLOBs" value="false" />
                </PersistenceManager>
                <!--
                        Search index and the file system it uses. class: 
FQN of class
                        implementing the QueryHandler interface
                -->
                <SearchIndex class=
"org.apache.jackrabbit.core.query.lucene.SearchIndex">
                        <param name="path" value="${wsp.home}/index" />
                        <param name="textFilterClasses"
                                value=
"org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.jackrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtractor,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.jackrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"

/>
                        <param name="extractorPoolSize" value="2" />
                        <param name="supportHighlighting" value="true" />
                </SearchIndex>
        </Workspace>

    <!--
        Configures the versioning
    -->
        <Versioning rootPath="${rep.home}/version">
                <FileSystem class=
"org.apache.jackrabbit.core.fs.db.DbFileSystem">
                        <param name="driver" value=
"oracle.jdbc.driver.OracleDriver" />
                        <param name="url" value=
"jdbc:oracle:thin:@192.168.2.13:1521:ORCL2034" />
                        <param name="user" value="GENESIS_QA" />
                        <param name="password" value="GENESIS_QA" />
                        <param name="schema" value="oracle" />
                        <param name="schemaObjectPrefix" value=
"JCR_FS_VERSION_" />
                </FileSystem>
                <PersistenceManager
                        class=
"org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
                        <param name="schema" value="oracle" />
                        <param name="driver" value=
"oracle.jdbc.driver.OracleDriver" />
                        <param name="url" value=
"jdbc:oracle:thin:@192.168.2.13:1521:ORCL2034" />
                        <param name="user" value="GENESIS_QA" />
                        <param name="password" value="GENESIS_QA" />
                        <param name="schemaObjectPrefix" value=
"jcr_version_workName_" />
                        <param name="externalBLOBs" value="false" />
                </PersistenceManager>
        </Versioning>

</Repository>




Below is the stacktrace that it throws

org.apache.jackrabbit.core.config.ConfigurationException: File system 
initialization failure.: failed to initialize file system: failed to 
initialize file system
        at 
org.apache.jackrabbit.core.config.FileSystemConfig.createFileSystem(
FileSystemConfig.java:54)
        at org.apache.jackrabbit.core.RepositoryImpl.<init>(
RepositoryImpl.java:243)
        at org.apache.jackrabbit.core.RepositoryImpl.create(
RepositoryImpl.java:550)
        at com.documentlibrary.jackrabbit.JackrabbitRepository.<init>(
JackrabbitRepository.java:53)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(
NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at com.documentlibrary.RepositoryFactory.createRepositorySource(
RepositoryFactory.java:17)
        at com.zycus.test.TestDocumentManagement.main(
TestDocumentManagement.java:11)
Caused by: org.apache.jackrabbit.core.fs.FileSystemException: failed to 
initialize file system
        at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(
DatabaseFileSystem.java:196)
        at 
org.apache.jackrabbit.core.config.FileSystemConfig.createFileSystem(
FileSystemConfig.java:47)
        ... 11 more
Caused by: java.sql.SQLException: Non supported SQL92 token at position: 
213: tableSpace
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134
)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179
)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
        at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:202)
        at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java:122)
        at oracle.jdbc.driver.OracleSql.parse(OracleSql.java:70)
        at oracle.jdbc.driver.OracleConnection.nativeSQL(
OracleConnection.java:1232)
        at oracle.jdbc.driver.OracleStatement.expandSqlEscapes(
OracleStatement.java:6689)
        at oracle.jdbc.driver.OracleStatement.parseSqlKind(
OracleStatement.java:6678)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:2814)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(
OracleStatement.java:875)
        at 
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.checkSchema(
DatabaseFileSystem.java:1169)
        at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(
DatabaseFileSystem.java:181)
        ... 12 more
org.apache.jackrabbit.core.fs.FileSystemException: failed to initialize 
file system
        at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(
DatabaseFileSystem.java:196)
        at 
org.apache.jackrabbit.core.config.FileSystemConfig.createFileSystem(
FileSystemConfig.java:47)
        at org.apache.jackrabbit.core.RepositoryImpl.<init>(
RepositoryImpl.java:243)
        at org.apache.jackrabbit.core.RepositoryImpl.create(
RepositoryImpl.java:550)
        at com.documentlibrary.jackrabbit.JackrabbitRepository.<init>(
JackrabbitRepository.java:53)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(
NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at com.documentlibrary.RepositoryFactory.createRepositorySource(
RepositoryFactory.java:17)
        at com.zycus.test.TestDocumentManagement.main(
TestDocumentManagement.java:11)
Caused by: java.sql.SQLException: Non supported SQL92 token at position: 
213: tableSpace
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134
)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179
)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
        at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:202)
        at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java:122)
        at oracle.jdbc.driver.OracleSql.parse(OracleSql.java:70)
        at oracle.jdbc.driver.OracleConnection.nativeSQL(
OracleConnection.java:1232)
        at oracle.jdbc.driver.OracleStatement.expandSqlEscapes(
OracleStatement.java:6689)
        at oracle.jdbc.driver.OracleStatement.parseSqlKind(
OracleStatement.java:6678)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:2814)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(
OracleStatement.java:875)
        at 
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.checkSchema(
DatabaseFileSystem.java:1169)
        at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(
DatabaseFileSystem.java:181)
        ... 12 more


Thanks in advance

CSJakharia
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message