具有10个以上参数的java Spring数据mongo

Question

我想检查集合中是否存在一个包含15个相等字段的文档。而且@Query注释似乎不能处理超过10个参数。以下类在调用重复时引发异常

public interface ReportingentriesRepository extends MongoRepository<Reportingentries, String> {

    @Query(exists = true,value = "{ 'foo': ?0,'foo1': ?1,'foo2': ?2,'foo3': ?3,'foo4': ?4,'foo5': ?5,'foo6': ?6,'foo7': ?7,'foo8': ?8,'foo9': ?9, 'foo10': ?10}")
    boolean isDuplicated(String value0, String value1, String value2, String value3, String value4, String value5, String value6, String value7, String value8, String value9, String value10);
}

例外情况是：

java.util.NoSuchElementException: Could not to find binding for placeholder '?11'.
    at org.springframework.data.mongodb.repository.query.ExpressionEvaluatingParameterBinder$BindingContext.getBindingFor(ExpressionEvaluatingParameterBinder.java:341) ~[spring-data-mongodb-1.10.0.RELEASE.jar:?]
    at org.springframework.data.mongodb.repository.query.ExpressionEvaluatingParameterBinder.replacePlaceholders(ExpressionEvaluatingParameterBinder.java:120) ~[spring-data-mongodb-1.10.0.RELEASE.jar:?]
    at org.springframework.data.mongodb.repository.query.ExpressionEvaluatingParameterBinder.bind(ExpressionEvaluatingParameterBinder.java:91) ~[spring-data-mongodb-1.10.0.RELEASE.jar:?]
    at org.springframework.data.mongodb.repository.query.StringBasedMongoQuery.createQuery(StringBasedMongoQuery.java:130) ~[spring-data-mongodb-1.10.0.RELEASE.jar:?]
    at org.springframework.data.mongodb.repository.query.AbstractMongoQuery.execute(AbstractMongoQuery.java:84) ~[spring-data-mongodb-1.10.0.RELEASE.jar:?]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:483) ~[spring-data-commons-1.13.0.RELEASE.jar:?]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461) ~[spring-data-commons-1.13.0.RELEASE.jar:?]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.6.RELEASE.jar:4.3.6.RELEASE]
    at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61) ~[spring-data-commons-1.13.0.RELEASE.jar:?]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.6.RELEASE.jar:4.3.6.RELEASE]
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.6.RELEASE.jar:4.3.6.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.6.RELEASE.jar:4.3.6.RELEASE]
    at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57) ~[spring-data-commons-1.13.0.RELEASE.jar:?]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.6.RELEASE.jar:4.3.6.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.6.RELEASE.jar:4.3.6.RELEASE]
    at com.sun.proxy.$Proxy94.isDuplicated(Unknown Source) ~[?:?]
    at com.company.importer.Application.run(Application.java:29) [classes/:?]
    at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:776) [spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
    at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:760) [spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
    at org.springframework.boot.SpringApplication.afterRefresh(SpringApplication.java:747) [spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1162) [spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1151) [spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
    at com.company.importer.Application.main(Application.java:22) [classes/:?]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_92]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_92]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_92]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_92]
    at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) [spring-boot-devtools-1.5.1.RELEASE.jar:1.5.1.RELEASE]

是我遗漏了什么，还是spring根本不支持这一点

我使用的是SpringBootStarter数据mongodb:1.5.1。释放

Answer 1

Spring数据还有一个注释，这将有助于将方法参数视为查询参数

Annotation: @Param

此注释可与方法参数本身一起使用。请查找下面的格式，它可以帮助扩展方法参数计数，以用于spring数据

解释：您可以在@Param注释中包含N个方法参数。请在下面找到有效的表达式来编写注释

@Param("param0")

现在，当添加带有方法参数的@Param注释时，必须在@Query中指定前缀为colon (:)的参数。在下面的查询中，类似于param0

@Query("{"query": {"bool": {"must": [{ "match": {"userId": ":param0" }}]}}}")

完整示例：您可以看到org_id是查询参数

@Query("{"query": {"bool": {"must": [{ "match": {"userId": ":org_Id"}}]}}}")
List<User> getByOrgId(@Param("org_Id") String orgId)

Answer 2

我不知道你是否已经解决了这个问题，但我有两个不同的问题，你可以在这里查看：how-to-use-the-same-parameter-for-multiple-conditions

第一个问题是，我想重复一个参数，所以我尝试使用@Param，然后我开始得到与您相同的错误，我不能使用超过10个参数

因此，我决定调试绑定过程，并通过向参数添加一个简单的单引号来解决这两个问题，如下所示（检查参数编号6）：

@Query(value = "{ companyType: ?0, companyId: ?1, eventType: ?2, " +
            "delivered: ?3, createdAt: { $gt: ?4, $lt: ?5 }, " +
            "$or: [{ $or: [{ $or: [{ $or: [{ requestPayload.sponsorGovernmentId: ?6 }, " +
            "{requestPayload.buyerGovernmentId: '?6'}] }, {requestPayload.supplierGovernmentId: '?6'}] }, " +
            "{requestPayload.invoiceNumber: ?7}]}, {requestPayload.externalId: ?8}] }")

在那之后，我能够使用10多个参数并重复它