使用JPA启动报错求解

lihongqing62 2015-12-31 01:05:53

我的sql
@Query("select r from RealTimeWeibao r left join r.realTimeWeibaoTop t where r.submitterId =:id and status =:status order by t.upFlag")
public List<RealTimeWeibao> getAllBySubmitterIdAndStatus(@Param("id")Long id, @Param("status")int status);

pojo
@Entity
@Table(name = "tb_weibao_realtime")
public class RealTimeWeibao extends ObjWithOwner {

private Long id;
private String wbrealNo;
private String subject;
private Long submitterId;
private Timestamp createTime;
private Timestamp publishTime;
private String strId;
private Timestamp finishTime;
private Long projId;
private String keywords;
private int status; //0 草稿, 1 进行中, 3 已完成
private String result;
private String content;
private Long chatSessionId;
private Long msgcount;
private Set<Device> devices;
private Project project;
private Set<User> shareusers;
private User submitter;

@OneToMany(cascade = { CascadeType.ALL }, fetch = FetchType.EAGER, mappedBy = "weibao_id")
private RealTimeWeibaoTop realTimeWeibaoTop;

public RealTimeWeibaoTop getRealTimeWeibaoTop() {
return realTimeWeibaoTop;
}
//其他get(), set()方法
}
@Entity
@Table(name = "tb_weibao_realtime_top")
public class RealTimeWeibaoTop extends BaseObj implements Serializable {

private static final long serialVersionUID = 8648302463019223202L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
@Column(name = "user_id")
private Long userId;
@Column(name = "weibao_id")
private Long weibaoId;
@Column(name = "up_flag", columnDefinition="bigint default 1")
private Long upFlag = 1L;

public RealTimeWeibaoTop() {
super();
}
@ManyToOne(targetEntity = RealTimeWeibao.class, cascade = {CascadeType.REFRESH }, fetch = FetchType.EAGER)
@JoinColumn(name = "id", insertable = false, updatable = false)
public Long getWeibaoId() {
return weibaoId;
}
public void setWeibaoId(Long weibaoId) {
this.weibaoId = weibaoId;
}
//其他get(), set()方法
}

启动报错
... 54 more
Caused by: java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List com.weibao.ui.dao.RealTimeWeibaoDao.getAllBySubmitterIdAndStatus(java.lang.Long,int)!
at org.springframework.data.jpa.repository.query.SimpleJpaQuery.validateQuery(SimpleJpaQuery.java:92)
at org.springframework.data.jpa.repository.query.SimpleJpaQuery.<init>(SimpleJpaQuery.java:62)
at org.springframework.data.jpa.repository.query.JpaQueryFactory.fromMethodWithQueryString(JpaQueryFactory.java:72)
at org.springframework.data.jpa.repository.query.JpaQueryFactory.fromQueryAnnotation(JpaQueryFactory.java:53)
at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$DeclaredQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:136)
at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateIfNotFoundQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:204)
at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$AbstractQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:73)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.<init>(RepositoryFactorySupport.java:347)
at org.springframework.data.repository.core.support.RepositoryFactorySupport.getRepository(RepositoryFactorySupport.java:185)
at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.initAndReturn(RepositoryFactoryBeanSupport.java:239)
at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.afterPropertiesSet(RepositoryFactoryBeanSupport.java:225)
at org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean.afterPropertiesSet(JpaRepositoryFactoryBean.java:92)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)
... 64 more
Caused by: java.lang.NullPointerException
at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:408)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3903)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3689)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3567)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:708)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:564)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1800)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:328)
at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:344)
at com.sun.proxy.$Proxy46.createQuery(Unknown Source)
at org.springframework.data.jpa.repository.query.SimpleJpaQuery.validateQuery(SimpleJpaQuery.java:86)
... 77 more

十二月 31, 2015 1:06:34 下午 org.apache.catalina.core.StandardContext startInternal
严重: One or more listeners failed to start. Full details will be found in the appropriate container log file
十二月 31, 2015 1:06:34 下午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/saas] startup failed due to previous errors
十二月 31, 2015 1:06:34 下午 org.apache.catalina.core.ApplicationContext log
信息: Closing Spring root WebApplicationContext
十二月 31, 2015 1:06:34 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/saas] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
十二月 31, 2015 1:06:34 下午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory D:\tomcat\apache-tomcat-7.0.65-windows-x64\webapps\saas has finished in 22,362 ms
十二月 31, 2015 1:06:34 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-apr-8081"]
十二月 31, 2015 1:06:34 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-apr-8010"]
十二月 31, 2015 1:06:34 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 23712 ms

求高手看过来感激不尽!!

...全文