search

oasp / oasp4j

The Open Application Standard Platform for Java
Apache License 2.0
60 stars 303 forks source link

Error getting id from entity in Cobigen generated code #636

Closed vlopezbo closed 6 years ago

vlopezbo commented 6 years ago

I got an error when I was trying to retrieve some objects from the database:

ReportLineSearchCriteriaTo criteria = new ReportLineSearchCriteriaTo();
criteria.setReportId(savedReport.getId());
List<ReportLineEntity> savedLines = getReportLineDao().findReportLines(criteria).getResult();
Caused by: org.hibernate.QueryException: could not resolve property: reportId of: com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity [select reportLineEntity
from com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity reportLineEntity
where reportLineEntity.reportId = ?1]
    at org.hibernate.QueryException.generateQueryException(QueryException.java:120) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]

In order to get around this problem, I had to replace a reference to 'getReportId()' in my 'ReportLineDaoImpl.java' (automatically generated by Cobigen) with 'getReport().getId()', but I don't quite understand the reason for this problem.

  @Override
  public PaginatedListTo<ReportLineEntity> findReportLines(ReportLineSearchCriteriaTo criteria) {
    /*** ... ***/ 
    Long report = criteria.getReportId();
    if (report != null) {
      if (reportline.getReport() != null) {
        // query.where(Alias.$(reportline.getReportId()).eq(report));  // <- Generated by Cobigen
        query.where(Alias.$(reportline.getReport().getId()).eq(report));  // <- "Fix"
      }
    }
    addOrderBy(query, alias, reportline, criteria.getSort());

    return findPaginated(criteria, query, alias);
  }

The relationship between the entities in question was mapped as follows:

-- ****************
-- *** DATABASE ***
-- ****************

-- *** Report ***
CREATE TABLE Report(
  id BIGINT NOT NULL AUTO_INCREMENT,
  modificationCounter INTEGER NOT NULL,
  reportType VARCHAR(255),
  code VARCHAR(255),
  fromDate TIMESTAMP,
  toDate TIMESTAMP,
  reportDate TIMESTAMP,
  CONSTRAINT PK_Report PRIMARY KEY(id)
);

-- *** ReportLine ***
CREATE TABLE ReportLine(
  id BIGINT NOT NULL AUTO_INCREMENT,
  modificationCounter INTEGER NOT NULL,
  idReport BIGINT NOT NULL,
  transactionNumber INTEGER,
  fieldOrder INTEGER,
  fieldName VARCHAR(255),
  description VARCHAR(255),
  rule VARCHAR(255),
  result VARCHAR(255),
  CONSTRAINT PK_ReportLine PRIMARY KEY(id),
  CONSTRAINT FK_PeportLine_idReport FOREIGN KEY(idReport) REFERENCES Report(id) NOCHECK  
);  
/********/
/* JAVA */
/********/
/*********************/
/* ReportEntity.java */
/*********************/

package com.capgemini.pocdrools.reportmanagement.dataaccess.api;

/* Imports */

@Entity
@Table(name = "Report")
public class ReportEntity extends ApplicationPersistenceEntity implements Report {

  /* Properties */

  private List<ReportLineEntity> reportLines;

  /* Getters & Setters */

  /**
   * @return reportLines
   */
  @OneToMany(mappedBy = "report", fetch = FetchType.EAGER)
  public List<ReportLineEntity> getReportLines() {

    return this.reportLines;
  }

  /**
   * @param reportLines new value of {@link #getreportLines}.
   */
  public void setReportLines(List<ReportLineEntity> reportLines) {

    this.reportLines = reportLines;
  }

}  

/*************************/
/* ReportLineEntity.java */
/*************************/

package com.capgemini.pocdrools.reportmanagement.dataaccess.api;

/* Imports */

@Entity
@Table(name = "ReportLine")
public class ReportLineEntity extends ApplicationPersistenceEntity implements ReportLine {

  /* Properties */

  private ReportEntity report;

  /* Getters & Setters */

  /**
   * @return report
   */
  @ManyToOne(fetch = FetchType.EAGER)
  @JoinColumn(name = "idReport")
  public ReportEntity getReport() {

    return this.report;
  }

  /**
   * @param report new value of {@link #getreport}.
   */
  public void setReport(ReportEntity report) {

    this.report = report;
  }

  @Override
  @Transient
  public Long getReportId() {

    if (this.report == null) {
      return null;
    }
    return this.report.getId();
  }

  @Override
  public void setReportId(Long reportId) {

    if (reportId == null) {
      this.report = null;
    } else {
      ReportEntity reportEntity = new ReportEntity();
      reportEntity.setId(reportId);
      this.report = reportEntity;
    }
  }

}

/*****/

2018-04-06 12:21:28.816  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : **********************************************************
2018-04-06 12:21:28.816  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> START ReportmanagementImpl -> generateReport
2018-04-06 12:21:28.828  INFO 13172 --- [nio-8081-exec-1] org.dozer.DozerBeanMapper                : Using the following xml files to load custom mappings for the bean mapper instance: [config/app/common/dozer-mapping.xml]
2018-04-06 12:21:28.828  INFO 13172 --- [nio-8081-exec-1] org.dozer.DozerBeanMapper                : Trying to find xml mapping file: config/app/common/dozer-mapping.xml
2018-04-06 12:21:28.839  INFO 13172 --- [nio-8081-exec-1] org.dozer.DozerBeanMapper                : Using URL [file:/C:/Devon-dist_2.3.1/workspaces/pocdrools/pocdrools/core/target/classes/config/app/common/dozer-mapping.xml] to load custom xml mappings
2018-04-06 12:21:28.882  INFO 13172 --- [nio-8081-exec-1] org.dozer.DozerBeanMapper                : Successfully loaded custom xml mappings from URL: [file:/C:/Devon-dist_2.3.1/workspaces/pocdrools/pocdrools/core/target/classes/config/app/common/dozer-mapping.xml]
2018-04-06 12:21:28.992  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Generating report code...
2018-04-06 12:21:28.992  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Generated code: MIFIR20180406122128992
2018-04-06 12:21:28.994  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Save Report...
2018-04-06 12:21:29.076  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Report with id '1' has been created.
2018-04-06 12:21:29.076  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Generating report lines...
2018-04-06 12:21:29.076  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Retrieving InputData Objects...
2018-04-06 12:21:29.513  INFO 13172 --- [nio-8081-exec-1] o.h.h.i.QueryTranslatorFactoryInitiator  : HHH000397: Using ASTQueryTranslatorFactory
2018-04-06 12:21:29.749  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Number of InputData Objects retrieved: 1
2018-04-06 12:21:29.749  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Retrieving OutputData Objects...
2018-04-06 12:21:29.784  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Number of OutputData Objects retrieved: 10
2018-04-06 12:21:29.784  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> Number of lines: 10
2018-04-06 12:21:29.795  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '1' has been created.
2018-04-06 12:21:29.798  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '2' has been created.
2018-04-06 12:21:29.799  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '3' has been created.
2018-04-06 12:21:29.801  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '4' has been created.
2018-04-06 12:21:29.803  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '5' has been created.
2018-04-06 12:21:29.806  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '6' has been created.
2018-04-06 12:21:29.808  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '7' has been created.
2018-04-06 12:21:29.809  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '8' has been created.
2018-04-06 12:21:29.810  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '9' has been created.
2018-04-06 12:21:29.811  INFO 13172 --- [nio-8081-exec-1] c.c.a.m.p.r.l.impl.ReportmanagementImpl  : >>>> ReportLine with id '10' has been created.
2018-04-06 12:21:29.989 ERROR 13172 --- [nio-8081-exec-1] i.o.m.r.s.i.RestServiceExceptionFacade   : Service failed on server

net.sf.mmm.util.exception.api.TechnicalErrorUserException: An unexpected error has occurred! We apologize any inconvenience. Please try again later.
ea7b8f64-f440-42d9-8802-f8a8da1a908f:TechnicalError
    at net.sf.mmm.util.exception.api.TechnicalErrorUserException.getOrCreateUserException(TechnicalErrorUserException.java:110) ~[mmm-util-core-7.5.1.jar:7.5.1]
    at io.oasp.module.rest.service.impl.RestServiceExceptionFacade.handleGenericError(RestServiceExceptionFacade.java:282) [oasp4j-rest-2.5.0.jar:2.5.0]
    at io.oasp.module.rest.service.impl.RestServiceExceptionFacade.toResponse(RestServiceExceptionFacade.java:239) [oasp4j-rest-2.5.0.jar:2.5.0]
    at io.oasp.module.rest.service.impl.RestServiceExceptionFacade.toResponse(RestServiceExceptionFacade.java:179) [oasp4j-rest-2.5.0.jar:2.5.0]
    at org.apache.cxf.jaxrs.utils.ExceptionUtils.convertFaultToResponse(ExceptionUtils.java:86) [cxf-rt-frontend-jaxrs-3.1.8.jar:3.1.8]
    at org.apache.cxf.jaxrs.utils.JAXRSUtils.convertFaultToResponse(JAXRSUtils.java:1627) [cxf-rt-frontend-jaxrs-3.1.8.jar:3.1.8]
    at org.apache.cxf.jaxrs.JAXRSInvoker.handleFault(JAXRSInvoker.java:331) [cxf-rt-frontend-jaxrs-3.1.8.jar:3.1.8]
    at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:203) [cxf-rt-frontend-jaxrs-3.1.8.jar:3.1.8]
    at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99) [cxf-rt-frontend-jaxrs-3.1.8.jar:3.1.8]
    at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) [cxf-core-3.1.8.jar:3.1.8]
    at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) [cxf-core-3.1.8.jar:3.1.8]
    at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308) [cxf-core-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-core-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:252) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:299) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:218) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) [javax.servlet-api-3.1.0.jar:3.1.0]
    at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:274) [cxf-rt-transports-http-3.1.8.jar:3.1.8]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55) [spring-boot-1.5.3.RELEASE.jar:1.5.3.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at io.oasp.module.logging.common.impl.DiagnosticContextFilter.doFilter(DiagnosticContextFilter.java:84) [oasp4j-logging-2.5.0.jar:2.5.0]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at io.oasp.module.logging.common.impl.PerformanceLogFilter.doFilter(PerformanceLogFilter.java:59) [oasp4j-logging-2.5.0.jar:2.5.0]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110) [spring-boot-actuator-1.5.3.RELEASE.jar:1.5.3.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) [spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106) [spring-boot-actuator-1.5.3.RELEASE.jar:1.5.3.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_151]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_151]
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.14.jar:8.5.14]
    at java.lang.Thread.run(Thread.java:748) [na:1.8.0_151]
Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.QueryException: could not resolve property: reportId of: com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity [select reportLineEntity
from com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity reportLineEntity
where reportLineEntity.reportId = ?1]; nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property: reportId of: com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity [select reportLineEntity
from com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity reportLineEntity
where reportLineEntity.reportId = ?1]
    at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:384) ~[spring-orm-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:246) ~[spring-orm-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488) ~[spring-orm-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) ~[spring-tx-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) ~[spring-tx-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) ~[spring-tx-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.impl.dao.ReportLineDaoImpl$$EnhancerBySpringCGLIB$$9d5debe6.findReportLines(<generated>) ~[classes/:na]
    at com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.logic.impl.ReportmanagementImpl.generateReport(ReportmanagementImpl.java:471) ~[classes/:na]
    at com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.logic.impl.ReportmanagementImpl$$FastClassBySpringCGLIB$$54361c86.invoke(<generated>) ~[classes/:na]
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) ~[spring-tx-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) ~[spring-tx-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.logic.impl.ReportmanagementImpl$$EnhancerBySpringCGLIB$$f5b22a5.generateReport(<generated>) ~[classes/:na]
    at com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.service.impl.rest.ReportmanagementRestServiceImpl.generateReport(ReportmanagementRestServiceImpl.java:179) ~[classes/:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_151]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_151]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_151]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_151]
    at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) ~[cxf-core-3.1.8.jar:3.1.8]
    at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) ~[cxf-core-3.1.8.jar:3.1.8]
    at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:189) [cxf-rt-frontend-jaxrs-3.1.8.jar:3.1.8]
    ... 102 common frames omitted
Caused by: java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property: reportId of: com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity [select reportLineEntity
from com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity reportLineEntity
where reportLineEntity.reportId = ?1]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1679) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:294) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_151]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_151]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_151]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_151]
    at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298) ~[spring-orm-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at com.sun.proxy.$Proxy104.createQuery(Unknown Source) ~[na:na]
    at com.mysema.query.jpa.impl.AbstractJPAQuery.createQuery(AbstractJPAQuery.java:129) ~[querydsl-jpa-3.7.1.jar:na]
    at com.mysema.query.jpa.impl.AbstractJPAQuery.createQuery(AbstractJPAQuery.java:96) ~[querydsl-jpa-3.7.1.jar:na]
    at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:248) ~[querydsl-jpa-3.7.1.jar:na]
    at io.oasp.module.jpa.dataaccess.base.AbstractGenericDao.findPaginated(AbstractGenericDao.java:241) ~[oasp4j-jpa-2.5.0.jar:2.5.0]
    at com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.impl.dao.ReportLineDaoImpl.findReportLines(ReportLineDaoImpl.java:79) ~[classes/:na]
    at com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.impl.dao.ReportLineDaoImpl$$FastClassBySpringCGLIB$$2f78b7f1.invoke(<generated>) ~[classes/:na]
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ~[spring-tx-4.3.8.RELEASE.jar:4.3.8.RELEASE]
    ... 124 common frames omitted
Caused by: org.hibernate.QueryException: could not resolve property: reportId of: com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity [select reportLineEntity
from com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity reportLineEntity
where reportLineEntity.reportId = ?1]
    at org.hibernate.QueryException.generateQueryException(QueryException.java:120) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:218) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:142) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:76) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:150) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:302) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:240) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1894) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:291) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
    ... 140 common frames omitted
Caused by: org.hibernate.QueryException: could not resolve property: reportId of: com.capgemini.adcenter.mirabaud.pocdrools.reportmanagement.dataaccess.api.ReportLineEntity
    at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:62) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:56) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1805) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.tree.FromElementType.getPropertyType(FromElementType.java:393) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.tree.FromElement.getPropertyType(FromElement.java:505) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.tree.DotNode.getDataType(DotNode.java:660) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.tree.DotNode.prepareLhs(DotNode.java:264) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.tree.DotNode.resolve(DotNode.java:204) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:109) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:104) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:942) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1283) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4696) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4166) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2131) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:810) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:605) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:309) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:257) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:262) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:190) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    ... 148 common frames omitted

2018-04-06 12:21:30.075  INFO 13172 --- [nio-8081-exec-1] i.o.m.l.c.impl.PerformanceLogFilter      : http://localhost:8081/poc/services/rest/reportmanagement/v1/report/generate;1575;500;;
maybeec commented 6 years ago

Ok this is a tricky issue. Basically, QueryDSL tries to recover the column name by calling the getter of the persistence entity. By calling getReportId(), which is a transient method, QueryDSL does not know which column we are addressing. So, you already found the right way to do and we should fix this in the CobiGen templates. I created devonfw/tools-cobigen#551 for that.

Thanks for sharing! I will close this issue in favor of the created CobiGen issue.