예제 #1
0
  /** Test that null can be passed for the LockMode to all get methods. */
  public void testNullLockMode() throws DatabaseException {

    SecondaryDatabase secDb = initDb();
    Database priDb = secDb.getPrimaryDatabase();
    Transaction txn = txnBegin();

    DatabaseEntry key = entry(0);
    DatabaseEntry data = entry(0);
    DatabaseEntry secKey = entry(KEY_OFFSET);
    DatabaseEntry found = new DatabaseEntry();
    DatabaseEntry found2 = new DatabaseEntry();
    DatabaseEntry found3 = new DatabaseEntry();

    assertEquals(OperationStatus.SUCCESS, priDb.put(txn, key, data));
    assertEquals(OperationStatus.SUCCESS, priDb.put(txn, entry(1), data));
    assertEquals(OperationStatus.SUCCESS, priDb.put(txn, entry(2), entry(2)));

    /* Database operations. */

    assertEquals(OperationStatus.SUCCESS, priDb.get(txn, key, found, null));
    assertEquals(OperationStatus.SUCCESS, priDb.getSearchBoth(txn, key, data, null));
    assertEquals(OperationStatus.SUCCESS, secDb.get(txn, secKey, found, null));
    assertEquals(OperationStatus.SUCCESS, secDb.get(txn, secKey, found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secDb.getSearchBoth(txn, secKey, key, found, null));

    /* Cursor operations. */

    txnCommit(txn);
    txn = txnBeginCursor();
    Cursor cursor = priDb.openCursor(txn, null);
    SecondaryCursor secCursor = secDb.openSecondaryCursor(txn, null);

    assertEquals(OperationStatus.SUCCESS, cursor.getSearchKey(key, found, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getSearchBoth(key, data, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getSearchKeyRange(key, found, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getSearchBothRange(key, data, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getFirst(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getNext(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getPrev(found, found2, null));
    assertEquals(OperationStatus.NOTFOUND, cursor.getNextDup(found, found2, null));
    assertEquals(OperationStatus.NOTFOUND, cursor.getPrevDup(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getNextNoDup(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getPrevNoDup(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, cursor.getLast(found, found2, null));

    assertEquals(OperationStatus.SUCCESS, secCursor.getSearchKey(secKey, found, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getSearchKeyRange(secKey, found, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getFirst(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getNext(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getPrev(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getNextDup(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getPrevDup(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getNextNoDup(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getPrevNoDup(found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getLast(found, found2, null));

    assertEquals(OperationStatus.SUCCESS, secCursor.getSearchKey(secKey, found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getSearchBoth(secKey, data, found, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getSearchKeyRange(secKey, found, found2, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getSearchBothRange(secKey, data, found, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getFirst(found, found2, found3, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getNext(found, found2, found3, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getPrev(found, found2, found3, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getNextDup(found, found2, found3, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getPrevDup(found, found2, found3, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getNextNoDup(found, found2, found3, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getPrevNoDup(found, found2, found3, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getLast(found, found2, found3, null));

    secCursor.close();
    cursor.close();
    txnCommit(txn);
    secDb.close();
    priDb.close();
    env.close();
    env = null;
  }
예제 #2
0
  public void testGet() throws DatabaseException {

    SecondaryDatabase secDb = initDb();
    Database priDb = secDb.getPrimaryDatabase();

    DatabaseEntry data = new DatabaseEntry();
    DatabaseEntry key = new DatabaseEntry();
    DatabaseEntry secKey = new DatabaseEntry();
    OperationStatus status;
    Transaction txn = txnBegin();

    /*
     * For parameters that do not require initialization with a non-null
     * data array, we set them to null to make sure this works. [#12121]
     */

    /* Add one record for each key with one data/duplicate. */
    for (int i = 0; i < NUM_RECS; i += 1) {
      status = priDb.put(txn, entry(i), entry(i));
      assertSame(OperationStatus.SUCCESS, status);
    }

    /* SecondaryDatabase.get() */
    for (int i = 0; i < NUM_RECS; i += 1) {

      data.setData(null);
      status = secDb.get(txn, entry(i + KEY_OFFSET), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(i), key);
      assertDataEquals(entry(i), data);
    }
    data.setData(null);
    status = secDb.get(txn, entry(NUM_RECS + KEY_OFFSET), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.NOTFOUND, status);

    /* SecondaryDatabase.getSearchBoth() */
    for (int i = 0; i < NUM_RECS; i += 1) {
      data.setData(null);
      status = secDb.getSearchBoth(txn, entry(i + KEY_OFFSET), entry(i), data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(i), data);
    }
    data.setData(null);
    status =
        secDb.getSearchBoth(
            txn, entry(NUM_RECS + KEY_OFFSET), entry(NUM_RECS), data, LockMode.DEFAULT);
    assertSame(OperationStatus.NOTFOUND, status);

    /* Get a cursor txn. */
    txnCommit(txn);
    txn = txnBeginCursor();

    SecondaryCursor cursor = secDb.openSecondaryCursor(txn, null);
    try {
      /* SecondaryCursor.getFirst()/getNext() */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getFirst(secKey, key, data, LockMode.DEFAULT);
      for (int i = 0; i < NUM_RECS; i += 1) {
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getNext(secKey, key, data, LockMode.DEFAULT);
      }
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getCurrent() (last) */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getCurrent(secKey, key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(NUM_RECS - 1 + KEY_OFFSET), secKey);
      assertDataEquals(entry(NUM_RECS - 1), key);
      assertDataEquals(entry(NUM_RECS - 1), data);
      assertPriLocked(priDb, key);

      /* SecondaryCursor.getLast()/getPrev() */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getLast(secKey, key, data, LockMode.DEFAULT);
      for (int i = NUM_RECS - 1; i >= 0; i -= 1) {
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getPrev(secKey, key, data, LockMode.DEFAULT);
      }
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getCurrent() (first) */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getCurrent(secKey, key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(0 + KEY_OFFSET), secKey);
      assertDataEquals(entry(0), key);
      assertDataEquals(entry(0), data);
      assertPriLocked(priDb, key);

      /* SecondaryCursor.getSearchKey() */
      key.setData(null);
      data.setData(null);
      status = cursor.getSearchKey(entry(KEY_OFFSET - 1), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);
      for (int i = 0; i < NUM_RECS; i += 1) {
        key.setData(null);
        data.setData(null);
        status = cursor.getSearchKey(entry(i + KEY_OFFSET), key, data, LockMode.DEFAULT);
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key);
      }
      key.setData(null);
      data.setData(null);
      status = cursor.getSearchKey(entry(NUM_RECS + KEY_OFFSET), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getSearchBoth() */
      data.setData(null);
      status = cursor.getSearchKey(entry(KEY_OFFSET - 1), entry(0), data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);
      for (int i = 0; i < NUM_RECS; i += 1) {
        data.setData(null);
        status = cursor.getSearchBoth(entry(i + KEY_OFFSET), entry(i), data, LockMode.DEFAULT);
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, entry(i));
      }
      data.setData(null);
      status =
          cursor.getSearchBoth(
              entry(NUM_RECS + KEY_OFFSET), entry(NUM_RECS), data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getSearchKeyRange() */
      key.setData(null);
      data.setData(null);
      status = cursor.getSearchKeyRange(entry(KEY_OFFSET - 1), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(0), key);
      assertDataEquals(entry(0), data);
      assertPriLocked(priDb, key);
      for (int i = 0; i < NUM_RECS; i += 1) {
        key.setData(null);
        data.setData(null);
        status = cursor.getSearchKeyRange(entry(i + KEY_OFFSET), key, data, LockMode.DEFAULT);
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key);
      }
      key.setData(null);
      data.setData(null);
      status = cursor.getSearchKeyRange(entry(NUM_RECS + KEY_OFFSET), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getSearchBothRange() */
      data.setData(null);
      status = cursor.getSearchBothRange(entry(1 + KEY_OFFSET), entry(1), data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(1), data);
      assertPriLocked(priDb, entry(1));
      for (int i = 0; i < NUM_RECS; i += 1) {
        data.setData(null);
        status = cursor.getSearchBothRange(entry(i + KEY_OFFSET), entry(i), data, LockMode.DEFAULT);
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, entry(i));
      }
      data.setData(null);
      status =
          cursor.getSearchBothRange(
              entry(NUM_RECS + KEY_OFFSET), entry(NUM_RECS), data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);

      /* Add one duplicate for each key. */
      Cursor priCursor = priDb.openCursor(txn, null);
      try {
        for (int i = 0; i < NUM_RECS; i += 1) {
          status = priCursor.put(entry(i + KEY_OFFSET), entry(i));
          assertSame(OperationStatus.SUCCESS, status);
        }
      } finally {
        priCursor.close();
      }

      /* SecondaryCursor.getNextDup() */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getFirst(secKey, key, data, LockMode.DEFAULT);
      for (int i = 0; i < NUM_RECS; i += 1) {
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key, data);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getNextDup(secKey, key, data, LockMode.DEFAULT);
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i + KEY_OFFSET), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key, data);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getNextDup(secKey, key, data, LockMode.DEFAULT);
        assertSame(OperationStatus.NOTFOUND, status);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getNext(secKey, key, data, LockMode.DEFAULT);
      }
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getNextNoDup() */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getFirst(secKey, key, data, LockMode.DEFAULT);
      for (int i = 0; i < NUM_RECS; i += 1) {
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key, data);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getNextNoDup(secKey, key, data, LockMode.DEFAULT);
      }
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getPrevDup() */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getLast(secKey, key, data, LockMode.DEFAULT);
      for (int i = NUM_RECS - 1; i >= 0; i -= 1) {
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i + KEY_OFFSET), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key, data);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getPrevDup(secKey, key, data, LockMode.DEFAULT);
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key, data);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getPrevDup(secKey, key, data, LockMode.DEFAULT);
        assertSame(OperationStatus.NOTFOUND, status);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getPrev(secKey, key, data, LockMode.DEFAULT);
      }
      assertSame(OperationStatus.NOTFOUND, status);

      /* SecondaryCursor.getPrevNoDup() */
      secKey.setData(null);
      key.setData(null);
      data.setData(null);
      status = cursor.getLast(secKey, key, data, LockMode.DEFAULT);
      for (int i = NUM_RECS - 1; i >= 0; i -= 1) {
        assertSame(OperationStatus.SUCCESS, status);
        assertDataEquals(entry(i + KEY_OFFSET), secKey);
        assertDataEquals(entry(i + KEY_OFFSET), key);
        assertDataEquals(entry(i), data);
        assertPriLocked(priDb, key, data);
        secKey.setData(null);
        key.setData(null);
        data.setData(null);
        status = cursor.getPrevNoDup(secKey, key, data, LockMode.DEFAULT);
      }
      assertSame(OperationStatus.NOTFOUND, status);
    } finally {
      cursor.close();
    }

    txnCommit(txn);
    secDb.close();
    priDb.close();
  }
예제 #3
0
  public void testPutAndDelete() throws DatabaseException {

    SecondaryDatabase secDb = initDb();
    Database priDb = secDb.getPrimaryDatabase();

    DatabaseEntry data = new DatabaseEntry();
    DatabaseEntry key = new DatabaseEntry();
    OperationStatus status;
    Transaction txn = txnBegin();

    /* Database.put() */
    status = priDb.put(txn, entry(1), entry(2));
    assertSame(OperationStatus.SUCCESS, status);
    status = secDb.get(txn, entry(102), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.SUCCESS, status);
    assertDataEquals(entry(1), key);
    assertDataEquals(entry(2), data);

    /* Database.putNoOverwrite() */
    status = priDb.putNoOverwrite(txn, entry(1), entry(1));
    assertSame(OperationStatus.KEYEXIST, status);
    status = secDb.get(txn, entry(102), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.SUCCESS, status);
    assertDataEquals(entry(1), key);
    assertDataEquals(entry(2), data);

    /* Database.put() overwrite */
    status = priDb.put(txn, entry(1), entry(3));
    assertSame(OperationStatus.SUCCESS, status);
    status = secDb.get(txn, entry(102), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.NOTFOUND, status);
    status = secDb.get(txn, entry(103), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.SUCCESS, status);
    assertDataEquals(entry(1), key);
    assertDataEquals(entry(3), data);

    /* Database.delete() */
    status = priDb.delete(txn, entry(1));
    assertSame(OperationStatus.SUCCESS, status);
    status = priDb.delete(txn, entry(1));
    assertSame(OperationStatus.NOTFOUND, status);
    status = secDb.get(txn, entry(103), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.NOTFOUND, status);

    /* SecondaryDatabase.delete() */
    status = priDb.put(txn, entry(1), entry(1));
    assertSame(OperationStatus.SUCCESS, status);
    status = priDb.put(txn, entry(2), entry(1));
    assertSame(OperationStatus.SUCCESS, status);
    status = secDb.get(txn, entry(101), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.SUCCESS, status);
    assertDataEquals(entry(1), key);
    assertDataEquals(entry(1), data);
    status = secDb.delete(txn, entry(101));
    assertSame(OperationStatus.SUCCESS, status);
    status = secDb.delete(txn, entry(101));
    assertSame(OperationStatus.NOTFOUND, status);
    status = secDb.get(txn, entry(101), key, data, LockMode.DEFAULT);
    assertSame(OperationStatus.NOTFOUND, status);
    status = priDb.get(txn, entry(1), data, LockMode.DEFAULT);
    assertSame(OperationStatus.NOTFOUND, status);
    status = priDb.get(txn, entry(2), data, LockMode.DEFAULT);
    assertSame(OperationStatus.NOTFOUND, status);

    /*
     * Database.putNoDupData() cannot be called since the primary cannot be
     * configured for duplicates.
     */

    /* Primary and secondary are empty now. */

    /* Get a txn for a cursor. */
    txnCommit(txn);
    txn = txnBeginCursor();

    Cursor priCursor = null;
    SecondaryCursor secCursor = null;
    try {
      priCursor = priDb.openCursor(txn, null);
      secCursor = secDb.openSecondaryCursor(txn, null);

      /* Cursor.putNoOverwrite() */
      status = priCursor.putNoOverwrite(entry(1), entry(2));
      assertSame(OperationStatus.SUCCESS, status);
      status = secCursor.getSearchKey(entry(102), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(1), key);
      assertDataEquals(entry(2), data);

      /* Cursor.putCurrent() */
      status = priCursor.putCurrent(entry(3));
      assertSame(OperationStatus.SUCCESS, status);
      status = secCursor.getSearchKey(entry(102), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);
      status = secCursor.getSearchKey(entry(103), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(1), key);
      assertDataEquals(entry(3), data);

      /* Cursor.delete() */
      status = priCursor.delete();
      assertSame(OperationStatus.SUCCESS, status);
      status = priCursor.delete();
      assertSame(OperationStatus.KEYEMPTY, status);
      status = secCursor.getSearchKey(entry(103), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);
      status = priCursor.getSearchKey(entry(1), data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);

      /* Cursor.put() */
      status = priCursor.put(entry(1), entry(4));
      assertSame(OperationStatus.SUCCESS, status);
      status = secCursor.getSearchKey(entry(104), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.SUCCESS, status);
      assertDataEquals(entry(1), key);
      assertDataEquals(entry(4), data);

      /* SecondaryCursor.delete() */
      status = secCursor.delete();
      assertSame(OperationStatus.SUCCESS, status);
      status = secCursor.delete();
      assertSame(OperationStatus.KEYEMPTY, status);
      status = secCursor.getCurrent(new DatabaseEntry(), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.KEYEMPTY, status);
      status = secCursor.getSearchKey(entry(104), key, data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);
      status = priCursor.getSearchKey(entry(1), data, LockMode.DEFAULT);
      assertSame(OperationStatus.NOTFOUND, status);

      /*
       * Cursor.putNoDupData() cannot be called since the primary cannot
       * be configured for duplicates.
       */

      /* Primary and secondary are empty now. */
    } finally {
      if (secCursor != null) {
        secCursor.close();
      }
      if (priCursor != null) {
        priCursor.close();
      }
    }

    txnCommit(txn);
    secDb.close();
    priDb.close();
  }
예제 #4
0
  /**
   * Test that an exception is thrown when a cursor is used in the wrong state. No put or get is
   * allowed in the closed state, and certain gets and puts are not allowed in the uninitialized
   * state.
   */
  public void testCursorState() throws DatabaseException {

    SecondaryDatabase secDb = initDb();
    Database priDb = secDb.getPrimaryDatabase();
    Transaction txn = txnBegin();

    DatabaseEntry key = entry(0);
    DatabaseEntry data = entry(0);
    DatabaseEntry secKey = entry(KEY_OFFSET);
    DatabaseEntry found = new DatabaseEntry();
    DatabaseEntry found2 = new DatabaseEntry();

    assertEquals(OperationStatus.SUCCESS, priDb.put(txn, key, data));

    txnCommit(txn);
    txn = txnBeginCursor();
    Cursor cursor = priDb.openCursor(txn, null);
    SecondaryCursor secCursor = secDb.openSecondaryCursor(txn, null);

    /* Check the uninitialized state for certain operations. */

    try {
      cursor.count();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.delete();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.putCurrent(data);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getCurrent(key, data, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getNextDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getPrevDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }

    try {
      secCursor.count();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.delete();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getCurrent(key, data, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getNextDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getPrevDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }

    /* Initialize, then close, then check all operations. */

    assertEquals(OperationStatus.SUCCESS, cursor.getSearchKey(key, found, null));
    assertEquals(OperationStatus.SUCCESS, secCursor.getSearchKey(secKey, found, null));
    secCursor.close();
    cursor.close();

    try {
      cursor.close();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.count();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.delete();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.put(key, data);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.putNoOverwrite(key, data);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.putNoDupData(key, data);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.putCurrent(data);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getCurrent(key, data, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getSearchKey(key, found, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getSearchBoth(key, data, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getSearchKeyRange(key, found, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getSearchBothRange(key, data, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getFirst(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getNext(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getPrev(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getNextDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getPrevDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getNextNoDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getPrevNoDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      cursor.getLast(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }

    try {
      secCursor.close();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.count();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.delete();
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getCurrent(key, data, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getSearchKey(secKey, found, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getSearchKeyRange(secKey, found, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getFirst(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getNext(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getPrev(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getNextDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getPrevDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getNextNoDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getPrevNoDup(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }
    try {
      secCursor.getLast(found, found2, null);
      fail();
    } catch (DatabaseException expected) {
    }

    txnCommit(txn);
    secDb.close();
    priDb.close();
    env.close();
    env = null;
  }