mongodb - BasicBSONList 只能使用数字键，不能使用 : [_id]

Question

我正在尝试一次向 MongoDB 插入多条记录，因此为此我为要插入的每条记录创建了一个 javaBean，并将它们添加到 ArrayList 中。

最后从 ArrayList 中，我尝试执行如下所示的插入操作

public void insert(ArrayList<QuoteReportBean> quotelist) {
     BasicDBList totalrecords = new BasicDBList();
    StringBuffer sb = new StringBuffer();
    int valuecount=0;
     for (QuoteReportBean reportbean: quotelist) {
         valuecount++;
            BasicDBObject dbrecord = new BasicDBObject();
            dbrecord.append("cust_id", reportbean.getCustomerId());
            dbrecord.append("unique_symbol", reportbean.getUniqueSymbol());
            sb.append(reportbean.getUniqueSymbol()+",");
            dbrecord.append("exch", reportbean.getExchange());
            dbrecord.append("access_time", reportbean.getDate());
            totalrecords.add(dbrecord);
          }
     WriteResult result = coll.insert(totalrecords,WriteConcern.NORMAL);
}

但我是以下错误

Exception in thread "taskExecutor-1" java.lang.IllegalArgumentException: BasicBSONList can only work with numeric keys, not: [_id]
        at org.bson.types.BasicBSONList._getInt(BasicBSONList.java:159)
        at org.bson.types.BasicBSONList._getInt(BasicBSONList.java:150)
        at org.bson.types.BasicBSONList.get(BasicBSONList.java:104)
        at com.mongodb.DBCollection.apply(DBCollection.java:501)
        at com.mongodb.DBCollection.apply(DBCollection.java:491)
        at com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:195)
        at com.mongodb.DBApiLayer$MyCollection.insert(DBApiLayer.java:180)
        at com.mongodb.DBCollection.insert(DBCollection.java:58)

谁能帮我解决这个问题？？

Answer 1

BasicDBList 不能用于插入多个文档，它仅用于单个文档中的数组。要进行批量插入，您需要将一个 DBObject 数组传递给 insert 方法。

我更改了您的代码来执行此操作，并且它可以正常工作:

    StringBuffer sb = new StringBuffer();
    int valuecount = 0;
    final QuoteReportBean[] quotelist = {new QuoteReportBean()};
    DBObject[] totalrecords = new BasicDBObject[quotelist.length];
    for (int i = 0; i < quotelist.length; i++) {
        QuoteReportBean reportbean = quotelist[i];
        valuecount++;
        BasicDBObject dbrecord = new BasicDBObject();
        dbrecord.append("cust_id", reportbean.getCustomerId());
        dbrecord.append("unique_symbol", reportbean.getUniqueSymbol());
        sb.append(reportbean.getUniqueSymbol() + ",");
        dbrecord.append("exch", reportbean.getExchange());
        dbrecord.append("access_time", reportbean.getDate());
        totalrecords[i] = dbrecord;
    }
    WriteResult result = coll.insert(totalrecords, WriteConcern.NORMAL);