作为参数传递的JPA中的日期时间表达式开发者社区

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

温柔的野马 · 江苏省人民政府督察动态洼塘堆放建筑垃圾 ...· 1 年前 ·

从容的排球 · 北京大学城市与环境学院_个人简历· 1 年前 ·

狂野的伏特加 · 慎入！彩星玩具剧透《哥斯拉大战金刚》？_电影· 2 年前 ·

果断的水龙头 · 封神！顶级大佬回国仅5个月，再发《Natur ...· 2 年前 ·

近视的剪刀 · 《皇帝的独生女》漫画 - 抖音· 2 年前 ·

    @Column(name = "PublishDate", nullable = false)
    private Date publishDate;

    Date date = simpleDateFormat.parse(s);
    Message.findByPublishDate(date);

select operations0_.OperationsMessageID as Operatio1_10_, operations0_.Content as Content2_10_, 
operations0_.CreatedDate as CreatedD3_10_, operations0_.ExpiryDate as ExpiryDa4_10_, 
operations0_.PublishDate as PublishD5_10_, operations0_.Status as Status6_10_, operations0_.Title 
as Title7_10_, operations0_.OperationsMessageTypeID as Operatio8_10_ from OperationsMessage 
operations0_ where operations0_.PublishDate=?

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:172)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:155)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.jpa.repository.support.LockModeRepositoryPostProcessor$LockModePopulatingMethodIntercceptor.invoke(LockModeRepositoryPostProcessor.java:105)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

问 作为参数传递的JPA中的日期时间表达式