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