public BasicDBList GetDBList(String tableName, BasicDBObject query) throws Exception { // BasicDBObject query = new BasicDBObject(); BasicDBObject emptyRecord = new BasicDBObject(); BasicDBList recordSet = new BasicDBList(); ; DBCursor cursorDoc = null; DBObject sortSpec = null; if ((sortSpec != null) && !sortSpec.keySet().isEmpty()) { // sorting is optional cursorDoc = store.getColl(tableName).find(query, emptyRecord).sort(sortSpec); } else if (query != null) { cursorDoc = store.getColl(tableName).find(query, emptyRecord); } else { cursorDoc = store.getColl(tableName).find(); } recordSet.clear(); int recordCount = 0; while (cursorDoc.hasNext()) { BasicDBObject rec = (BasicDBObject) cursorDoc.next(); recordSet.add(rec); recordCount++; } return recordSet; }