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:47:59 GMT
On 10/23/06, Dietmar Gräbner <d.graebner@berlinger.cc> wrote:
> Annie Shao schrieb:
> > 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
> >
> >
>
> hi
>
> i am using the following configuration:
>
>  <PersistenceManager
> class="org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
>       <param name="driver" value="oracle.jdbc.driver.OracleDriver"/>
>       <param name="schema" value="oracle"/>
>             <param name="url" value="${crv.dburl}"/>
>             <param name="user" value="${crv.user}"/>
>             <param name="password" value="${crv.pass}"/>
>       <param name="schemaObjectPrefix" value="dms_"/>
>       <param name="externalBLOBs" value="false"/>
> </PersistenceManager>
>
>
> Try to add driver and schema param. The schema param refers to the ddl
> file used to create the tables - so this could be the reason.

that wouldn't help since OraclePersistenceManager already provides
defaults for those.

cheers
stefan

>
> best regards
>
> Dietmar
>

Mime
View raw message