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.
best regards
Dietmar
