Ta ótimo cara:
O DAO está usando o construtor padrão, eu não criei ele [construtor].
O código que está apresentando o erro não é em nenhuma classe minha, na hora que eu dou o new na classe ele já solta a exception.
Eu acredito que os jars estejam corretos porque antes de mexer no projeto (criei uma outra classe com entidade/bean/dao) ele estava funcionando. Normalmente eu só voltaria o que eu fiz né, mas como eu demorei ver o problema eu não tenho certeza do que foi que eu mexi :oops:
O que eu não postei antes foi com medo do tamanho do tópico mas se precisar de qualquer coisa é só falar ok? Valeu a ajuda.
Aqui em baixo está indo o stacktrace completo e a classe DAO que está soltando o erro:
30/08/2011 09:31:10 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /home/delki8/desenvolvimento/jdk/jre/lib/i386/server:/home/delki8/desenvolvimento/jdk/jre/lib/i386:/home/delki8/desenvolvimento/jdk/jre/../lib/i386:
/home/delki8/desenvolvimento/jdk/jre/lib/i386/client:/home/delki8/desenvolvimento/jdk/jre/lib/i386::/usr/java/packages/lib/i386:/lib:/usr/lib
30/08/2011 09:31:10 org.apache.tomcat.util.digester.SetPropertiesRule begin
AVISO: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:entun0.2' did not find a matching property.
30/08/2011 09:31:10 org.apache.tomcat.util.digester.SetPropertiesRule begin
AVISO: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'realoadable' to 'true' did not find a matching property.
30/08/2011 09:31:10 org.apache.tomcat.util.digester.SetPropertiesRule begin
AVISO: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:entun0.1' did not find a matching property.
30/08/2011 09:31:10 org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
30/08/2011 09:31:11 org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
30/08/2011 09:31:11 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1246 ms
30/08/2011 09:31:11 org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
30/08/2011 09:31:11 org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.16
30/08/2011 09:31:16 com.sun.faces.config.ConfigureListener contextInitialized
INFO: Inicializando Mojarra 2.1.2 (FCS 20110613) para o contexto '/entun0.2'
30/08/2011 09:31:17 com.sun.faces.spi.InjectionProviderFactory createInstance
INFO: JSF1048: Anotações PostConstruct/PreDestroy presentes. Os métodos ManagedBeans marcados com essas anotações informarão as anotações processadas.
30/08/2011 09:31:20 com.sun.faces.config.ConfigureListener contextInitialized
INFO: Inicializando Mojarra 2.1.2 (FCS 20110613) para o contexto '/entun0.1'
30/08/2011 09:31:21 com.sun.faces.spi.InjectionProviderFactory createInstance
INFO: JSF1048: Anotações PostConstruct/PreDestroy presentes. Os métodos ManagedBeans marcados com essas anotações informarão as anotações processadas.
30/08/2011 09:31:22 com.sun.faces.config.processor.NavigationConfigProcessor addNavigationCasesForRule
AVISO: JSF1058: O recurso referido por to-view-id, 'cadastrarCategoria.jsp', para navegação de '*', não começa com '/'. Isso será adicionado para você, mas deveria ser corrigido.
30/08/2011 09:31:22 com.sun.faces.config.processor.NavigationConfigProcessor addNavigationCasesForRule
AVISO: JSF1058: O recurso referido por to-view-id, 'controlePagamento.jsp', para navegação de '*', não começa com '/'. Isso será adicionado para você, mas deveria ser corrigido.
30/08/2011 09:31:22 com.sun.faces.config.processor.NavigationConfigProcessor addNavigationCasesForRule
AVISO: JSF1058: O recurso referido por to-view-id, 'controlePercentual.jsp', para navegação de '*', não começa com '/'. Isso será adicionado para você, mas deveria ser corrigido.
30/08/2011 09:31:23 org.ajax4jsf.cache.CacheManager getCacheFactory
INFO: Selected [org.ajax4jsf.cache.LRUMapCacheFactory] cache factory
30/08/2011 09:31:23 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO: Creating LRUMap cache instance using parameters: {org.richfaces.CONTROL_SKINNING=enable, org.richfaces.SKIN=blueSky}
30/08/2011 09:31:23 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO: Creating LRUMap cache instance of default capacity
30/08/2011 09:31:23 org.ajax4jsf.cache.CacheManager getCacheFactory
INFO: Selected [org.ajax4jsf.cache.LRUMapCacheFactory] cache factory
30/08/2011 09:31:23 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO: Creating LRUMap cache instance using parameters: {org.richfaces.CONTROL_SKINNING=enable, org.richfaces.SKIN=blueSky}
30/08/2011 09:31:23 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO: Creating LRUMap cache instance of default capacity
30/08/2011 09:31:23 org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
30/08/2011 09:31:23 org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
30/08/2011 09:31:23 org.apache.catalina.startup.Catalina start
INFO: Server startup in 12099 ms
30/08/2011 09:31:49 org.apache.jasper.compiler.TldLocationsCache tldScanJar
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned where no TLDs were found. Skipping JAR scanning can improve startup time and JSP compilation time.
30/08/2011 09:31:55 org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.3.0.GA
30/08/2011 09:31:55 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
30/08/2011 09:31:55 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
30/08/2011 09:31:55 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
30/08/2011 09:31:55 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
30/08/2011 09:31:55 org.hibernate.ejb.Version <clinit>
INFO: Hibernate EntityManager 3.3.1.GA
30/08/2011 09:31:56 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: br.com.entun.entidade.Pagamento
30/08/2011 09:31:56 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity br.com.entun.entidade.Pagamento on table Pagamento
30/08/2011 09:31:56 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: br.com.entun.entidade.Usuario
30/08/2011 09:31:56 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity br.com.entun.entidade.Usuario on table Usuario
30/08/2011 09:31:56 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: br.com.entun.entidade.Periodo
30/08/2011 09:31:56 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity br.com.entun.entidade.Periodo on table Periodo
30/08/2011 09:31:56 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: br.com.entun.entidade.Categoria
30/08/2011 09:31:56 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity br.com.entun.entidade.Categoria on table Categoria
30/08/2011 09:31:56 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
30/08/2011 09:31:56 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
30/08/2011 09:31:56 org.ajax4jsf.webapp.BaseXMLFilter doXmlFilter
GRAVE: Exception in the filter chain
javax.servlet.ServletException: Servlet execution threw an exception
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:327)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ExceptionInInitializerError
at br.com.entun.dao.PagamentoDao.<init>(PagamentoDao.java:22)
at br.com.entun.control.PagamentoBean.<init>(PagamentoBean.java:40)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:185)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:105)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:368)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:222)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:86)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67)
at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:71)
at org.apache.el.parser.AstValue.getValue(AstValue.java:147)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:106)
at javax.faces.component.UIOutput.getValue(UIOutput.java:184)
at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:201)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:287)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:154)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:861)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:244)
at com.sun.faces.renderkit.html_basic.GridRenderer.renderRow(GridRenderer.java:180)
at com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:127)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:148)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:277)
at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:258)
at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:200)
at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:195)
at org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:120)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:236)
at com.sun.faces.renderkit.html_basic.GridRenderer.renderRow(GridRenderer.java:180)
at com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:127)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:100)
at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:176)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
... 22 more
Caused by: javax.persistence.PersistenceException: org.hibernate.MappingException: Could not determine type for: java.util.List, for columns: [org.hibernate.mapping.Column(percentuais)]
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:737)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:83)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:60)
at br.com.entun.util.Conexao.<clinit>(Conexao.java:9)
... 74 more
Caused by: org.hibernate.MappingException: Could not determine type for: java.util.List, for columns: [org.hibernate.mapping.Column(percentuais)]
at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:266)
at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:253)
at org.hibernate.mapping.Property.isValid(Property.java:185)
at org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:440)
at org.hibernate.mapping.RootClass.validate(RootClass.java:192)
at org.hibernate.cfg.Configuration.validate(Configuration.java:1102)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1287)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730)
... 78 more
30/08/2011 09:31:56 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [Faces Servlet] in context with path [/entun0.1] threw exception [Servlet execution threw an exception] with root cause
org.hibernate.MappingException: Could not determine type for: java.util.List, for columns: [org.hibernate.mapping.Column(percentuais)]
at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:266)
at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:253)
at org.hibernate.mapping.Property.isValid(Property.java:185)
at org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:440)
at org.hibernate.mapping.RootClass.validate(RootClass.java:192)
at org.hibernate.cfg.Configuration.validate(Configuration.java:1102)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1287)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:83)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:60)
at br.com.entun.util.Conexao.<clinit>(Conexao.java:9)
at br.com.entun.dao.PagamentoDao.<init>(PagamentoDao.java:22)
at br.com.entun.control.PagamentoBean.<init>(PagamentoBean.java:40)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:185)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:105)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:368)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:222)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:86)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67)
at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:71)
at org.apache.el.parser.AstValue.getValue(AstValue.java:147)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:106)
at javax.faces.component.UIOutput.getValue(UIOutput.java:184)
at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:201)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:287)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:154)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:861)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:244)
at com.sun.faces.renderkit.html_basic.GridRenderer.renderRow(GridRenderer.java:180)
at com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:127)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:148)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:277)
at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:258)
at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:200)
at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:195)
at org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:120)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:236)
at com.sun.faces.renderkit.html_basic.GridRenderer.renderRow(GridRenderer.java:180)
at com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:127)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:100)
at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:176)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[code]package br.com.entun.dao;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.Query;
import br.com.entun.entidade.Categoria;
import br.com.entun.entidade.Filtro;
import br.com.entun.entidade.Pagamento;
import br.com.entun.entidade.PagamentoParcelado;
import br.com.entun.util.Conexao;
public class PagamentoDao {
private EntityManager em = Conexao.getEntityManager();
public void inserir(Pagamento pagamento){
em.getTransaction().begin();
em.persist(pagamento);
em.getTransaction().commit();
}
public void inserir(PagamentoParcelado pagamentoParcelado){
for (int i = pagamentoParcelado.getNrParcelas(); i > 0; i--) {
Pagamento pagamento = new Pagamento();
Pagamento pag = pagamentoParcelado.getPagamento();
pagamento.setTipo(pag.getTipo());
pagamento.setValor(pag.getValor());
pagamento.setCategoria(pag.getCategoria());
pagamento.setDataPagamento(pag.getDataPagamento());
pagamento.setDataPrevista(pag.getDataPrevista());
pagamento.setDescricao(pag.getDescricao());
pagamentoParcelado.calcularJuros(pagamentoParcelado.getTipoJuros(), pagamento, pagamentoParcelado.getTaxa(), i - 1);
inserir(pagamento);
}
}
public void excluir(Pagamento pagamento){
em.getTransaction().begin();
em.remove(pagamento);
em.getTransaction().commit();
}
@SuppressWarnings("unchecked")
public List<Pagamento> consultar(){
Query query = em.createNativeQuery("select * from pagamento", Pagamento.class);
List<Pagamento> pagamentos = (List<Pagamento>) query.getResultList();
Collections.sort(pagamentos);
return pagamentos;
}
public Pagamento consultar(int id){
return em.find(Pagamento.class, id);
}
@SuppressWarnings("unchecked")
public List<Pagamento> consultarComFiltros(Filtro filtro){
Query query = em.createNativeQuery("select id, datapagamento, dataprevista, descricao, tipo, valor, pagamento_id, categoria_id " +
"from pagamento " +
"inner join pagamento_categoria on pagamento.id = pagamento_categoria.pagamento_id " +
"where dataprevista between :dataInicial and :dataFinal " +
"and valor between :valorInicial and :valorFinal and tipo like :tipo " +
"and pagamento.id = pagamento_categoria.pagamento_id " +
"and pagamento_categoria.categoria_id in (:categorias)"
,Pagamento.class);
List<Categoria> categs = filtro.getCategoriasSelecionadas();
List<Integer> categorias = new ArrayList<Integer>();
if (categs.size() > 0){
for (Categoria categoria : categs) {
categorias.add(categoria.getId());
}
}
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
if (filtro.getDataInicial() == null){
try {
filtro.setDataInicial(sdf.parse("01/01/1900"));
} catch (ParseException e) {
e.printStackTrace();
}
}
if (filtro.getDataFinal() == null){
try {
filtro.setDataInicial(sdf.parse("31/12/3000"));
} catch (ParseException e) {
e.printStackTrace();
}
}
query.setParameter("dataInicial", filtro.getDataInicial());
query.setParameter("dataFinal", filtro.getDataFinal());
query.setParameter("valorInicial", filtro.getValorInicial());
query.setParameter("valorFinal", filtro.getValorFinal());
query.setParameter("tipo", filtro.getTipoPagamentoSelecionado());
query.setParameter("categorias", categorias);
List<Pagamento> pagamentos = query.getResultList();
Pagamento pagamento = new Pagamento();
pagamentos = pagamento.limpaPagamentosDuplicados(pagamentos);
Collections.sort(pagamentos);
return pagamentos;
}
public BigDecimal somarValorPorTipo(List<Pagamento> pagamentos ,String tipo){
double soma = 0;
for (Pagamento pagamento : pagamentos) {
if (pagamento.getTipo().equals(tipo)){
soma += pagamento.getValor();
}
}
BigDecimal total = BigDecimal.valueOf(soma);
return total;
}
}
[/code]