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
