Re: problems with Oracle

[Stefan Guggisberg]

On 10/23/06, Dietmar Gräbner <[EMAIL PROTECTED]> 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