Using Secondary Cursors

Just like cursors on a primary database, you can use secondary cursors to iterate over the records in a secondary database. Like normal cursors, you can also use secondary cursors to search for specific records in a database, to seek to the first or last record in the database, to get the next duplicate record, to get the next non-duplicate record, and so forth. For a complete description on cursors and their capabilities, see Using Cursors.

However, when you use secondary cursors:

For example, suppose you are using the databases, classes, and key creators described in Implementing Key Creators. Then the following searches for a person's name in the secondary database, and deletes all secondary and primary records that use that name.

import com.sleepycat.je.SecondaryDatabase;
import com.sleepycat.je.SecondaryCursor;
import com.sleepycat.je.OperationStatus;
import com.sleepycat.je.LockMode;
  
...
// Database and environment opens omitted for brevity
...

try {
    String secondaryName = "Todd Fulmer";
    DatabaseEntry secondaryKey = 
        new DatabaseEntry(secondaryName.getBytes("UTF-8"));

    DatabaseEntry foundData = new DatabaseEntry();

    SecondaryCursor mySecCursor = 
        mySecondaryDatabase.openSecondaryCursor(null, null);

    OperationStatus retVal = mySecCursor.getSearchKey(secondaryKey, 
                                                  foundData, 
                                                  LockMode.DEFAULT);
    while (retVal == OperationStatus.SUCCESS) {
        mySecCursor.delete();
        retVal = mySecCursor.getNextDup(secondaryKey, 
                                        foundData, 
                                        LockMode.DEFAULT);
    } 
} catch (Exception e) {
    // Exception handling goes here
}