You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by ma...@9elements.com on 2010/01/18 11:44:25 UTC

oracle10g - datastore - can create, but can't read blob

Hello Users,

i got a problem with oracle10g that brings me near to despair.

My software is able to create nodes and store image files, but can't read them -
when using oracle10g (10.0.2.0.4).
It runs fine with the following dbs: h2, mysql, mssql, oracleXE

I am sure that my software previously runs with oracle10g also, but can't find
the difference.
Jackrabbit Version is 1.4 (tested 1.4.5 -> 1.4.11, sry can't upgrade), with
ojdbc14.jar (tested with ojdbc6.jar also).

Analysing the traffic between my software and the database brings up the
follwing:
SELECT LENGTH, LAST_MODIFIED FROM DATASTORE WHERE ID=:1 --> 'ORA-01403: no data
found'

When i write a simple java-jdbc program without jackrabbit, i am able to read
the blob. My db-user has DBA rights.

To store images i use the datastore <DataStore
class="org.apache.jackrabbit.core.data.db.DbDataStore">
with nothing special (just url, user, pass) configured (but tested also
minRecordLength and copyWhenReading).


Did any of you monitored a similar behavior with oracle 10g ? able to write, but
can't read ?
I assume that this maybe is more an oracle setting issue than a jackrabbit one -
but any hints would be appreciated.


best regards

derMark


Re: oracle10g - datastore - can create, but can't read blob

Posted by Thomas Müller <th...@day.com>.
Hi,

I guess it could be some kind of Oracle JDBC driver / blob problem,
but it's hard to tell. In this case, debugging Jackrabbit is probably
the easiest way to find out what the problem is.

> When i write a simple java-jdbc program without jackrabbit, i am able to read the blob.

Maybe your JDBC program uses another JDBC driver, or a slightly
different way to read the blob?

Regards,
Thomas