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
