Examples of com.sleepycat.db.SecondaryCursor

com.sleepycat.db.SecondaryCursor
A database cursor for a secondary database. Cursors are not thread safe and the application is responsible for coordinating any multithreaded access to a single cursor object.
Secondary cursors are returned by {@link SecondaryDatabase#openCursor SecondaryDatabase.openCursor} and{@link SecondaryDatabase#openSecondaryCursor SecondaryDatabase.openSecondaryCursor}. The distinguishing characteristics of a secondary cursor are:
- Direct calls to put() methods on a secondary cursor are prohibited.
- The {@link #delete} method of a secondary cursor will delete the primaryrecord and as well as all its associated secondary records.
- Calls to all get methods will return the data from the associated primary database.
- Additional get method signatures are provided to return the primary key in an additional pKey parameter.
- Calls to {@link #dup} will return a {@link SecondaryCursor}.
- The {@link #dupSecondary} method is provided to return a {@link SecondaryCursor} that doesn't require casting.
To obtain a secondary cursor with default attributes:
```
 SecondaryCursor cursor = myDb.openSecondaryCursor(txn, null); 
```
To customize the attributes of a cursor, use a CursorConfig object.
```
 CursorConfig config = new CursorConfig(); config.setDirtyRead(true); SecondaryCursor cursor = myDb.openSecondaryCursor(txn, config); 
```

        }
    }


    private void showItem() throws DatabaseException {


        SecondaryCursor secCursor = null;
        try {
            // searchKey is the key that we want to find in the
            // secondary db.
            DatabaseEntry searchKey =
                new DatabaseEntry(locateItem.getBytes("UTF-8"));


            // foundKey and foundData are populated from the primary
            // entry that is associated with the secondary db key.
            DatabaseEntry foundKey = new DatabaseEntry();
            DatabaseEntry foundData = new DatabaseEntry();


            // open a secondary cursor
            secCursor =
                myDbs.getNameIndexDB().openSecondaryCursor(null, null);


            // Search for the secondary database entry.
            OperationStatus retVal =
                secCursor.getSearchKey(searchKey, foundKey,
                    foundData, LockMode.DEFAULT);


            // Display the entry, if one is found. Repeat until no more
            // secondary duplicate entries are found
            while(retVal == OperationStatus.SUCCESS) {
                Inventory theInventory =
                    (Inventory)inventoryBinding.entryToObject(foundData);
                displayInventoryRecord(foundKey, theInventory);
                retVal = secCursor.getNextDup(searchKey, foundKey,
                    foundData, LockMode.DEFAULT);
            }
        } catch (Exception e) {
            System.err.println("Error on inventory secondary cursor:");
            System.err.println(e.toString());
            e.printStackTrace();
        } finally {
            if (secCursor != null) {
                secCursor.close();
            }
        }
    }

View Full Code Here

            autoCommit = true;
        }


        boolean failed = true;
        OperationStatus status;
        SecondaryCursor cursor = db.openSecondaryCursor(txn, null);
        try {
            status = cursor.getSearchBoth
                (keyEntry, pkeyEntry, dataEntry,
                 locking ? LockMode.RMW : null);
            if (status == OperationStatus.SUCCESS) {
                status = cursor.delete();
            }
            failed = false;
        } finally {
            cursor.close();
            if (autoCommit) {
                if (failed) {
                    txn.abort();
                } else {
                    txn.commit();

View Full Code Here


        /*
         * Display all events, ordered by a secondary index on price.
         */
        System.out.println("\n-> Display all events, ordered by price");
        SecondaryCursor priceCursor =
            eventByPriceDb.openSecondaryCursor(null, null);
        try {
            printEvents(priceCursor);
        } finally {
            priceCursor.close();
        }
    }

View Full Code Here

TOP

Related Classes of com.sleepycat.db.SecondaryCursor

com.sleepycat.db.internal.Dbc

com.sleepycat.persist.SubIndex

db.GettingStarted.ExampleDatabaseRead

persist.EventExample

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.