Re: Error when storing data with JackRabbit/Oracle

[Stefan Guggisberg]

hi sriram,

On 2/19/07, Sriram Narayanan <[EMAIL PROTECTED]> wrote:

Hi all:

I'm using JackRabbit 1.2.1 and the Oracle 14 JDBC driver.
My Persistence manger is the OracleDBPersistenceManager.

My Persistence section in the repository.xml

           <PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager">
                       <param name="driver" 
value="oracle.jdbc.driver.OracleDriver"/>
                       <param name="url" 
value="jdbc:oracle:thin:@dbserver:1521:testing"/>
                       <param name="schema" value="oracle"/>
                       <param name="user" value="scott"/>
                       <param name="password" value="tiger"/>
                       <param name="schemaObjectPrefix" value="${wsp.name}_"/>
                       <param name="externalBLOBs" value="false"/>
           </PersistenceManager>

After I write content to the database, I get the following content
using AquaDataStudioto to check "default_node":


 NODE_ID                               NODE_DATA
 ------------------------------------  ------------
 cafebabe-cafe-babe-cafe-babecafebabe  Err
 deadbeef-cafe-babe-cafe-babecafebabe  Err
 78b17301-13ec-4e6c-b100-80798a04b29f  Err
 cdbaa443-6d9f-4b7e-a7e7-8e609ffb1edb  Err
 a14e4770-fbc6-4613-9d6d-1bbc60d33f02  Err
 6abbb65d-121f-426f-b6e6-684ac1a0332b  Err
 6c03006e-4995-43f9-a910-b513c58041ba  Err
 8479d6cb-3348-4a09-8eac-82d9f3005865  Err

When I use Derby, I face no such problems.

What might be wrong here ?

i guess that there's nothing wrong at all ;-)
the application you're refering to is just unable to
display the binary column data (which is not that
surprising ;)

cheers
stefan

-- Sriram