- 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