Class DBCursor
- All Implemented Interfaces:
Cursor
,Closeable
,AutoCloseable
,Iterable<DBObject>
,Iterator<DBObject>
An iterator over database results. Doing a find()
query on a collection returns a DBCursor
.
An application should ensure that a cursor is closed in all circumstances, e.g. using a try-with-resources statement:
try (DBCursor cursor = collection.find(query)) { while (cursor.hasNext()) { System.out.println(cursor.next(); } }
Warning: Calling toArray
or length
on a DBCursor will irrevocably turn it into an array. This means that, if
the cursor was iterating over ten million results (which it was lazily fetching from the database), suddenly there will be a ten-million
element array in memory. Before converting to an array, make sure that there are a reasonable number of results using skip()
and
limit()
.
For example, to get an array of the 1000-1100th elements of a cursor, use
List<DBObject> obj = collection.find(query).skip(1000).limit(100).toArray();
See Mongo.getDB(String)
for further information about the effective deprecation of this class.-
Constructor Summary
ConstructorsConstructorDescriptionDBCursor
(DBCollection collection, DBObject query, DBObject fields, ReadPreference readPreference) Deprecated.Initializes a new database cursor.DBCursor
(DBCollection collection, DBObject query, DBObject fields, ReadPreference readPreference, boolean retryReads) Deprecated.Initializes a new database cursor. -
Method Summary
Modifier and TypeMethodDescriptionaddOption
(int option) Deprecated.Prefer per-option methods, e.g.addSpecial
(String name, Object value) Deprecated.Prefer per-operator methods, e.g.batchSize
(int numberOfElements) Deprecated.Limits the number of elements returned in one batch.void
close()
Deprecated.Terminates this cursor on the server.Deprecated.Adds a comment to the query to identify queries in the database profiler output.copy()
Deprecated.Creates a copy of an existing database cursor.int
count()
Deprecated.Counts the number of objects matching the query.curr()
Deprecated.Returns the element the cursor is at.cursorType
(CursorType cursorType) Deprecated.Sets the cursor type.explain()
Deprecated.Replace with direct use of the explain command using the runCommand helper methodint
Deprecated.Gets the batch size.Deprecated.Returns the collation optionsDeprecated.Gets the collection.long
Deprecated.Gets the server's identifier for this Cursor.Deprecated.Gets the decoder factory that creates the decoder this cursor will use to decode objects from MongoDB.Deprecated.Gets the fields to be returned.int
getLimit()
Deprecated.Gets the query limit.int
Deprecated.getQuery()
Deprecated.Gets the query.Deprecated.Gets the default read preference.Deprecated.Gets the address of the server that data is pulled from.boolean
hasNext()
Deprecated.Checks if there is another object available.Deprecated.Informs the database of indexed fields of the collection in order to improve performance.Deprecated.Preferhint(DBObject)
int
itcount()
Deprecated.For testing only! Iterates cursor and counts objectsiterator()
Deprecated.Creates a copy of this cursor object that can be iterated.int
length()
Deprecated.Pulls back all items into an array and returns the number of objects.limit
(int limit) Deprecated.Limits the number of elements returned.Deprecated.Specifies an exclusive upper limit for the index to use in a query.maxScan
(int max) Deprecated.Deprecated as of MongoDB 4.0 releaseDeprecated.Set the maximum execution time for operations on this cursor.Deprecated.Specifies an inclusive lower limit for the index to use in a query.next()
Deprecated.Returns the object the cursor is at and moves the cursor ahead by one.noCursorTimeout
(boolean noCursorTimeout) Deprecated.The server normally times out idle cursors after an inactivity period (10 minutes) to prevent excess memory use.int
numSeen()
Deprecated.Returns the number of objects through which the cursor has iterated.one()
Deprecated.Returns the first document that matches the query.oplogReplay
(boolean oplogReplay) Deprecated.Users should not set this under normal circumstances.partial
(boolean partial) Deprecated.Get partial results from a sharded cluster if one or more shards are unreachable (instead of throwing an error).void
remove()
Deprecated.Deprecated.Deprecated.Forces the cursor to only return fields included in the index.setCollation
(Collation collation) Deprecated.Sets the collation optionssetDecoderFactory
(DBDecoderFactory factory) Deprecated.Sets the factory that will be used create aDBDecoder
that will be used to decode BSON documents into DBObject instances.setOptions
(int options) Deprecated.setReadPreference
(ReadPreference readPreference) Deprecated.Sets the read preference for this cursor.Deprecated.showDiskLoc has been deprecated in the MongoDB server.int
size()
Deprecated.Counts the number of objects matching the query this does take limit/skip into considerationskip
(int numberOfElements) Deprecated.Discards a given number of elements at the beginning of the cursor.slaveOk()
Deprecated.Replaced withReadPreference.secondaryPreferred()
snapshot()
Deprecated.Deprecated in MongoDB 3.6 release and removed in MongoDB 4.0 releaseDeprecated.Sorts this cursor's elements.toArray()
Deprecated.Converts this cursor to an array.toArray
(int max) Deprecated.Converts this cursor to an array.toString()
Deprecated.tryNext()
Deprecated.Non blocking check for tailable cursors to see if another object is available.Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface java.lang.Iterable
forEach, spliterator
Methods inherited from interface java.util.Iterator
forEachRemaining
-
Constructor Details
-
DBCursor
public DBCursor(DBCollection collection, DBObject query, @Nullable DBObject fields, @Nullable ReadPreference readPreference) Deprecated.Initializes a new database cursor.- Parameters:
collection
- collection to usequery
- the query filter to applyfields
- keys to return from the queryreadPreference
- the read preference for this query
-
DBCursor
public DBCursor(DBCollection collection, DBObject query, @Nullable DBObject fields, @Nullable ReadPreference readPreference, boolean retryReads) Deprecated.Initializes a new database cursor.- Parameters:
collection
- collection to usequery
- the query filter to applyfields
- keys to return from the queryreadPreference
- the read preference for this queryretryReads
- true if reads should be retried
-
-
Method Details
-
copy
Deprecated.Creates a copy of an existing database cursor. The new cursor is an iterator, even if the original was an array.- Returns:
- the new cursor
-
hasNext
public boolean hasNext()Deprecated.Checks if there is another object available.Note: Automatically adds the
Bytes.QUERYOPTION_AWAITDATA
option to any cursors with theBytes.QUERYOPTION_TAILABLE
option set. For non blocking tailable cursors seetryNext()
. -
next
Deprecated.Returns the object the cursor is at and moves the cursor ahead by one.Note: Automatically adds the
Bytes.QUERYOPTION_AWAITDATA
option to any cursors with theBytes.QUERYOPTION_TAILABLE
option set. For non blocking tailable cursors seetryNext()
. -
tryNext
Deprecated.Non blocking check for tailable cursors to see if another object is available.Returns the object the cursor is at and moves the cursor ahead by one or return null if no documents is available.
- Returns:
- the next element or null
- Throws:
MongoException
- if failedIllegalArgumentException
- if the cursor is not tailable
-
curr
Deprecated.Returns the element the cursor is at.- Returns:
- the current element
-
remove
public void remove()Deprecated. -
addOption
Deprecated.Prefer per-option methods, e.g.cursorType(CursorType)
,noCursorTimeout(boolean)
, etc.Adds a query option. See Bytes.QUERYOPTION_* for list.- Parameters:
option
- the option to be added- Returns:
this
so calls can be chained- See Also:
-
setOptions
Deprecated.Sets the query option - see Bytes.QUERYOPTION_* for list.- Parameters:
options
- the bitmask of options- Returns:
this
so calls can be chained- See Also:
-
resetOptions
Deprecated.Resets the query options.- Returns:
this
so calls can be chained
-
getOptions
Deprecated.Gets the query options.- Returns:
- the bitmask of options
-
getLimit
public int getLimit()Deprecated.Gets the query limit.- Returns:
- the limit, or 0 if no limit is set
-
getBatchSize
public int getBatchSize()Deprecated.Gets the batch size.- Returns:
- the batch size
-
addSpecial
Deprecated.Prefer per-operator methods, e.g.comment(String)
,explain()
, etc.Adds a special operator like $comment or $returnKey. For example:addSpecial("$returnKey", 1) addSpecial("$comment", "this is a special query)
- Parameters:
name
- the name of the special query operatorvalue
- the value of the special query operator- Returns:
this
so calls can be chained
-
comment
Deprecated.Adds a comment to the query to identify queries in the database profiler output.- Parameters:
comment
- the comment that is to appear in the profiler output- Returns:
this
so calls can be chained- Since:
- 2.12
-
maxScan
Deprecated.Deprecated as of MongoDB 4.0 releaseLimits the number of documents a cursor will return for a query.- Parameters:
max
- the maximum number of documents to return- Returns:
this
so calls can be chained- Since:
- 2.12
- See Also:
-
max
Deprecated.Specifies an exclusive upper limit for the index to use in a query.- Parameters:
max
- a document specifying the fields, and the upper bound values for those fields- Returns:
this
so calls can be chained- Since:
- 2.12
-
min
Deprecated.Specifies an inclusive lower limit for the index to use in a query.- Parameters:
min
- a document specifying the fields, and the lower bound values for those fields- Returns:
this
so calls can be chained- Since:
- 2.12
-
returnKey
Deprecated.Forces the cursor to only return fields included in the index.- Returns:
this
so calls can be chained- Since:
- 2.12
-
showDiskLoc
Deprecated.showDiskLoc has been deprecated in the MongoDB server. There is no replacement for it.Modifies the documents returned to include references to the on-disk location of each document. The location will be returned in a property named$diskLoc
- Returns:
this
so calls can be chained- Since:
- 2.12
-
hint
Deprecated.Informs the database of indexed fields of the collection in order to improve performance.- Parameters:
indexKeys
- aDBObject
with fields and direction- Returns:
- same DBCursor for chaining operations
-
hint
Deprecated.Preferhint(DBObject)
Informs the database of an indexed field of the collection in order to improve performance.- Parameters:
indexName
- the name of an index- Returns:
- same DBCursor for chaining operations
-
maxTime
Deprecated.Set the maximum execution time for operations on this cursor.- Parameters:
maxTime
- the maximum time that the server will allow the query to run, before killing the operation. A non-zero value requires a server version >= 2.6timeUnit
- the time unit- Returns:
- same DBCursor for chaining operations
- Since:
- 2.12.0
-
snapshot
Deprecated.Deprecated in MongoDB 3.6 release and removed in MongoDB 4.0 releaseUse snapshot mode for the query. Snapshot mode prevents the cursor from returning a document more than once because an intervening write operation results in a move of the document. Even in snapshot mode, documents inserted or deleted during the lifetime of the cursor may or may not be returned. Currently, snapshot mode may not be used with sorting or explicit hints.- Returns:
this
so calls can be chained- See Also:
-
explain
Deprecated.Replace with direct use of the explain command using the runCommand helper methodReturns an object containing basic information about the execution of the query that created this cursor. This creates aDBObject
with a number of fields, including but not limited to:- cursor: cursor type
- nScanned: number of records examined by the database for this query
- n: the number of records that the database returned
- millis: how long it took the database to execute the query
- Returns:
- a
DBObject
containing the explain output for this DBCursor's query - Throws:
MongoException
- if the operation failed
-
cursorType
Deprecated.Sets the cursor type.- Parameters:
cursorType
- the cursor type, which may not be null- Returns:
- this
- Since:
- 3.9
-
oplogReplay
Deprecated.Users should not set this under normal circumstances.- Parameters:
oplogReplay
- if oplog replay is enabled- Returns:
- this
- Since:
- 3.9
-
noCursorTimeout
Deprecated.The server normally times out idle cursors after an inactivity period (10 minutes) to prevent excess memory use. Set this option to prevent that.- Parameters:
noCursorTimeout
- true if cursor timeout is disabled- Returns:
- this
- Since:
- 3.9
-
partial
Deprecated.Get partial results from a sharded cluster if one or more shards are unreachable (instead of throwing an error).- Parameters:
partial
- if partial results for sharded clusters is enabled- Returns:
- this
- Since:
- 3.9
-
sort
Deprecated.Sorts this cursor's elements. This method must be called before getting any object from the cursor.- Parameters:
orderBy
- the fields by which to sort- Returns:
- a cursor pointing to the first element of the sorted results
-
limit
Deprecated.Limits the number of elements returned. Note: parameterlimit
should be positive, although a negative value is supported for legacy reason. Passing a negative value will callbatchSize(int)
which is the preferred method.- Parameters:
limit
- the number of elements to return- Returns:
- a cursor to iterate the results
-
batchSize
Deprecated.Limits the number of elements returned in one batch. A cursor typically fetches a batch of result objects and store them locally.
If
batchSize
is positive, it represents the size of each batch of objects retrieved. It can be adjusted to optimize performance and limit data transfer.If
batchSize
is negative, it will limit of number objects returned, that fit within the max batch size limit (usually 4MB), and cursor will be closed. For example ifbatchSize
is -10, then the server will return a maximum of 10 documents and as many as can fit in 4MB, then close the cursor. Note that this feature is different from limit() in that documents must fit within a maximum size, and it removes the need to send a request to close the cursor server-side.- Parameters:
numberOfElements
- the number of elements to return in a batch- Returns:
this
so calls can be chained
-
skip
Deprecated.Discards a given number of elements at the beginning of the cursor.- Parameters:
numberOfElements
- the number of elements to skip- Returns:
- a cursor pointing to the new first element of the results
- Throws:
IllegalStateException
- if the cursor has started to be iterated through
-
getCursorId
public long getCursorId()Deprecated.Description copied from interface:Cursor
Gets the server's identifier for this Cursor.- Specified by:
getCursorId
in interfaceCursor
- Returns:
- the cursor's ID, or 0 if there is no active cursor.
-
numSeen
public int numSeen()Deprecated.Returns the number of objects through which the cursor has iterated.- Returns:
- the number of objects seen
-
close
public void close()Deprecated.Description copied from interface:Cursor
Terminates this cursor on the server. -
slaveOk
Deprecated.Replaced withReadPreference.secondaryPreferred()
Declare that this query can run on a secondary server.- Returns:
- a copy of the same cursor (for chaining)
- See Also:
-
iterator
Deprecated.Creates a copy of this cursor object that can be iterated. Note: - you can iterate the DBCursor itself without calling this method - no actual data is getting copied.
Note that use of this method does not let you call close the underlying cursor in the case of either an exception or an early break. The preferred method of iteration is to use DBCursor as an Iterator, so that you can call close() on it in a finally block.
-
toArray
Deprecated.Converts this cursor to an array.- Returns:
- an array of elements
- Throws:
MongoException
- if failed
-
toArray
Deprecated.Converts this cursor to an array.- Parameters:
max
- the maximum number of objects to return- Returns:
- an array of objects
- Throws:
MongoException
- if failed
-
count
public int count()Deprecated.Counts the number of objects matching the query. This does not take limit/skip into consideration, and does initiate a call to the server.- Returns:
- the number of objects
- Throws:
MongoException
- if the operation failed- See Also:
-
one
Deprecated.Returns the first document that matches the query.- Returns:
- the first matching document
- Since:
- 2.12
-
length
public int length()Deprecated.Pulls back all items into an array and returns the number of objects. Note: this can be resource intensive.- Returns:
- the number of elements in the array
- Throws:
MongoException
- if failed- See Also:
-
itcount
public int itcount()Deprecated.For testing only! Iterates cursor and counts objects- Returns:
- num objects
- Throws:
MongoException
- if failed- See Also:
-
size
public int size()Deprecated.Counts the number of objects matching the query this does take limit/skip into consideration- Returns:
- the number of objects
- Throws:
MongoException
- if the operation failed- See Also:
-
getKeysWanted
Deprecated.Gets the fields to be returned.- Returns:
- the field selector that cursor used
-
getQuery
Deprecated.Gets the query.- Returns:
- the query that cursor used
-
getCollection
Deprecated.Gets the collection.- Returns:
- the collection that data is pulled from
-
getServerAddress
Deprecated.Description copied from interface:Cursor
Gets the address of the server that data is pulled from. Note that this information may not be available until hasNext() or next() is called.- Specified by:
getServerAddress
in interfaceCursor
- Returns:
- the address of the server that data is pulled from
-
setReadPreference
Deprecated.Sets the read preference for this cursor. See the documentation forReadPreference
for more information.- Parameters:
readPreference
- read preference to use- Returns:
this
so calls can be chained
-
getReadPreference
Deprecated.Gets the default read preference.- Returns:
- the readPreference used by this cursor
-
getCollation
Deprecated.Returns the collation options- Returns:
- the collation options
- Since:
- 3.4
-
setCollation
Deprecated.Sets the collation optionsA null value represents the server default.
- Parameters:
collation
- the collation options to use- Returns:
- this
- Since:
- 3.4
-
setDecoderFactory
Deprecated.Sets the factory that will be used create aDBDecoder
that will be used to decode BSON documents into DBObject instances.- Parameters:
factory
- the DBDecoderFactory- Returns:
this
so calls can be chained
-
getDecoderFactory
Deprecated.Gets the decoder factory that creates the decoder this cursor will use to decode objects from MongoDB.- Returns:
- the decoder factory.
-
toString
Deprecated.
-