解决MONGO插入时候 INVALID BSON FIELD 问题

1. java操作mongo提示Invalid BSON field name W3.DCS6.60RCAOG_D001_01

xception in thread "main" java.lang.IllegalArgumentException: Invalid BSON field name W3.DCS6.60RCAOG_D001_01
	at org.bson.AbstractBsonWriter.writeName(AbstractBsonWriter.java:534)
	at com.mongodb.internal.connection.BsonWriterDecorator.writeName(BsonWriterDecorator.java:193)
	at com.mongodb.internal.connection.IdHoldingBsonWriter.writeName(IdHoldingBsonWriter.java:302)
	at org.bson.codecs.DocumentCodec.writeMap(DocumentCodec.java:211)
	at org.bson.codecs.DocumentCodec.encode(DocumentCodec.java:154)
	at org.bson.codecs.DocumentCodec.encode(DocumentCodec.java:45)
	at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:63)
	at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:29)
	at com.mongodb.internal.connection.SplittablePayload$WriteRequestEncoder.encode(SplittablePayload.java:200)
	at com.mongodb.internal.connection.SplittablePayload$WriteRequestEncoder.encode(SplittablePayload.java:187)
	at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:63)
	at org.bson.codecs.BsonDocumentWrapperCodec.encode(BsonDocumentWrapperCodec.java:29)
	at com.mongodb.internal.connection.BsonWriterHelper.writeDocument(BsonWriterHelper.java:77)
	at com.mongodb.internal.connection.BsonWriterHelper.writePayload(BsonWriterHelper.java:59)
	at com.mongodb.internal.connection.CommandMessage.encodeMessageBodyWithMetadata(CommandMessage.java:145)
	at com.mongodb.internal.connection.RequestMessage.encode(RequestMessage.java:138)
	at com.mongodb.internal.connection.CommandMessage.encode(CommandMessage.java:59)
	at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:247)
	at com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:99)
	at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:500)
	at com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:71)
	at com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:224)
	at com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:202)
	at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:118)
	at com.mongodb.internal.operation.MixedBulkWriteOperation.executeCommand(MixedBulkWriteOperation.java:419)
	at com.mongodb.internal.operation.MixedBulkWriteOperation.executeBulkWriteBatch(MixedBulkWriteOperation.java:245)

当前java-mongo-driver版本为4.0.6

2、经过分析和查看源码结论为：

[JAVA-2810] Allow dots and $ in field names - MongoDB Jira。这也算是java驱动里面的一个bug. 因为用python写入带有小数点符号的到mongo可正常写入。

官方文档说明：

Field Names with Periods (.) and Dollar Signs ($) — MongoDB Manual

MongoDB Limits and Thresholds — MongoDB Manual

 

 

3.解决办法

重写一个类名为

CollectibleDocumentFieldNameValidator

注意包名：

com.mongodb.internal.validator

package com.mongodb.internal.validator;

import org.bson.FieldNameValidator;

import java.util.Arrays;
import java.util.List;

/**
 * 解决mongo驱动包中限制Field不能包含.以及$符号问题
 */
public class CollectibleDocumentFieldNameValidator implements FieldNameValidator {
    private static final List<String> EXCEPTIONS = Arrays.asList("$db", "$ref", "$id");

    @Override
    public boolean validate(final String fieldName) {
        if (fieldName == null) {
            throw new IllegalArgumentException("Field name can not be null [hy]");
        }

        if (fieldName.contains(".")) {
            return true;
        }

        if (fieldName.startsWith("$") && !EXCEPTIONS.contains(fieldName)) {
            return true;
        }
        return true;
    }

    @Override
    public FieldNameValidator getValidatorForField(final String fieldName) {
        return this;
    }
}

因为java加载包是优先加载本地class文件中的类在加载lib包中，利用该特性覆盖

CollectibleDocumentFieldNameValidator