hi annie
On 10/21/06, Annie Shao <[EMAIL PROTECTED]> 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?
no, unfortunately not.
could you please provide a full stack trace?
i am especially interested in the part following
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.getInputStream(DatabaseFileSystem.java:816)
... 17 more
cheers
stefan
-thanks
Annie
