搜索
搜索

Spring Query DSL提供空指针异常

user3335083 发表于 Dev
60
用户名

我为此原型使用Spring Boot和Hibernate文件数据库。

这是application.properties的摘录（显然省略了用户/密码。）注：我已将fave设置为String而不是布尔值，因此我可以在Query DSL Bindings中使用String：

spring.jpa.generate-ddl=true
spring.datasource.url=jdbc:h2:file:~/db
spring.datasource.driver-class-name=org.h2.Driver
hibernate.hbm2ddl.auto=update
hibernate.dialect=org.hibernate.dialect.H2Dialect
hibernate.show_sql=true

这是带有City类的模型，因为它非常简单：

@Data
@AllArgsConstructor
@Entity
@Table(name = "matches")
@EqualsAndHashCode(of = "id")
public class FilterMatch {

    @SequenceGenerator(name = "MATCHES_SEQ_GENERATOR", sequenceName = "MATCHES_SEQ",
                       initialValue = 1, allocationSize = 1)

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO, generator = "MATCHES_SEQ_GENERATOR")
    @Column
    private Long id;

    @Column
    private String fave;

    @Column
    private int age;

    @Column
    private int cmHeight;

    @Column
    private int contactsExchanged;

    @Column
    private float compatScore;

    @Column
    private String displayName;

    @Column
    private String jobTitle;

    @Column
    private String mainPhoto;

    @Column
    private String religion;

    @OneToOne(cascade=CascadeType.ALL, fetch = FetchType.LAZY)
    private City city;

    public FilterMatch() {} 

    // getters/setters omitted
}

这是根据需要扩展JPARepository的存储库：

public interface FilterMatchRepository extends JpaRepository<FilterMatch, Long>,
    QueryDslPredicateExecutor<FilterMatch>,QuerydslBinderCustomizer<QFilterMatch> {


    @Override
    default public void customize(QuerydslBindings bindings, QFilterMatch root) {
        bindings.bind(String.class)
                .first((SingleValueBinding<StringPath, String>) StringExpression::containsIgnoreCase);
        bindings.excluding(root.religion,root.jobTitle);
    }

}

我的SearchCriteria类：

public class SearchCriteria {

    private static final Logger logger = LogManager.getLogger(SearchCriteria.class);

    private String key;
    private String operation;
    private Object value;

    public SearchCriteria(String key, String operation, Object value)  {
        this.key = key;
        this.operation = operation;
        this.value = value;
    }
    //getters & setters omitted.
}

我的MatchBuilderPredicates类和MatchPredicates类：

public class MatchPredicatesBuilder {

    private static final Logger logger = LoggerFactory.getLogger(MatchPredicatesBuilder.class);

    private List<SearchCriteria> parameters;

    public MatchPredicatesBuilder() {
        parameters = new ArrayList<>();
    }

    public MatchPredicatesBuilder with(String key, String operation, Object value) {

        parameters.add(new SearchCriteria(key, operation, value));
        return this;
    }

    public BooleanExpression build() {

        if (parameters.size() == 0) {
            return null;
        }

        List<BooleanExpression> predicates = new ArrayList<>();
        MatchPredicate predicate;

        for (SearchCriteria param : parameters) {

            predicate = new MatchPredicate(param);
            BooleanExpression expression = predicate.getPredicate();

            if (Objects.nonNull(expression)) {
                predicates.add(expression);
            }
        }

        BooleanExpression result = predicates.get(0);

        for (int i = 1; i < predicates.size(); i++) {

            result = result.and(predicates.get(i));
        }
        return result;
    }   

}

public class MatchPredicate {

    private static final long serialVersionUID = 8621295752447527269L;
    private static final Logger logger = LoggerFactory.getLogger(MatchPredicate.class);

    private SearchCriteria criteria;

    public MatchPredicate(SearchCriteria criteria) {
        this.criteria = criteria;
    }

    public BooleanExpression getPredicate() {

        PathBuilder<FilterMatch> entityPath = new PathBuilder<>(FilterMatch.class, "FilterMatch");

        if (FilterUtils.isNumeric(criteria.getValue().toString())) {

            NumberPath<Double> path = entityPath.getNumber(criteria.getKey(), Double.class);
            double value = Double.parseDouble(criteria.getValue().toString());

            switch (criteria.getOperation()) {
                case ":":
                    return path.eq(value);
                case ">":
                    return path.goe(value);
                case "<":
                    return path.loe(value);
            }
        } else {

            StringPath path = entityPath.getString(criteria.getKey());

            if (criteria.getOperation().equalsIgnoreCase(":")) {
                return path.containsIgnoreCase(criteria.getValue().toString());
            }
        }
        return null;
    }   
}

因此，此集成测试将引发NPE：

@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
public class JpaQueryDslIntegrationTest {

    private static final Logger logger = LoggerFactory.getLogger(JpaQueryDslIntegrationTest.class);

    @Autowired
    private FilterMatchRepository matchRepository;

    private FilterMatch match1;
    private FilterMatch match2;

    /**
     * @throws java.lang.Exception
     */
    @Before
    public void setUp() throws Exception {

        match1 = new FilterMatch();
        match1.setDisplayName("Emma");
        match1.setAge(40);
        match1.setJobTitle("Banker");
        match1.setCmHeight(150);

        City leeds = new City();
        leeds.setName("Leeds");
        leeds.setLon(-1.548567);
        leeds.setLat(53.801277);

        match1.setCity(leeds);
        match1.setMainPhoto("http://thecatapi.com/api/images/get?format=src&type=gif");
        match1.setCompatScore(0.73f);
        match1.setContactsExchanged(0);
        match1.setFave(Constants.FALSE.getValue());
        match1.setReligion("Christian");
        matchRepository.save(match1);

        match2 = new FilterMatch();
        match2.setDisplayName("Diana");
        match2.setAge(44);
        match2.setJobTitle("Consultant");
        match2.setCmHeight(153);

        City london = new City();
        london.setName("London");
        london.setLat(51.509865);
        london.setLon(-0.118092);

        match2.setCity(london);
        match2.setMainPhoto("http://thecatapi.com/api/images/get?format=src&type=gif");
        match2.setCompatScore(0.50f);
        match2.setContactsExchanged(0);
        match2.setFave(Constants.TRUE.getValue());
        match2.setReligion("Atheist");
        matchRepository.save(match2);
    }

    @Test
    public final void testMultipleMatch() {

        MatchPredicatesBuilder builder = new MatchPredicatesBuilder().with("displayName", ":", "Emma");

        Iterable<FilterMatch> results = matchRepository.findAll();
        results = matchRepository.findAll(builder.build()); // This is the line that throws the NPE. i've tested and builder.build() isn't null  
        assertThat(results, Matchers.containsInAnyOrder(match1, match2));
    }
}

我打印出了builder.build（）的内容，它是：

containsIc(FilterMatch.displayName,Emma)

这是堆栈跟踪减少了一点。：

java.lang.NullPointerException
    at java.lang.String$CaseInsensitiveComparator.compare(String.java:1192)
    at java.lang.String$CaseInsensitiveComparator.compare(String.java:1186)
    at java.util.TreeMap.getEntryUsingComparator(TreeMap.java:376)
    at java.util.TreeMap.getEntry(TreeMap.java:345)
    at java.util.TreeMap.get(TreeMap.java:278)
    at org.hibernate.dialect.function.SQLFunctionRegistry.findSQLFunction(SQLFunctionRegistry.java:45)
    at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.findSQLFunction(SessionFactoryHelper.java:369)
    at org.hibernate.hql.internal.ast.tree.IdentNode.getDataType(IdentNode.java:374)
    at org.hibernate.hql.internal.ast.HqlSqlWalker.lookupProperty(HqlSqlWalker.java:654)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:5003)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1286)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4707)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalker.java:2733)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1365)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4707)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4319)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2138)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:815)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:609)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:313)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:261)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:266)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
    at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:553)
    at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:662)
    at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298)
    at com.sun.proxy.$Proxy58.createQuery(Unknown Source)
    at com.querydsl.jpa.impl.AbstractJPAQuery.createQuery(AbstractJPAQuery.java:101)
    at com.querydsl.jpa.impl.AbstractJPAQuery.createQuery(AbstractJPAQuery.java:94)
    at com.querydsl.jpa.impl.AbstractJPAQuery.fetch(AbstractJPAQuery.java:201)
    at org.springframework.data.jpa.repository.support.QueryDslJpaRepository.findAll(QueryDslJpaRepository.java:105)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:520)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:505)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:477)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

我有一些问题：

1）我的MatchPredicatesBuilder返回一个BooleanExpression，因为我遵循的教程说我应该这样做，但是我不知道为什么编译器不会对此感到cho恼。我去过Java文档，这仍然是个谜。

2）为什么会抛出NPE？builder.build（）不为null。从堆栈跟踪很难分辨。

用户名

答案最终是，将实体表命名为除类本身名称之外的任何其他名称都无法解决。当您让休眠自动创建数据库和架构时，会发生这种情况。

我将MatchPredicate类中的行从以下位置更改：

    PathBuilder<FilterMatch> entityPath = new PathBuilder<>(FilterMatch.class, "FilterMatch");

至：

    PathBuilder<FilterMatch> entityPath = new PathBuilder<>(FilterMatch.class, "matches");

这导致了其他异常。所以现在回到小写的“ filtermatch”，它也与实体类的Table注释名称相同：

@Table(name="filtermatch")

我也改变了：

@SequenceGenerator(name = "MATCHES_SEQ_GENERATOR", sequenceName = "MATCHES_SEQ",
                   initialValue = 1, allocationSize = 1)

至： 

@GenericGenerator(
        name = "MATCH_SEQ_GENERATOR",
        strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator",
        parameters = {
                @Parameter(name = "sequence_name", value = "MATCH_SEQ"),
                @Parameter(name = "initial_value", value = "1"),
                @Parameter(name = "increment_size", value = "1")
        })

它消除了启动日志中一些不推荐使用的错误。

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

Mockito Spring Boot提供了空指针异常

Context.getContentResolver（）。query（）提供空指针异常

Spring with Querydsl：空指针异常

RedisTemplate上的Spring Redis空指针异常

spring boot starter 邮件空指针异常

使用Spring注入EntityManager（空指针异常）

Spring MVC项目中的空指针异常

Spring Boot项目空指针异常

spring和MessagesSource空指针异常

在Sqlitedatabase.query方法中获取空指针异常

服务类Spring boot中的空指针异常

使用Spring Boot进行测试会引发空指针异常

使用 Spring Boot CRUD 的 Junit 中的空指针异常

Spring Boot控制器测试，空指针异常

Spring Data JPA的findById无法调用；空指针异常

在Spring MVC中为MongoTemplate实例获取空指针异常

Spring 3 MVC中的文件上传-空指针异常

静态方法和空指针异常的问题Spring Boot

在MVC Spring中向ActiveMQ发送消息给空指针异常

Spring Boot Data Jpa中的空指针异常

Spring Boot JUnit 测试 beanFactory.getBean 空指针异常

Spring Null指针异常

AppiumDriver提供空指针异常

spring集成dsl异常处理

使用Spring @Query运行JPQL查询时出现异常

在Spring Native Query Project中获取空值

在使用@Query来自Mongo的Spring数据时获取空值

JDBCTemplate 类中 listFriends 方法中 JDBCTemplateObject.query() 中的空指针异常

twitter getOAuthAccessToken提供空指针异常

TOP 榜单

  1. 1

    蓝屏死机没有修复解决方案

  2. 2

    计算数据帧中每行的NA

  3. 3

    UITableView的项目向下滚动后更改颜色，然后快速备份

  4. 4

    Node.js中未捕获的异常错误，发生调用

  5. 5

    在 Python 2.7 中。如何从文件中读取特定文本并分配给变量

  6. 6

    Linux的官方Adobe Flash存储库是否已过时？

  7. 7

    验证REST API参数

  8. 8

    ggplot：对齐多个分面图-所有大小不同的分面

  9. 9

    Mac OS X更新后的GRUB 2问题

  10. 10

    通过 Git 在运行 Jenkins 作业时获取 ClassNotFoundException

  11. 11

    带有错误“ where”条件的查询如何返回结果？

  12. 12

    用日期数据透视表和日期顺序查询

  13. 13

    VB.net将2条特定行导出到DataGridView

  14. 14

    如何从视图一次更新多行（ASP.NET - Core）

  15. 15

    Java Eclipse中的错误13，如何解决？

  16. 16

    尝试反复更改屏幕上按钮的位置 - kotlin android studio

  17. 17

    离子动态工具栏背景色

  18. 18

    应用发明者仅从列表中选择一个随机项一次

  19. 19

    当我尝试下载 StanfordNLP en 模型时，出现错误

  20. 20

    python中的boto3文件上传

  21. 21

    在同一Pushwoosh应用程序上Pushwoosh多个捆绑ID

热门标签

归档