Fórum Filter não retorna exception do hibernate #413015
20/02/2012
0
Bom dia Pessoal.
Não sei porque, mas o sistema simplesmente parou de tratar as exceptions que lanço;
Por exemplo, to forçando a exclusão de um estado que tem cidade vinculada, e aparece erro 500 na pagina, não volta para a tela de listagem com a mensagem que controlo no try catch do metodo excluir.
Abaixo segue os códigos das classe.
ConexaoHibernateFilter
EstadoDAOHibernate
Web xml
Debugando a aplicação, percebi que na classe ConexaoHibernateFilter, ele consegue fazer o roolback, mas o erro que é retornado em Throwable ex, não é o que esta sendo tratato no try catch do metodo excluir, e isso esta acontecendo para todos os metodos, por exemplo, eu forcei uma exception para testar os metodos de cadastrar, e tbm não retornou o erro tratado corretamente, o que poderia ser ????
Não sei porque, mas o sistema simplesmente parou de tratar as exceptions que lanço;
Por exemplo, to forçando a exclusão de um estado que tem cidade vinculada, e aparece erro 500 na pagina, não volta para a tela de listagem com a mensagem que controlo no try catch do metodo excluir.
Abaixo segue os códigos das classe.
ConexaoHibernateFilter
package classe.projeto.utils;
import javax.servlet.*;
import org.hibernate.SessionFactory;
import classe.projeto.utils.Conexao;
public class ConexaoHibernateFilter implements Filter {
private SessionFactory sf;
@Override
public void init(FilterConfig config) throws ServletException {
this.sf = Conexao.getSessionFactory();
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse,
FilterChain filterChain) throws ServletException {
try {
this.sf.getCurrentSession().beginTransaction();
filterChain.doFilter(servletRequest, servletResponse);
this.sf.getCurrentSession().getTransaction().commit();
this.sf.getCurrentSession().close();
} catch (Throwable ex) {
try {
if(this.sf.getCurrentSession().getTransaction().isActive()){
this.sf.getCurrentSession().getTransaction().rollback();
}
} catch (Throwable t) {
t.printStackTrace();
}
throw new ServletException(ex);
}finally{
this.sf.getCurrentSession().close();
}
}
@Override
public void destroy() {}
}
EstadoDAOHibernate
package classe.projeto.estado;
import java.util.List;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import classe.projeto.utils.DAOException;
import classe.projeto.utils.FiltroQuery;
import classe.projeto.utils.GlossarioMensagens;
import classe.projeto.utils.ValidaOrdenacaoLimit;
public class EstadoDAOHibernate implements EstadoDAO {
private Session session;
private String filtroQuery;
public void setSession(Session session){
this.session = session;
}
private void setFiltroQuery(Estado estado){
this.filtroQuery = FiltroQuery.FiltroQuery(estado);
}
@Override
public void Salvar(Estado estado) throws DAOException {
this.session.flush();
this.session.clear();
if (estado.getEstadoID() == null ){
try {
this.session.save(estado);
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG04());
}
}else{
try {
this.session.update(estado);
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG05());
}
}
}
@Override
public void Excluir(Estado estado) throws DAOException{
this.session.flush();
this.session.clear();
try {
this.session.delete(estado);
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG06());
}
}
@SuppressWarnings(deprecation)
@Override
public Integer TotalRegistros() {
String sql = SELECT COUNT(*) AS totalRegistros FROM vwlistaestado ;
Query consulta = this.session.createSQLQuery(sql).addScalar(totalRegistros, Hibernate.INTEGER);
Integer totalRegistros = (Integer) consulta.uniqueResult();
return totalRegistros;
}
@Override
public Estado Obter(Estado estado) {
this.setFiltroQuery(estado);
String sql = SELECT * FROM vwlistaestado + this.filtroQuery ;
Query consulta = this.session.createSQLQuery(sql).addEntity(Estado.class);
return (Estado) consulta.uniqueResult();
}
@SuppressWarnings(unchecked)
@Override
public List<Estado> Pesquisar(Estado estado, String campoOrdenacao, String ordenacao, Integer pagina, Integer limit) {
this.setFiltroQuery(estado);
String sql = SELECT * FROM vwlistaestado + this.filtroQuery;
sql = ValidaOrdenacaoLimit.ValidaOrdenacaoLimit(sql, campoOrdenacao, ordenacao, pagina, limit);
Query consulta = this.session.createSQLQuery(sql).addEntity(Estado.class);
List<Estado> listaEstado = consulta.list();
return listaEstado;
}
}
Web xml
<?xml version=1.0?>
<web-app version=3.0 xmlns=http://java.sun.com/xml/ns/j2ee
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
xsi:schemaLocation=http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_3_0.xsd>
<display-name>projeto</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<!-- JSF e PrimeFaces -->
<servlet>
<servlet-name>Faces Servlet</servlet-name>
<servlet-class>javax.faces.webapp.FacesServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>Faces Servlet</servlet-name>
<url-pattern>*.html</url-pattern>
</servlet-mapping>
<context-param>
<param-name>primefaces.THEME</param-name>
<param-value>cupertino</param-value>
</context-param>
<!-- Upload de Arquivos com PrimeFaces -->
<filter>
<filter-name>PrimeFaces FileUpload Filter</filter-name>
<filter-class>org.primefaces.webapp.filter.FileUploadFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>PrimeFaces FileUpload Filter</filter-name>
<servlet-name>Faces Servlet</servlet-name>
</filter-mapping>
<context-param>
<param-name>com.sun.faces.expressionFactory</param-name>
<param-value>com.sun.el.ExpressionFactoryImpl</param-value>
</context-param>
<!-- Conexao Filter -->
<context-param>
<param-name>javax.servlet.jsp.jstl.fmt.localizationContext</param-name>
<param-value>resources.application</param-value>
</context-param>
<listener>
<listener-class>com.sun.faces.config.ConfigureListener</listener-class>
</listener>
<filter>
<filter-name>conexaoFilter</filter-name>
<filter-class>classe.projeto.utils.ConexaoHibernateFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>conexaoFilter</filter-name>
<url-pattern>*.html</url-pattern>
</filter-mapping>
<!-- Spring Security -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>
/WEB-INF/applicationContext.xml
/WEB-INF/applicationContext-security.xml
</param-value>
</context-param>
<resource-ref>
<description>DataSource projeto</description>
<res-ref-name>jdbc/projeto</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<filter>
<filter-name>springSecurityFilterChain</filter-name>
<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>
<filter-mapping>
<filter-name>springSecurityFilterChain</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
</web-app>
Debugando a aplicação, percebi que na classe ConexaoHibernateFilter, ele consegue fazer o roolback, mas o erro que é retornado em Throwable ex, não é o que esta sendo tratato no try catch do metodo excluir, e isso esta acontecendo para todos os metodos, por exemplo, eu forcei uma exception para testar os metodos de cadastrar, e tbm não retornou o erro tratado corretamente, o que poderia ser ????
Daniel Everling
Curtir tópico
+ 0
Responder
Posts
21/02/2012
Daniel Everling
pessoal, esse erro eu consegui resolver agora estou tomando outro erro, abaixo segue o log do console
ah linha que mais me chama a atenção é esta
21/02/2012 21:22:17 com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
GRAVE: Error Rendering View[/gerenciador/content/estado/index.xhtml]
alguma ideia ?
ah linha que mais me chama a atenção é esta
21/02/2012 21:22:17 com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
GRAVE: Error Rendering View[/gerenciador/content/estado/index.xhtml]
21:22:14.622 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665346
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:14.622 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:14.623 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/content/login/login.html
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/comum/**
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/**
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Public object - authentication not attempted
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino reached end of additional filter chain; proceeding with original chain
21:22:14.626 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.ExceptionTranslationFilter - Chain processed normally
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - commit
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - committed JDBC Connection
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665346
21:22:16.291 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665362
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:16.291 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/content/login/login.html
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/comum/**
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/**
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Secure object: FilterInvocation: URL: /gerenciador/content/estado/index.html; Attributes: [ROLE_ADMINISTRADOR, ROLE_NUTRICIONISTA]
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.access.vote.AffirmativeBased - Voter: org.springframework.security.access.vote.RoleVoter@1adc5f7, returned: 1
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Authorization successful
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - RunAsManager did not change Authentication object
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html reached end of additional filter chain; proceeding with original chain
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.ExceptionTranslationFilter - Chain processed normally
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - commit
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - committed JDBC Connection
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665363
21:22:17.084 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665370
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:17.084 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/content/login/login.html
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/comum/**
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/**
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Secure object: FilterInvocation: URL: /gerenciador/content/estado/index.html; Attributes: [ROLE_ADMINISTRADOR, ROLE_NUTRICIONISTA]
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.access.vote.AffirmativeBased - Voter: org.springframework.security.access.vote.RoleVoter@1adc5f7, returned: 1
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Authorization successful
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - RunAsManager did not change Authentication object
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html reached end of additional filter chain; proceeding with original chain
21:22:17.096 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - processing flush-time cascades
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - dirty checking collections
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 1 deletions to 1 objects
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.pretty.Printer - listing entities:
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.pretty.Printer - classe.projeto.estado.Estado{estadoID=1, nome=Rio Grande do Sul}
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.SQL -
delete
from
estado
where
estadoID=?
Hibernate:
delete
from
estado
where
estadoID=?
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
21:22:17.099 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:22:17.102 [http-bio-8080-exec-4] DEBUG o.h.util.JDBCExceptionReporter - Could not execute JDBC batch update [delete from estado where estadoID=?]
java.sql.BatchUpdateException: Entrada em lote 0 delete from estado where estadoID=1 foi abortada. Chame getNextException para ver a causa.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:459) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[tomcat-dbcp.jar:7.0.25]
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[tomcat-dbcp.jar:7.0.25]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) [hibernate3.jar:3.6.5.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189) [hibernate3.jar:3.6.5.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) [hibernate3.jar:3.6.5.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) [hibernate3.jar:3.6.5.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_29]
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345) [hibernate3.jar:3.6.5.Final]
at $Proxy28.flush(Unknown Source) [na:na]
at classe.projeto.estado.EstadoDAOHibernate.Excluir(EstadoDAOHibernate.java:52) [EstadoDAOHibernate.class:na]
at classe.projeto.estado.EstadoRN.Excluir(EstadoRN.java:28) [EstadoRN.class:na]
at classe.projeto.bean.EstadoListagemBean.Excluir(EstadoListagemBean.java:73) [EstadoListagemBean.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_29]
at com.sun.el.parser.AstValue.invoke(AstValue.java:234) [el-impl-2.2.jar:na]
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297) [el-impl-2.2.jar:na]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.UICommand.broadcast(UICommand.java:315) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593) [jsf-api.jar:2.1.2-FCS]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) [primefaces-2.2.1.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29) [ConexaoHibernateFilter.class:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.25]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.25]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.25]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.25]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.25]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) [tomcat-coyote.jar:7.0.25]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.25]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) [tomcat-coyote.jar:7.0.25]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_29]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_29]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_29]
21:22:17.103 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23503
21:22:17.103 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - Entrada em lote 0 delete from estado where estadoID=1 foi abortada. Chame getNextException para ver a causa.
21:22:17.103 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23503
21:22:17.103 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - ERROR: update or delete on table estado violates foreign key constraint relestadocidade on table cidade
Detalhe: Key (estadoid)=(1) is still referenced from table cidade.
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.SQL -
SELECT
*
FROM
vwlistausuario vw
WHERE
vw.login = ?
Hibernate:
SELECT
*
FROM
vwlistausuario vw
WHERE
vw.login = ?
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.loader.Loader - bindNamedParameters() deverling -> login [1]
21:22:17.121 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:22:17.126 [http-bio-8080-exec-4] DEBUG o.h.util.JDBCExceptionReporter - could not execute query [SELECT * FROM vwlistausuario vw WHERE vw.login = ? ]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[tomcat-dbcp.jar:7.0.25]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[tomcat-dbcp.jar:7.0.25]
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:802) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2533) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.list(Loader.java:2271) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) [hibernate3.jar:3.6.5.Final]
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46) [UsuarioDAOHibernate.class:na]
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32) [UsuarioRN.class:na]
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26) [ContextoBean.class:na]
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78) [MenuBean.class:na]
at classe.projeto.bean.MenuBean.<init>(MenuBean.java:27) [MenuBean.class:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.6.0_29]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [na:1.6.0_29]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [na:1.6.0_29]
at java.lang.reflect.Constructor.newInstance(Unknown Source) [na:1.6.0_29]
at java.lang.Class.newInstance0(Unknown Source) [na:1.6.0_29]
at java.lang.Class.newInstance(Unknown Source) [na:1.6.0_29]
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203) [jsf-impl.jar:2.1.2-FCS]
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99) [el-impl-2.2.jar:na]
at com.sun.el.parser.AstValue.getValue(AstValue.java:158) [el-impl-2.2.jar:na]
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219) [el-impl-2.2.jar:na]
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92) [primefaces-2.2.1.jar:na]
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28) [primefaces-2.2.1.jar:na]
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594) [jsf-api.jar:2.1.2-FCS]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) [primefaces-2.2.1.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29) [ConexaoHibernateFilter.class:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.25]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.25]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.25]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.25]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.25]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) [tomcat-coyote.jar:7.0.25]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.25]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) [tomcat-coyote.jar:7.0.25]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_29]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_29]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_29]
21:22:17.127 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
21:22:17.127 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - ERROR: current transaction is aborted, commands ignored until end of transaction block
21/02/2012 21:22:17 com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
GRAVE: Error Rendering View[/gerenciador/content/estado/index.xhtml]
com.sun.faces.mgbean.ManagedBeanCreationException: Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:193)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269)
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
at com.sun.el.parser.AstValue.getValue(AstValue.java:158)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92)
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28)
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29)
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:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46)
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32)
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26)
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78)
at classe.projeto.bean.MenuBean.<init>(MenuBean.java:27)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188)
... 82 more
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 101 more
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - rollback
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - rolled back JDBC Connection
21:22:17.130 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:17.130 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:17.131 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665371
21/02/2012 21:22:17 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [Faces Servlet] in context with path [/projeto] threw exception [javax.servlet.ServletException: Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.] with root cause
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46)
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32)
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26)
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78)
at classe.projeto.bean.MenuBean.<init>(MenuBean.java:27)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269)
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
at com.sun.el.parser.AstValue.getValue(AstValue.java:158)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92)
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28)
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29)
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:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
alguma ideia ?
Responder
Gostei + 0
22/02/2012
Robson Teixeira
Kra posta o log novamente mas sem o formatador de codigo pliz???
Responder
Gostei + 0
22/02/2012
Daniel Everling
Segue
21:22:14.622 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665346
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:14.622 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:14.623 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/content/login/login.html
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/comum/**
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/**
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Public object - authentication not attempted
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino reached end of additional filter chain; proceeding with original chain
21:22:14.626 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.ExceptionTranslationFilter - Chain processed normally
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - commit
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - committed JDBC Connection
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665346
21:22:16.291 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665362
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:16.291 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/content/login/login.html
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/comum/**
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/**
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Secure object: FilterInvocation: URL: /gerenciador/content/estado/index.html; Attributes: [ROLE_ADMINISTRADOR, ROLE_NUTRICIONISTA]
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.access.vote.AffirmativeBased - Voter: org.springframework.security.access.vote.RoleVoter@1adc5f7, returned: 1
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Authorization successful
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - RunAsManager did not change Authentication object
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html reached end of additional filter chain; proceeding with original chain
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.ExceptionTranslationFilter - Chain processed normally
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - commit
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - committed JDBC Connection
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665363
21:22:17.084 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665370
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:17.084 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/content/login/login.html
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/comum/**
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/**
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Secure object: FilterInvocation: URL: /gerenciador/content/estado/index.html; Attributes: [ROLE_ADMINISTRADOR, ROLE_NUTRICIONISTA]
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.access.vote.AffirmativeBased - Voter: org.springframework.security.access.vote.RoleVoter@1adc5f7, returned: 1
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Authorization successful
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - RunAsManager did not change Authentication object
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html reached end of additional filter chain; proceeding with original chain
21:22:17.096 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - processing flush-time cascades
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - dirty checking collections
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 1 deletions to 1 objects
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.pretty.Printer - listing entities:
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.pretty.Printer - classe.projeto.estado.Estado{estadoID=1, nome=Rio Grande do Sul}
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.SQL -
delete
from
estado
where
estadoID=?
Hibernate:
delete
from
estado
where
estadoID=?
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
21:22:17.099 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:22:17.102 [http-bio-8080-exec-4] DEBUG o.h.util.JDBCExceptionReporter - Could not execute JDBC batch update [delete from estado where estadoID=?]
java.sql.BatchUpdateException: Entrada em lote 0 delete from estado where estadoID=1 foi abortada. Chame getNextException para ver a causa.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:459) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[tomcat-dbcp.jar:7.0.25]
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[tomcat-dbcp.jar:7.0.25]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) [hibernate3.jar:3.6.5.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189) [hibernate3.jar:3.6.5.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) [hibernate3.jar:3.6.5.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) [hibernate3.jar:3.6.5.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_29]
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345) [hibernate3.jar:3.6.5.Final]
at $Proxy28.flush(Unknown Source) [na:na]
at classe.projeto.estado.EstadoDAOHibernate.Excluir(EstadoDAOHibernate.java:52) [EstadoDAOHibernate.class:na]
at classe.projeto.estado.EstadoRN.Excluir(EstadoRN.java:28) [EstadoRN.class:na]
at classe.projeto.bean.EstadoListagemBean.Excluir(EstadoListagemBean.java:73) [EstadoListagemBean.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_29]
at com.sun.el.parser.AstValue.invoke(AstValue.java:234) [el-impl-2.2.jar:na]
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297) [el-impl-2.2.jar:na]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.UICommand.broadcast(UICommand.java:315) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593) [jsf-api.jar:2.1.2-FCS]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) [primefaces-2.2.1.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29) [ConexaoHibernateFilter.class:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.25]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.25]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.25]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.25]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.25]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) [tomcat-coyote.jar:7.0.25]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.25]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) [tomcat-coyote.jar:7.0.25]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_29]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_29]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_29]
21:22:17.103 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23503
21:22:17.103 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - Entrada em lote 0 delete from estado where estadoID=1 foi abortada. Chame getNextException para ver a causa.
21:22:17.103 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23503
21:22:17.103 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - ERROR: update or delete on table estado violates foreign key constraint relestadocidade on table cidade
Detalhe: Key (estadoid)=(1) is still referenced from table cidade.
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.SQL -
SELECT
*
FROM
vwlistausuario vw
WHERE
vw.login = ?
Hibernate:
SELECT
*
FROM
vwlistausuario vw
WHERE
vw.login = ?
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.loader.Loader - bindNamedParameters() deverling -> login [1]
21:22:17.121 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:22:17.126 [http-bio-8080-exec-4] DEBUG o.h.util.JDBCExceptionReporter - could not execute query [SELECT * FROM vwlistausuario vw WHERE vw.login = ? ]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[tomcat-dbcp.jar:7.0.25]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[tomcat-dbcp.jar:7.0.25]
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:802) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2533) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.list(Loader.java:2271) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) [hibernate3.jar:3.6.5.Final]
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46) [UsuarioDAOHibernate.class:na]
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32) [UsuarioRN.class:na]
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26) [ContextoBean.class:na]
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78) [MenuBean.class:na]
at classe.projeto.bean.MenuBean.(MenuBean.java:27) [MenuBean.class:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.6.0_29]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [na:1.6.0_29]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [na:1.6.0_29]
at java.lang.reflect.Constructor.newInstance(Unknown Source) [na:1.6.0_29]
at java.lang.Class.newInstance0(Unknown Source) [na:1.6.0_29]
at java.lang.Class.newInstance(Unknown Source) [na:1.6.0_29]
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203) [jsf-impl.jar:2.1.2-FCS]
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99) [el-impl-2.2.jar:na]
at com.sun.el.parser.AstValue.getValue(AstValue.java:158) [el-impl-2.2.jar:na]
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219) [el-impl-2.2.jar:na]
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92) [primefaces-2.2.1.jar:na]
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28) [primefaces-2.2.1.jar:na]
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594) [jsf-api.jar:2.1.2-FCS]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) [primefaces-2.2.1.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29) [ConexaoHibernateFilter.class:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.25]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.25]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.25]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.25]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.25]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) [tomcat-coyote.jar:7.0.25]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.25]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) [tomcat-coyote.jar:7.0.25]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_29]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_29]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_29]
21:22:17.127 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
21:22:17.127 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - ERROR: current transaction is aborted, commands ignored until end of transaction block
21/02/2012 21:22:17 com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
GRAVE: Error Rendering View[/gerenciador/content/estado/index.xhtml]
com.sun.faces.mgbean.ManagedBeanCreationException: Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:193)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269)
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
at com.sun.el.parser.AstValue.getValue(AstValue.java:158)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92)
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28)
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29)
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:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46)
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32)
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26)
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78)
at classe.projeto.bean.MenuBean.(MenuBean.java:27)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188)
... 82 more
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 101 more
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - rollback
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - rolled back JDBC Connection
21:22:17.130 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:17.130 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:17.131 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665371
21/02/2012 21:22:17 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [Faces Servlet] in context with path [/projeto] threw exception [javax.servlet.ServletException: Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.] with root cause
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46)
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32)
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26)
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78)
at classe.projeto.bean.MenuBean.(MenuBean.java:27)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269)
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
at com.sun.el.parser.AstValue.getValue(AstValue.java:158)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92)
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28)
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29)
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:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
21:22:14.622 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665346
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:14.622 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:14.622 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:14.623 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/content/login/login.html
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/comum/**
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html; against /gerenciador/**
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Public object - authentication not attempted
21:22:14.624 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /javax.faces.resource/images/ui-icons_2694e8_256x240.png.html?ln=primefaces-cupertino reached end of additional filter chain; proceeding with original chain
21:22:14.626 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.ExceptionTranslationFilter - Chain processed normally
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - commit
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:14.627 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - committed JDBC Connection
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:14.627 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665346
21:22:16.291 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665362
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:16.291 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:16.291 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:16.292 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/content/login/login.html
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/comum/**
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/**
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Secure object: FilterInvocation: URL: /gerenciador/content/estado/index.html; Attributes: [ROLE_ADMINISTRADOR, ROLE_NUTRICIONISTA]
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.access.vote.AffirmativeBased - Voter: org.springframework.security.access.vote.RoleVoter@1adc5f7, returned: 1
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Authorization successful
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - RunAsManager did not change Authentication object
21:22:16.293 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html reached end of additional filter chain; proceeding with original chain
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.ExceptionTranslationFilter - Chain processed normally
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - commit
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:16.323 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - committed JDBC Connection
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:16.324 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665363
21:22:17.084 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665370
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - begin
21:22:17.084 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - current autocommit status: true
21:22:17.084 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - disabling autocommit
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 1 of 9 in additional filter chain; firing Filter: SecurityContextPersistenceFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.HttpSessionSecurityContextRepository - Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: org.springframework.security.core.context.SecurityContextImpl@6abd63dc: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 2 of 9 in additional filter chain; firing Filter: LogoutFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 3 of 9 in additional filter chain; firing Filter: UsernamePasswordAuthenticationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 4 of 9 in additional filter chain; firing Filter: RequestCacheAwareFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 5 of 9 in additional filter chain; firing Filter: SecurityContextHolderAwareRequestFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 6 of 9 in additional filter chain; firing Filter: AnonymousAuthenticationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.AnonymousAuthenticationFilter - SecurityContextHolder not populated with anonymous token, as it already contained: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 7 of 9 in additional filter chain; firing Filter: SessionManagementFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 8 of 9 in additional filter chain; firing Filter: ExceptionTranslationFilter
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html at position 9 of 9 in additional filter chain; firing Filter: FilterSecurityInterceptor
21:22:17.085 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/content/login/login.html
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/comum/**
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.web.util.AntPathRequestMatcher - Checking match of request : /gerenciador/content/estado/index.html; against /gerenciador/**
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Secure object: FilterInvocation: URL: /gerenciador/content/estado/index.html; Attributes: [ROLE_ADMINISTRADOR, ROLE_NUTRICIONISTA]
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Previously Authenticated: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@6abd63dc: Principal: org.springframework.security.core.userdetails.User@fb83fe78: Username: deverling; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMINISTRADOR; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 9F13AE4088E4C4A72123E9E3340ED2C3; Granted Authorities: ROLE_ADMINISTRADOR
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.access.vote.AffirmativeBased - Voter: org.springframework.security.access.vote.RoleVoter@1adc5f7, returned: 1
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - Authorization successful
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.s.w.a.i.FilterSecurityInterceptor - RunAsManager did not change Authentication object
21:22:17.086 [http-bio-8080-exec-4] DEBUG o.s.security.web.FilterChainProxy - /gerenciador/content/estado/index.html reached end of additional filter chain; proceeding with original chain
21:22:17.096 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - processing flush-time cascades
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - dirty checking collections
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 1 deletions to 1 objects
21:22:17.097 [http-bio-8080-exec-4] DEBUG o.h.e.d.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.pretty.Printer - listing entities:
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.pretty.Printer - classe.projeto.estado.Estado{estadoID=1, nome=Rio Grande do Sul}
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.SQL -
delete
from
estado
where
estadoID=?
Hibernate:
delete
from
estado
where
estadoID=?
21:22:17.097 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
21:22:17.099 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:22:17.102 [http-bio-8080-exec-4] DEBUG o.h.util.JDBCExceptionReporter - Could not execute JDBC batch update [delete from estado where estadoID=?]
java.sql.BatchUpdateException: Entrada em lote 0 delete from estado where estadoID=1 foi abortada. Chame getNextException para ver a causa.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:459) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[tomcat-dbcp.jar:7.0.25]
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[tomcat-dbcp.jar:7.0.25]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) [hibernate3.jar:3.6.5.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189) [hibernate3.jar:3.6.5.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) [hibernate3.jar:3.6.5.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) [hibernate3.jar:3.6.5.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_29]
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345) [hibernate3.jar:3.6.5.Final]
at $Proxy28.flush(Unknown Source) [na:na]
at classe.projeto.estado.EstadoDAOHibernate.Excluir(EstadoDAOHibernate.java:52) [EstadoDAOHibernate.class:na]
at classe.projeto.estado.EstadoRN.Excluir(EstadoRN.java:28) [EstadoRN.class:na]
at classe.projeto.bean.EstadoListagemBean.Excluir(EstadoListagemBean.java:73) [EstadoListagemBean.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_29]
at com.sun.el.parser.AstValue.invoke(AstValue.java:234) [el-impl-2.2.jar:na]
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297) [el-impl-2.2.jar:na]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.UICommand.broadcast(UICommand.java:315) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593) [jsf-api.jar:2.1.2-FCS]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) [primefaces-2.2.1.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29) [ConexaoHibernateFilter.class:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.25]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.25]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.25]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.25]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.25]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) [tomcat-coyote.jar:7.0.25]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.25]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) [tomcat-coyote.jar:7.0.25]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_29]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_29]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_29]
21:22:17.103 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23503
21:22:17.103 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - Entrada em lote 0 delete from estado where estadoID=1 foi abortada. Chame getNextException para ver a causa.
21:22:17.103 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23503
21:22:17.103 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - ERROR: update or delete on table estado violates foreign key constraint relestadocidade on table cidade
Detalhe: Key (estadoid)=(1) is still referenced from table cidade.
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.SQL -
SELECT
*
FROM
vwlistausuario vw
WHERE
vw.login = ?
Hibernate:
SELECT
*
FROM
vwlistausuario vw
WHERE
vw.login = ?
21:22:17.120 [http-bio-8080-exec-4] DEBUG org.hibernate.loader.Loader - bindNamedParameters() deverling -> login [1]
21:22:17.121 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:22:17.126 [http-bio-8080-exec-4] DEBUG o.h.util.JDBCExceptionReporter - could not execute query [SELECT * FROM vwlistausuario vw WHERE vw.login = ? ]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) ~[postgresql-9.0-801.jdbc4.jar:na]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[tomcat-dbcp.jar:7.0.25]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[tomcat-dbcp.jar:7.0.25]
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:802) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2533) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.Loader.list(Loader.java:2271) [hibernate3.jar:3.6.5.Final]
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) [hibernate3.jar:3.6.5.Final]
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) [hibernate3.jar:3.6.5.Final]
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46) [UsuarioDAOHibernate.class:na]
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32) [UsuarioRN.class:na]
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26) [ContextoBean.class:na]
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78) [MenuBean.class:na]
at classe.projeto.bean.MenuBean.(MenuBean.java:27) [MenuBean.class:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.6.0_29]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [na:1.6.0_29]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [na:1.6.0_29]
at java.lang.reflect.Constructor.newInstance(Unknown Source) [na:1.6.0_29]
at java.lang.Class.newInstance0(Unknown Source) [na:1.6.0_29]
at java.lang.Class.newInstance(Unknown Source) [na:1.6.0_29]
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203) [jsf-impl.jar:2.1.2-FCS]
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99) [el-impl-2.2.jar:na]
at com.sun.el.parser.AstValue.getValue(AstValue.java:158) [el-impl-2.2.jar:na]
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219) [el-impl-2.2.jar:na]
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92) [primefaces-2.2.1.jar:na]
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28) [primefaces-2.2.1.jar:na]
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59) [primefaces-2.2.1.jar:na]
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43) [primefaces-2.2.1.jar:na]
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44) [primefaces-2.2.1.jar:na]
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759) [jsf-api.jar:2.1.2-FCS]
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759) [jsf-api.jar:2.1.2-FCS]
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl.jar:2.1.2-FCS]
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) [jsf-impl.jar:2.1.2-FCS]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594) [jsf-api.jar:2.1.2-FCS]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) [primefaces-2.2.1.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175) [spring-security-web-3.1.0.RC2.jar:3.1.0.RC2]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [spring-web-3.0.5.RELEASE.jar:3.0.5.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29) [ConexaoHibernateFilter.class:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.25]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.25]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.25]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.25]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.25]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.25]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.25]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) [tomcat-coyote.jar:7.0.25]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.25]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) [tomcat-coyote.jar:7.0.25]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_29]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_29]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_29]
21:22:17.127 [http-bio-8080-exec-4] WARN o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
21:22:17.127 [http-bio-8080-exec-4] ERROR o.h.util.JDBCExceptionReporter - ERROR: current transaction is aborted, commands ignored until end of transaction block
21/02/2012 21:22:17 com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
GRAVE: Error Rendering View[/gerenciador/content/estado/index.xhtml]
com.sun.faces.mgbean.ManagedBeanCreationException: Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:193)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269)
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
at com.sun.el.parser.AstValue.getValue(AstValue.java:158)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92)
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28)
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29)
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:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46)
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32)
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26)
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78)
at classe.projeto.bean.MenuBean.(MenuBean.java:27)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188)
... 82 more
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 101 more
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.s.s.w.c.SecurityContextPersistenceFilter - SecurityContextHolder now cleared, as request processing completed
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - rollback
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - re-enabling autocommit
21:22:17.130 [http-bio-8080-exec-4] DEBUG o.h.transaction.JDBCTransaction - rolled back JDBC Connection
21:22:17.130 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
21:22:17.130 [http-bio-8080-exec-4] DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:22:17.131 [http-bio-8080-exec-4] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 13298665371
21/02/2012 21:22:17 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [Faces Servlet] in context with path [/projeto] threw exception [javax.servlet.ServletException: Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.] with root cause
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at classe.projeto.usuario.UsuarioDAOHibernate.Obter(UsuarioDAOHibernate.java:46)
at classe.projeto.usuario.UsuarioRN.Obter(UsuarioRN.java:32)
at classe.projeto.bean.ContextoBean.getUsuarioLogado(ContextoBean.java:26)
at classe.projeto.bean.MenuBean.UsuarioLogado(MenuBean.java:78)
at classe.projeto.bean.MenuBean.(MenuBean.java:27)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:188)
at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:102)
at com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409)
at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269)
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
at com.sun.el.parser.AstValue.getValue(AstValue.java:158)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at org.primefaces.component.menubar.Menubar.getModel(Menubar.java:92)
at org.primefaces.component.menu.AbstractMenu.buildMenuFromModel(AbstractMenu.java:28)
at org.primefaces.component.menu.BaseMenuRenderer.encodeEnd(BaseMenuRenderer.java:34)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:57)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:401)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:328)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:340)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at classe.projeto.utils.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:29)
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:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Responder
Gostei + 0
23/02/2012
Daniel Everling
Pessoal alguma ideia ?
Responder
Gostei + 0
23/02/2012
Daniel Everling
Pessoal um detalhe que reparei agora.
Quando tenho sucesso para exclusao ou adição de algo funciona.
Se eu excluir um estado sem cidade vinculadas ele retorna certinho para a tela e mostra a mensagem de sucesso, o problema ocorre quando trato uma exceção...
Não sei mais o que pode ser...
Quando tenho sucesso para exclusao ou adição de algo funciona.
Se eu excluir um estado sem cidade vinculadas ele retorna certinho para a tela e mostra a mensagem de sucesso, o problema ocorre quando trato uma exceção...
Não sei mais o que pode ser...
Responder
Gostei + 0
23/02/2012
Davi Costa
Provavelmente é isso mesmo, vc precisa primeiro apagar todas as cidades do estado antes de apagar o estado.
att Davi
att Davi
Responder
Gostei + 0
23/02/2012
Daniel Everling
Pois eh eu não posso apagar aquele estado, o certo era voltar para a tela de listagem de estado com a mensagem que esta sendo lançada no método Excluir da classe EstadoDAOHibernate.
Como disse antes isso funcionava, mas simplesmente parou de funcionar
Quando debugo passo a passo a aplicação, ele entra no catch no bean certinho, passa pelo FacesContext, monta a mensagem no FacesMessage, tudo certo, sem dar problemas
Mas na hora de dar o return com “/caminho/pagina” o erro ocorre, como falei, quando o metodo executa certinho, tudo aparece certinho, mensagens de sucesso, tudo ok, o problema parece ser em lançar a ServletException, mas não entendo o porque.
Como disse antes isso funcionava, mas simplesmente parou de funcionar
Quando debugo passo a passo a aplicação, ele entra no catch no bean certinho, passa pelo FacesContext, monta a mensagem no FacesMessage, tudo certo, sem dar problemas
Mas na hora de dar o return com “/caminho/pagina” o erro ocorre, como falei, quando o metodo executa certinho, tudo aparece certinho, mensagens de sucesso, tudo ok, o problema parece ser em lançar a ServletException, mas não entendo o porque.
Responder
Gostei + 0
23/02/2012
Davi Costa
Parace que por conta dessa exceção ele dá um erro em algum get depois (retirado do seu log).
Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.] with root cause
Essa exceção é para ser ServletException mesmo? Sua camada de Serviço deve lançar uma exceção de regra de negócio e o seu ManagedBean capturar a exceção e passar a mensagem para o usuário em tela. De repente se vc mandar sua classe Controller fique mais fácil visualizar.
att Davi
Não é possível criar instância para·a classe: classe.projeto.bean.MenuBean.] with root cause
Essa exceção é para ser ServletException mesmo? Sua camada de Serviço deve lançar uma exceção de regra de negócio e o seu ManagedBean capturar a exceção e passar a mensagem para o usuário em tela. De repente se vc mandar sua classe Controller fique mais fácil visualizar.
att Davi
Responder
Gostei + 0
23/02/2012
Daniel Everling
Segue
Listagem (XHTML)
<?xml version=1.0 encoding=ISO-8859-1?>
<!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd>
<html xmlns=http://www.w3.org/1999/xhtml
xmlns:ui=http://java.sun.com/jsf/facelets
xmlns:h=http://java.sun.com/jsf/html
xmlns:f=http://java.sun.com/jsf/core
xmlns:p=http://primefaces.prime.com.tr/ui>
<h:body>
<ui:insert name=boxTopo>
<ui:include src=../../comum/estrutura/topo.xhtml />
</ui:insert>
<div class=boxCorpo>
<div class=corpo>
<ui:insert name=boxMenu>
<ui:include src=../../comum/estrutura/menu.xhtml />
</ui:insert>
<div class=boxAbas>
<h:outputLink styleClass=btAbaPesquisar title=Pesquisar>Pesquisar</h:outputLink>
<h:outputLink styleClass=btAbaCadastrar title=Cadastrar>Cadastrar</h:outputLink>
</div>
<div class=boxConteudo>
<h:form id=FormListagem prependId=false>
<p:dataTable var=estado value=#{EstadoListagemBean.lazyModel}
paginator=true rows=30
paginatorTemplate=
rowsPerPageTemplate=30,45,60 lazy=true dynamic=true
onRowSelectUpdate=display selection=#{EstadoListagemBean.estadoSelecionados} emptyMessage=#{MensagemBean.mensagemNenhumRegistroEncontado}>
<p:column selectionMode=multiple />
<p:column sortBy=#{estado.nome}
styleClass=tblListagemProjeto>
<f:facet name=header>
<h:outputText value=Nome />
</f:facet>
<h:outputText value=#{estado.nome} />
</p:column>
<p:column styleClass=tblListagemProjeto tdEditar>
<f:facet name=header>
<h:outputText value=Editar/>
</f:facet>
<h:commandLink action=#{EstadoCadastroBean.Editar}>
<h:graphicImage url=../../comum/img/edit.png/>
<f:setPropertyActionListener target=#{EstadoCadastroBean.estado} value=# />
</h:commandLink>
</p:column>
<f:facet name=footer>
<p:commandButton id=btnExcluir value=Excluir oncomplete=confirmDeleteDialog.show() />
</f:facet>
</p:dataTable>
<p:confirmDialog message=#{MensagemBean.mensagemDesejaExcluir} width=400 header=Excluir Registros severity=alert widgetVar=confirmDeleteDialog>
<p:commandButton value=Sim action=#{EstadoListagemBean.Excluir} oncomplete=confirmDeleteDialog.hide() ajax=false update=boxMensagemValidacao />
<p:commandButton value=Cancelar onclick=confirmDeleteDialog.hide() type=button />
</p:confirmDialog>
</h:form>
<h:messages id=boxMensagemValidacao globalOnly=true/>
</div>
</div>
</div>
<ui:insert name=boxRodape>
<ui:include src=../../comum/estrutura/rodape.xhtml />
</ui:insert>
</h:body>
</html>
EstadoListagemBean
package classe.projeto.bean;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import javax.annotation.PostConstruct;
import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import org.primefaces.model.LazyDataModel;
import classe.projeto.estado.Estado;
import classe.projeto.estado.EstadoRN;
import classe.projeto.utils.GlossarioMensagens;
import classe.projeto.utils.GlossarioTexto;
import classe.projeto.utils.RNException;
@ManagedBean(name=EstadoListagemBean)
@ViewScoped
public class EstadoListagemBean {
private Estado estado = new Estado();
private Estado[] estadoSelecionados;
private LazyDataModel<Estado> lazyModel;
public EstadoListagemBean(){
this.CarregaLazyDataModel();
}
@PostConstruct
private void CarregaLazyDataModel() {
EstadoRN estadoRN = new EstadoRN();
this.lazyModel = new LazyDataModel<Estado>() {
private static final long serialVersionUID = 1829143374090645173L;
@Override
public List<Estado> load(int first, int pageSize, String sortField, boolean sortOrder, Map<String, String> filters) {
List<Estado> listaEstado = new ArrayList<Estado>();
return Pesquisar(listaEstado, sortField, sortOrder, first, pageSize);
}
};
lazyModel.setRowCount(estadoRN.TotalRegistros());
}
private List<Estado> Pesquisar(List<Estado> listEstado, String campoOrdecacao,boolean ordenacao, int pagina, int limit){
EstadoRN estadoRN = new EstadoRN();
String orderBy = ordenacao?ASC:DESC;
listEstado = estadoRN.Pesquisar(this.estado, campoOrdecacao, orderBy, pagina, limit);
return listEstado;
}
public LazyDataModel<Estado> getLazyModel() {
return this.lazyModel;
}
public String Excluir(){
EstadoRN estadoRN = new EstadoRN();
if( estadoSelecionados.length > 0) {
try {
for (Estado estado : estadoSelecionados) {
estadoRN.Excluir(estado);
}
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getSucesso(),GlossarioMensagens.getInstance().getMSG03());
context.addMessage(null, msg);
} catch (RNException rn) {
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getErro(),rn.getMessage());
context.addMessage(FormListagem, msg);
}
}else{
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_WARN,GlossarioTexto.getInstance().getAtencao(),GlossarioMensagens.getInstance().getMSG11());
context.addMessage(FormListagem, msg);
}
return /gerenciador/content/estado/index;
}
public Estado[] getEstadoSelecionados() {
return estadoSelecionados;
}
public void setEstadoSelecionados(Estado[] estadoSelecionados) {
this.estadoSelecionados = estadoSelecionados;
}
public Estado getEstado() {
return estado;
}
}
EstadoRN
package classe.projeto.estado;
import java.util.List;
import classe.projeto.estado.EstadoDAO;
import classe.projeto.utils.DAOException;
import classe.projeto.utils.DAOFactory;
import classe.projeto.utils.RNException;
public class EstadoRN {
private EstadoDAO estadoDAO;
public EstadoRN(){
this.estadoDAO = DAOFactory.CriarEstadoDAO();
}
public void Salvar(Estado estado) throws RNException{
try {
this.estadoDAO.Salvar(estado);
} catch (DAOException dao) {
throw new RNException(dao.getMessage());
}
}
public void Excluir(Estado estado) throws RNException{
try {
this.estadoDAO.Excluir(estado);
} catch (DAOException dao) {
throw new RNException(dao.getMessage());
}
}
public Integer TotalRegistros(){
return this.estadoDAO.TotalRegistros();
}
public Estado Obter (Estado estado){
return this.estadoDAO.Obter(estado);
}
public List<Estado> Pesquisar(Estado estado, String campoOrdenacao, String ordenacao, Integer pagina, Integer limit){
return this.estadoDAO.Pesquisar(estado, campoOrdenacao, ordenacao, pagina, limit);
}
}
EstadoDAOHibernate
package classe.projeto.estado;
import java.util.List;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import classe.projeto.utils.DAOException;
import classe.projeto.utils.FiltroQuery;
import classe.projeto.utils.GlossarioMensagens;
import classe.projeto.utils.ValidaOrdenacaoLimit;
public class EstadoDAOHibernate implements EstadoDAO {
private Session session;
private String filtroQuery;
public void setSession(Session session){
this.session = session;
}
private void setFiltroQuery(Estado estado){
this.filtroQuery = FiltroQuery.FiltroQuery(estado);
}
@Override
public void Salvar(Estado estado) throws DAOException {
this.session.flush();
this.session.clear();
if (estado.getEstadoID() == null ){
try {
this.session.save(estado);
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG04());
}
}else{
try {
this.session.update(estado);
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG05());
}
}
}
@Override
public void Excluir(Estado estado) throws DAOException{
try {
this.session.delete(estado);
this.session.flush();
this.session.clear();
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG06());
}
}
@SuppressWarnings(deprecation)
@Override
public Integer TotalRegistros() {
String sql = SELECT COUNT(*) AS totalRegistros FROM vwlistaestado ;
Query consulta = this.session.createSQLQuery(sql).addScalar(totalRegistros, Hibernate.INTEGER);
Integer totalRegistros = (Integer) consulta.uniqueResult();
return totalRegistros;
}
@Override
public Estado Obter(Estado estado) {
this.setFiltroQuery(estado);
String sql = SELECT * FROM vwlistaestado + this.filtroQuery ;
Query consulta = this.session.createSQLQuery(sql).addEntity(Estado.class);
return (Estado) consulta.uniqueResult();
}
@SuppressWarnings(unchecked)
@Override
public List<Estado> Pesquisar(Estado estado, String campoOrdenacao, String ordenacao, Integer pagina, Integer limit) {
this.setFiltroQuery(estado);
String sql = SELECT * FROM vwlistaestado + this.filtroQuery;
sql = ValidaOrdenacaoLimit.ValidaOrdenacaoLimit(sql, campoOrdenacao, ordenacao, pagina, limit);
Query consulta = this.session.createSQLQuery(sql).addEntity(Estado.class);
List<Estado> listaEstado = consulta.list();
return listaEstado;
}
}
Como disse antes o erro ocorre nesse metodo do bean, rodando a aplicação em debug o sistema entra no catch e o monta certinho e o erro ocorre apos passar em return /gerenciador/content/estado/index; esse é o ponto que está sendo gerado o erro.
public String Excluir(){
EstadoRN estadoRN = new EstadoRN();
if( estadoSelecionados.length > 0) {
try {
for (Estado estado : estadoSelecionados) {
estadoRN.Excluir(estado);
}
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getSucesso(),GlossarioMensagens.getInstance().getMSG03());
context.addMessage(null, msg);
} catch (RNException rn) {
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getErro(),rn.getMessage());
context.addMessage(FormListagem, msg);
}
}else{
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_WARN,GlossarioTexto.getInstance().getAtencao(),GlossarioMensagens.getInstance().getMSG11());
context.addMessage(FormListagem, msg);
}
return /gerenciador/content/estado/index;
}
Listagem (XHTML)
<?xml version=1.0 encoding=ISO-8859-1?>
<!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd>
<html xmlns=http://www.w3.org/1999/xhtml
xmlns:ui=http://java.sun.com/jsf/facelets
xmlns:h=http://java.sun.com/jsf/html
xmlns:f=http://java.sun.com/jsf/core
xmlns:p=http://primefaces.prime.com.tr/ui>
<h:body>
<ui:insert name=boxTopo>
<ui:include src=../../comum/estrutura/topo.xhtml />
</ui:insert>
<div class=boxCorpo>
<div class=corpo>
<ui:insert name=boxMenu>
<ui:include src=../../comum/estrutura/menu.xhtml />
</ui:insert>
<div class=boxAbas>
<h:outputLink styleClass=btAbaPesquisar title=Pesquisar>Pesquisar</h:outputLink>
<h:outputLink styleClass=btAbaCadastrar title=Cadastrar>Cadastrar</h:outputLink>
</div>
<div class=boxConteudo>
<h:form id=FormListagem prependId=false>
<p:dataTable var=estado value=#{EstadoListagemBean.lazyModel}
paginator=true rows=30
paginatorTemplate=
rowsPerPageTemplate=30,45,60 lazy=true dynamic=true
onRowSelectUpdate=display selection=#{EstadoListagemBean.estadoSelecionados} emptyMessage=#{MensagemBean.mensagemNenhumRegistroEncontado}>
<p:column selectionMode=multiple />
<p:column sortBy=#{estado.nome}
styleClass=tblListagemProjeto>
<f:facet name=header>
<h:outputText value=Nome />
</f:facet>
<h:outputText value=#{estado.nome} />
</p:column>
<p:column styleClass=tblListagemProjeto tdEditar>
<f:facet name=header>
<h:outputText value=Editar/>
</f:facet>
<h:commandLink action=#{EstadoCadastroBean.Editar}>
<h:graphicImage url=../../comum/img/edit.png/>
<f:setPropertyActionListener target=#{EstadoCadastroBean.estado} value=# />
</h:commandLink>
</p:column>
<f:facet name=footer>
<p:commandButton id=btnExcluir value=Excluir oncomplete=confirmDeleteDialog.show() />
</f:facet>
</p:dataTable>
<p:confirmDialog message=#{MensagemBean.mensagemDesejaExcluir} width=400 header=Excluir Registros severity=alert widgetVar=confirmDeleteDialog>
<p:commandButton value=Sim action=#{EstadoListagemBean.Excluir} oncomplete=confirmDeleteDialog.hide() ajax=false update=boxMensagemValidacao />
<p:commandButton value=Cancelar onclick=confirmDeleteDialog.hide() type=button />
</p:confirmDialog>
</h:form>
<h:messages id=boxMensagemValidacao globalOnly=true/>
</div>
</div>
</div>
<ui:insert name=boxRodape>
<ui:include src=../../comum/estrutura/rodape.xhtml />
</ui:insert>
</h:body>
</html>
EstadoListagemBean
package classe.projeto.bean;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import javax.annotation.PostConstruct;
import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import org.primefaces.model.LazyDataModel;
import classe.projeto.estado.Estado;
import classe.projeto.estado.EstadoRN;
import classe.projeto.utils.GlossarioMensagens;
import classe.projeto.utils.GlossarioTexto;
import classe.projeto.utils.RNException;
@ManagedBean(name=EstadoListagemBean)
@ViewScoped
public class EstadoListagemBean {
private Estado estado = new Estado();
private Estado[] estadoSelecionados;
private LazyDataModel<Estado> lazyModel;
public EstadoListagemBean(){
this.CarregaLazyDataModel();
}
@PostConstruct
private void CarregaLazyDataModel() {
EstadoRN estadoRN = new EstadoRN();
this.lazyModel = new LazyDataModel<Estado>() {
private static final long serialVersionUID = 1829143374090645173L;
@Override
public List<Estado> load(int first, int pageSize, String sortField, boolean sortOrder, Map<String, String> filters) {
List<Estado> listaEstado = new ArrayList<Estado>();
return Pesquisar(listaEstado, sortField, sortOrder, first, pageSize);
}
};
lazyModel.setRowCount(estadoRN.TotalRegistros());
}
private List<Estado> Pesquisar(List<Estado> listEstado, String campoOrdecacao,boolean ordenacao, int pagina, int limit){
EstadoRN estadoRN = new EstadoRN();
String orderBy = ordenacao?ASC:DESC;
listEstado = estadoRN.Pesquisar(this.estado, campoOrdecacao, orderBy, pagina, limit);
return listEstado;
}
public LazyDataModel<Estado> getLazyModel() {
return this.lazyModel;
}
public String Excluir(){
EstadoRN estadoRN = new EstadoRN();
if( estadoSelecionados.length > 0) {
try {
for (Estado estado : estadoSelecionados) {
estadoRN.Excluir(estado);
}
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getSucesso(),GlossarioMensagens.getInstance().getMSG03());
context.addMessage(null, msg);
} catch (RNException rn) {
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getErro(),rn.getMessage());
context.addMessage(FormListagem, msg);
}
}else{
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_WARN,GlossarioTexto.getInstance().getAtencao(),GlossarioMensagens.getInstance().getMSG11());
context.addMessage(FormListagem, msg);
}
return /gerenciador/content/estado/index;
}
public Estado[] getEstadoSelecionados() {
return estadoSelecionados;
}
public void setEstadoSelecionados(Estado[] estadoSelecionados) {
this.estadoSelecionados = estadoSelecionados;
}
public Estado getEstado() {
return estado;
}
}
EstadoRN
package classe.projeto.estado;
import java.util.List;
import classe.projeto.estado.EstadoDAO;
import classe.projeto.utils.DAOException;
import classe.projeto.utils.DAOFactory;
import classe.projeto.utils.RNException;
public class EstadoRN {
private EstadoDAO estadoDAO;
public EstadoRN(){
this.estadoDAO = DAOFactory.CriarEstadoDAO();
}
public void Salvar(Estado estado) throws RNException{
try {
this.estadoDAO.Salvar(estado);
} catch (DAOException dao) {
throw new RNException(dao.getMessage());
}
}
public void Excluir(Estado estado) throws RNException{
try {
this.estadoDAO.Excluir(estado);
} catch (DAOException dao) {
throw new RNException(dao.getMessage());
}
}
public Integer TotalRegistros(){
return this.estadoDAO.TotalRegistros();
}
public Estado Obter (Estado estado){
return this.estadoDAO.Obter(estado);
}
public List<Estado> Pesquisar(Estado estado, String campoOrdenacao, String ordenacao, Integer pagina, Integer limit){
return this.estadoDAO.Pesquisar(estado, campoOrdenacao, ordenacao, pagina, limit);
}
}
EstadoDAOHibernate
package classe.projeto.estado;
import java.util.List;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import classe.projeto.utils.DAOException;
import classe.projeto.utils.FiltroQuery;
import classe.projeto.utils.GlossarioMensagens;
import classe.projeto.utils.ValidaOrdenacaoLimit;
public class EstadoDAOHibernate implements EstadoDAO {
private Session session;
private String filtroQuery;
public void setSession(Session session){
this.session = session;
}
private void setFiltroQuery(Estado estado){
this.filtroQuery = FiltroQuery.FiltroQuery(estado);
}
@Override
public void Salvar(Estado estado) throws DAOException {
this.session.flush();
this.session.clear();
if (estado.getEstadoID() == null ){
try {
this.session.save(estado);
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG04());
}
}else{
try {
this.session.update(estado);
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG05());
}
}
}
@Override
public void Excluir(Estado estado) throws DAOException{
try {
this.session.delete(estado);
this.session.flush();
this.session.clear();
} catch (Exception e) {
throw new DAOException(GlossarioMensagens.getInstance().getMSG06());
}
}
@SuppressWarnings(deprecation)
@Override
public Integer TotalRegistros() {
String sql = SELECT COUNT(*) AS totalRegistros FROM vwlistaestado ;
Query consulta = this.session.createSQLQuery(sql).addScalar(totalRegistros, Hibernate.INTEGER);
Integer totalRegistros = (Integer) consulta.uniqueResult();
return totalRegistros;
}
@Override
public Estado Obter(Estado estado) {
this.setFiltroQuery(estado);
String sql = SELECT * FROM vwlistaestado + this.filtroQuery ;
Query consulta = this.session.createSQLQuery(sql).addEntity(Estado.class);
return (Estado) consulta.uniqueResult();
}
@SuppressWarnings(unchecked)
@Override
public List<Estado> Pesquisar(Estado estado, String campoOrdenacao, String ordenacao, Integer pagina, Integer limit) {
this.setFiltroQuery(estado);
String sql = SELECT * FROM vwlistaestado + this.filtroQuery;
sql = ValidaOrdenacaoLimit.ValidaOrdenacaoLimit(sql, campoOrdenacao, ordenacao, pagina, limit);
Query consulta = this.session.createSQLQuery(sql).addEntity(Estado.class);
List<Estado> listaEstado = consulta.list();
return listaEstado;
}
}
Como disse antes o erro ocorre nesse metodo do bean, rodando a aplicação em debug o sistema entra no catch e o monta certinho e o erro ocorre apos passar em return /gerenciador/content/estado/index; esse é o ponto que está sendo gerado o erro.
public String Excluir(){
EstadoRN estadoRN = new EstadoRN();
if( estadoSelecionados.length > 0) {
try {
for (Estado estado : estadoSelecionados) {
estadoRN.Excluir(estado);
}
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getSucesso(),GlossarioMensagens.getInstance().getMSG03());
context.addMessage(null, msg);
} catch (RNException rn) {
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getErro(),rn.getMessage());
context.addMessage(FormListagem, msg);
}
}else{
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_WARN,GlossarioTexto.getInstance().getAtencao(),GlossarioMensagens.getInstance().getMSG11());
context.addMessage(FormListagem, msg);
}
return /gerenciador/content/estado/index;
}
Responder
Gostei + 0
23/02/2012
Davi Costa
Parece que o try/catch está tratando uma exceção que não está sendo enviada, só para teste coloca try{
...
}catch(Exception e){
...
Nessa exclusão só para testar
att Davi
...
}catch(Exception e){
...
Nessa exclusão só para testar
att Davi
Responder
Gostei + 0
23/02/2012
Daniel Everling
Perdão, mas não entendi,
Você quer que eu adicione o Exception no ConexaoHibernateFilter tambem ou quer eu eu trate com Exception no bean ?
Você quer que eu adicione o Exception no ConexaoHibernateFilter tambem ou quer eu eu trate com Exception no bean ?
Responder
Gostei + 0
23/02/2012
Davi Costa
Pedi que tratasse a exceção o mais genérico possível, pois pode ser que a exceção lançada não tenha sido a que vc lançou:
public String Excluir(){
EstadoRN estadoRN = new EstadoRN();
if( estadoSelecionados.length > 0) {
try {
for (Estado estado : estadoSelecionados) {
estadoRN.Excluir(estado);
}
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getSucesso(),GlossarioMensagens.getInstance().getMSG03());
context.addMessage(null, msg);
//mudança foi aqui era: } catch (Exception rn) {
} catch (Exception rn) {
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getErro(),rn.getMessage());
context.addMessage(FormListagem, msg);
}
}else{
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_WARN,GlossarioTexto.getInstance().getAtencao(),GlossarioMensagens.getInstance().getMSG11());
context.addMessage(FormListagem, msg);
}
return /gerenciador/content/estado/index;
}
att Davi
public String Excluir(){
EstadoRN estadoRN = new EstadoRN();
if( estadoSelecionados.length > 0) {
try {
for (Estado estado : estadoSelecionados) {
estadoRN.Excluir(estado);
}
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getSucesso(),GlossarioMensagens.getInstance().getMSG03());
context.addMessage(null, msg);
//mudança foi aqui era: } catch (Exception rn) {
} catch (Exception rn) {
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(GlossarioTexto.getInstance().getErro(),rn.getMessage());
context.addMessage(FormListagem, msg);
}
}else{
FacesContext context = FacesContext.getCurrentInstance();
FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_WARN,GlossarioTexto.getInstance().getAtencao(),GlossarioMensagens.getInstance().getMSG11());
context.addMessage(FormListagem, msg);
}
return /gerenciador/content/estado/index;
}
att Davi
Responder
Gostei + 0
23/02/2012
Daniel Everling
Davi, a fiz isso que pediu e não funcionou
A exceção que lancei é a que está sendo tratada, pois se dou um imprimo a exception com system.out.println(rn.getMessase()) e ele mostra a mensagem que lancei com o thorw new la da camada DAO.
Uma coisa muito estranha que reparei, to tentando resolver isso desde sábado.
Algumas coisas que li, estavam dizendo que poderia ser o tomcat o problema, então exclui o server do eclipse e criei novamente, apos a recriação do mesmo, a classe que implementa o filter não carregou mais o servet, ai peguei o servet da pasta lib do tomcat e coloquei na minha aplicação, mas mesmo assim não funcionou.
Tens mais alguma ideia do que posso tentar ?
A exceção que lancei é a que está sendo tratada, pois se dou um imprimo a exception com system.out.println(rn.getMessase()) e ele mostra a mensagem que lancei com o thorw new la da camada DAO.
Uma coisa muito estranha que reparei, to tentando resolver isso desde sábado.
Algumas coisas que li, estavam dizendo que poderia ser o tomcat o problema, então exclui o server do eclipse e criei novamente, apos a recriação do mesmo, a classe que implementa o filter não carregou mais o servet, ai peguei o servet da pasta lib do tomcat e coloquei na minha aplicação, mas mesmo assim não funcionou.
Tens mais alguma ideia do que posso tentar ?
Responder
Gostei + 0
23/02/2012
Davi Costa
debugar todos os getters do seu managedbean após essa tentaiva de exclusão... em algum momento... deve estar quebrando, lembra que citei antes o lance do menu
att Davi
att Davi
Responder
Gostei + 0
23/02/2012
Daniel Everling
Davi, fazendo o que pediu, consegui chegar onde o erro acontece, o erro está acontecendo ao tentar obter o usuário logado
segue o erro
ERROR: current transaction is aborted, commands ignored until end of transaction block
o pelo que li, é um erro de gerenciamento de conexões, mas como resolvo isso utilizando spring security e hibernate,
já que quem gerencia a conexão é o spring ?
segue o erro
ERROR: current transaction is aborted, commands ignored until end of transaction block
o pelo que li, é um erro de gerenciamento de conexões, mas como resolvo isso utilizando spring security e hibernate,
já que quem gerencia a conexão é o spring ?
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)