问题背景
今天调试一段代码出现以下报错,网上都没搜到的。实属罕见。看了一下,也看不出个所以然,只要吧select 字段改为select * 即可解决,可能这是与result不是pgsql中常规的varchar字段,是text/json字段,以及几个关联id是int有关。???
Hibernate: SELECT id,result FROM question_answer WHERE check_num = ? and createtime = ?
2018-08-30 16:28:44.058 WARN 13132 --- [nio-8095-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 42703
2018-08-30 16:28:44.058 ERROR 13132 --- [nio-8095-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : ResultSet 中找不到栏位名称 answer。
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [ SELECT id,result FROM question_answer WHERE check_num = ? and createtime = ? ]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:242)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.repository.core.supp
......