Reading Secondary Databases

Like a primary database, you can read records from your secondary database either by using the SecondaryDatabase.get() method, or by using a SecondaryCursor. The main difference between reading secondary and primary databases is that when you read a secondary database record, the secondary record's data is not returned to you. Instead, the primary key and data corresponding to the secondary key are returned to you.

For example, assuming your secondary database contains keys related to a person's full name:

import com.sleepycat.je.SecondaryDatabase;
import com.sleepycat.je.DatabaseEntry;
import com.sleepycat.je.OperationStatus;
import com.sleepycat.je.LockMode;

...
// Omitting all database and environment opens
...

try {
    String searchName = "Todd Fulmer";
    DatabaseEntry searchKey = 
        new DatabaseEntry(searchName.getBytes("UTF-8"));
    DatabaseEntry primaryKey = new DatabaseEntry();
    DatabaseEntry primaryData = new DatabaseEntry();

    // Get the primary key and data for the user 'Todd Fulmer'.
    OperationStatus retVal = mySecondaryDatabase.get(null, searchKey, 
                                                     primaryKey, 
                                                     primaryData, 
                                                     LockMode.DEFAULT); 
} catch (Exception e) {
    // Exception handling goes here
}

Note that, just like Database.get(), if your secondary database supports duplicate records then SecondaryDatabase.get() only returns the first record found in a matching duplicates set. If you want to see all the records related to a specific secondary key, then use a SecondaryCursor (described in Using Secondary Cursors ).