jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Guggisberg" <stefan.guggisb...@gmail.com>
Subject Re: problems with Oracle
Date Tue, 24 Oct 2006 13:44:35 GMT
On 10/23/06, Guy Spillman <gspillman@hal-inc.com> 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
>

Mime
View raw message