On 10/23/06, Guy Spillman <[EMAIL PROTECTED]> wrote:
I saw the same problem as well. The error as reported
from Log4J (full exception message listed below) is
"DatabaseFileSystem: 830 - failed to retrieve data of
file: /locks". It appears that the repository is not
shutting down properly. Within the
"$(WSP.NAME)_FSEntry" table, a row for
FSEntry_Name="locks" and FSEntry_Path="/" still exists
even after my application has been stopped. I have
tried to shutdown the repository using the
recommendation from the WIKI, but this makes no
difference. The quick (but probably dangerous)
workaround is to manually delete this row before
starting the repository. Can anyone help with a more
reassuring fix to this problem?
the locks file is meant to be there. it contains
information about existing JCR locks within
this workspace. better not delete it!
the repository lock file that prevents multiple
instantiation is a diferent story. it is cretaed in
the physical repository home directory.
cheers
stefan
Guy M. Spillman, Jr.
ERROR 10/23/06 11:54:57.518 DatabaseFileSystem:
830 - failed to retrieve data of file: /locks
java.sql.SQLException: ORA-22275: invalid LOB locator
specified
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at
oracle.jdbc.ttc7.v8TTILob.receiveReply(v8TTILob.java:993)
at
oracle.jdbc.ttc7.v8TTILob.getChunkSize(v8TTILob.java:347)
at
oracle.jdbc.ttc7.TTC7Protocol.getLobChunkSize(TTC7Protocol.java:3084)
at
oracle.sql.LobDBAccessImpl.getChunkSize(LobDBAccessImpl.java:334)
at oracle.sql.BLOB.getChunkSize(BLOB.java:484)
at oracle.sql.BLOB.getBufferSize(BLOB.java:521)
at
oracle.sql.BLOB.getBinaryStream(BLOB.java:256)
at
oracle.sql.BLOB.binaryStreamValue(BLOB.java:1171)
at
oracle.jdbc.driver.OracleStatement.getBinaryStreamValue(OracleStatement.java:5797)
at
oracle.jdbc.driver.OracleResultSetImpl.getBinaryStream(OracleResultSetImpl.java:746)
at
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.getInputStream(DatabaseFileSystem.java:816)
at
org.apache.jackrabbit.core.fs.FileSystemResource.getInputStream(FileSystemResource.java:147)
at
org.apache.jackrabbit.core.lock.LockManagerImpl.load(LockManagerImpl.java:145)
at
org.apache.jackrabbit.core.lock.LockManagerImpl.<init>(LockManagerImpl.java:123)
at
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.getLockManager(RepositoryImpl.java:1562)
at
org.apache.jackrabbit.core.RepositoryImpl.getLockManager(RepositoryImpl.java:772)
at
org.apache.jackrabbit.core.WorkspaceImpl.getLockManager(WorkspaceImpl.java:323)
at
org.apache.jackrabbit.core.XASessionImpl.getLockManager(XASessionImpl.java:169)
at
org.apache.jackrabbit.core.XASessionImpl.init(XASessionImpl.java:127)
at
org.apache.jackrabbit.core.XASessionImpl.<init>(XASessionImpl.java:100)
at
org.apache.jackrabbit.core.RepositoryImpl.createSessionInstance(RepositoryImpl.java:1277)
at
org.apache.jackrabbit.core.RepositoryImpl.createSession(RepositoryImpl.java:814)
at
org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1156)
at
org.apache.jackrabbit.core.jndi.BindableRepository.login(BindableRepository.java:155)
.
.
.
.
On Fri, 20 Oct 2006 15:30:32 -0700, Annie Shao wrote:
>
> Hi all:
>
> I am trying to integrate Oracle9i into our working JCR
> system. I am
> using the OracleFileSystem and the
> OraclePersistanceManger with the
> following settings in my respoitory.xml
>
> <FileSystem
>
class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
> <param name="url"
> value="jdbc:oracle:thin:@my.server:1521:MYSID"/>
> <param name="user" value="cleansed"/>
> <param name="password"
> value="cleansed"/>
> <param name="schemaObjectPrefix"
> value="rep_"/>
> </FileSystem>
>
> <PersistenceManager
>
class="org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
> <param name="url"
> value="jdbc:oracle:thin:@my.server:1521:MYSID"/>
> <param name="user" value="cleansed"/>
> <param name="password"
> value="cleansed"/>
> <param name="schemaObjectPrefix"
> value="${wsp.name}_"/>
> <param name="externalBLOBs"
> value="false"/>
> </PersistenceManager>
>
> I also have pretty much the same parameters for the
> version section, the
> only difference is the schemaObjecPrefix.
>
> I am using Oracle 9i, and ojdc14.jar for my oracle
> driver and jackrabbit
> 1.1.
>
> Initializing with this repository.xml, gets a few
> tables created
>
> DEFAULT_NODE
> DEFAULT_PROP
> DEFAULT_REFS
> DEFAULT_BINVAL
> VERSION_NODE
>
> TABLE_NAME
> ------------------------------
> VERSION_PROP
> VERSION_REFS
> VERSION_BINVAL
>
> But then I run into the following error:
>
> Caused by: java.sql.SQLException: ORA-22275: invalid
> LOB locator specified
>
> at
>
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
> at
>
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
> at
>
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
> at
>
oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:815)
> at
>
oracle.jdbc.driver.T4C8TTILob.getChunkSize(T4C8TTILob.java:292)
> at
>
oracle.jdbc.driver.T4CConnection.getChunkSize(T4CConnection.java:1551)
> at oracle.sql.BLOB.getChunkSize(BLOB.java:360)
> at
oracle.sql.BLOB.getBufferSize(BLOB.java:379)
> at
> oracle.sql.BLOB.getBinaryStream(BLOB.java:209)
> at
>
oracle.jdbc.driver.BlobAccessor.getBinaryStream(BlobAccessor.java:221)
> at
>
oracle.jdbc.driver.OracleResultSetImpl.getBinaryStream(OracleResultSetImpl.java:821)
> at
>
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.getInputStream(DatabaseFileSystem.java:816)
> ... 17 more
>
> Looking through oracle documentation doesn't give me
> very much help on
> this error. And I know other parts of our application
> uses BLOBS on the
> same database, although with a different user.
>
> Has anyone else seen this error before?
>
> -thanks
> Annie
