Estou tentando gerar relatório com jasper e spring mvc, é uma especie de certificado que vai ter nome, titulo do treinamento, data de conclusão e pontuação. acompanhei a aula do Alura mais nao estou conseguindo adaptar para meu problema.
//Meu botão, que chama o controller para gerar o certificado, passando o id pego pelo angularJS
Gerar Certificado
//Meu controller que recebe o id do jsp.
@RequestMapping("certificados/{id}")
public void Certificado(HttpServletRequest request, HttpServletResponse response,@PathVariable("id") long id) throws ServletException, IOException {
Colaborador colaborador = new TreinamentosDao().buscaCertificado(id);
System.out.println(id);
try {
String nome = request.getServletContext().getRealPath("/WEB-INF/jasper/certificado_Treinamento.jasper");
EntityManager connection = new JPAUtil().manager();
Map<String, Object> parametros = new HashMap<String, Object>();
GeradorRelatorio gerador = new GeradorRelatorio(nome, parametros, connection);
gerador.geraPDFParaOutputStream(response.getOutputStream());
connection.close();
} catch (Exception e) {
throw new ServletException(e);
}
}
//Meu gerador de relatorio
public class GeradorRelatorio {
private String nomeArquivo;
private Map<String, Object> parametros;
private EntityManager connection;
public GeradorRelatorio(String nomeArquivo, Map<String, Object> parametros, EntityManager connection) {
this.nomeArquivo = nomeArquivo;
this.parametros = parametros;
this.connection = connection;
}
public void geraPDFParaOutputStream(OutputStream outputStream) throws ServletException, IOException {
try {
JasperPrint jasperPrint = JasperFillManager.fillReport(this.nomeArquivo, this.parametros, (Connection) this.connection);
JRExporter exporter = new JRPdfExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
exporter.exportReport();
} catch (JRException e) {
throw new RuntimeException(e);
}
}
// ERRO
Aug 01, 2017 8:34:11 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [spring-context] in context with path [/api] threw exception [java.lang.ClassCastException: org.hibernate.jpa.internal.EntityManagerImpl cannot be cast to java.sql.Connection] with root cause
java.lang.ClassCastException: org.hibernate.jpa.internal.EntityManagerImpl cannot be cast to java.sql.Connection
at br.com.grupoinvestiga.gerador.GeradorRelatorio.geraPDFParaOutputStream(GeradorRelatorio.java:33)
at br.com.grupoinvestiga.controller.PaginasController.Certificado(PaginasController.java:109)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:114)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
alguem consegue me apontar o erro.?