Hi,

I have a table with sorted duplicates. I would like to be able to
overwrite an existing record without having to first delete it and then
add it again. A plain:

db.put(null, key, value)

does nothing and complains that "Duplicate data items are not supported
with sorted data". Makes sense, but then I tried:

cursor = db.openCursor(null, null);
if (cursor.getSearchBoth(key, value, LockMode.DEFAULT) ==
OperationStatus.SUCCESS)
cursor.putCurrent(value);
else
db.put(null, key, value);

now there is no error, but the record does NOT get overwritten. Any
idea?

Thanks
Boris

Hi Boris,

Since this is a table with sorted duplicates your first case above is
expected since you are trying to append (db.put is append).

In the second case I would expect the db.put to complete successfully
since you are doing a put on the current record in the cursor set.
Since you are writing the same value, why do you think the write
operation did not complete?

Ron

You are right, it's actually because I'm writing the same value. But I
was trying to be clever: my secondary comparator works only on part of
the actual value. So I was initializing the byte buffer that I needed
to write, doing lookup (based only on a portion of it that is the same
in the old and new buffer) and then writing. However, 'getSearchBoth'
populates the 'value' DatabaseEntry with whatever is in the database,
which makes sense..

so, my bug, thanks a lot!