[Resolvido] For input string

tiago_ · Janeiro 22, 2013, 2:15pm

Pessoal, tenho essa classe:

public class NovaRequisicaoModel implements Serializable {  
  
  
    private static final long serialVersionUID = -1625084105340262275L;  
      
    private String nomeUsuario;  
      
    private String dataHora;  
      
    private int quantidadeSolicitada;  
      
    private String nomeItem;  
  
         ...  
  
    }

Meu metodo:

@SuppressWarnings("unchecked")
	public List<NovaRequisicaoModel> listarTodasRequisicoesUsuario(String login) {
		String hql = "select  u.nome, r.dataHora, ir.quantidadeSolicitada, i.nome from ItemRequisicao ir  inner join "
				+ "ir.item as i  inner join ir.requisicao as r inner "
				+ "join r.usuario as u where u.login = :login";
		Query consulta = this.session.createQuery(hql);
		consulta.setParameter("login", contextoBean.getUsuarioLogado().getLogin());
		return consulta.list();
	}

Antes estava setString(…)
Mudei p ver se era isso e o erro continua !

Meu Bean :

public List<NovaRequisicaoModel> getNovaRequisicaoModel() {  
        RequisicaoRN requisicaoRN = new RequisicaoRN();  
        String login = contextoBean.getUsuarioLogado().getLogin();  
        novaRequisicaoModel = requisicaoRN.listarTodasRequisicoesUsuario(login);  
        return novaRequisicaoModel;  
    }  
  
  
    public void setNovaRequisicaoModel(List<NovaRequisicaoModel> novaRequisicaoModel) {  
        this.novaRequisicaoModel = novaRequisicaoModel;  
    }  
  
  
  
    public void setReq(String req) {  
        this.req = req;  
    }  
  
    public String getReq() {  
        return req;  
    }

E minha pagina:

...  
    <h:dataTable value="#{requisicaoBean.novaRequisicaoModel}" var="req" rules="rows" cellpadding="5" paginator="true" dynamic="true">    
                <f:facet name="caption">    
                    <br />    
                </f:facet>    
                <f:facet name="header">Minhas Requisições </f:facet>    
                <f:facet name="footer">Final da listagem</f:facet>    
                <h:column>    
                    <f:facet name="header">Usuario</f:facet>    
                    <h:outputText value="#{req.nomeUsuario}" />    
                </h:column>    
                <h:column>    
                    <f:facet name="header">Data</f:facet>    
                    #{req.dataHora}    
                </h:column>    
                <h:column>    
                    <f:facet name="header">Item</f:facet>    
                    #{req.nomeItem}    
                </h:column>    
                <h:column>    
                    <f:facet name="header">Qntd. Solicitada</f:facet>    
                    #{req.quantidadeSolicitada}    
                </h:column>    
            </h:dataTable>    
        </h:form>    
    </ui:define>    
</ui:composition>    
</html>

O maldito erro : /

For input string: “nomeUsuario”

java.lang.NumberFormatException: For input string: “nomeUsuario”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:449)
at java.lang.Integer.parseInt(Integer.java:499)
at javax.el.ArrayELResolver.coerce(ArrayELResolver.java:166)
at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:46)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67)
at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:71)
at com.sun.el.parser.AstValue.getValue(AstValue.java:116)
at com.sun.el.parser.AstValue.getValue(AstValue.java:163)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:106)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:190)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:178)
at javax.faces.component.UIOutput.getValue(UIOutput.java:164)
at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:201)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:351)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:160)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:879)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:308)
at com.sun.faces.renderkit.html_basic.TableRenderer.renderRow(TableRenderer.java:376)
at com.sun.faces.renderkit.html_basic.TableRenderer.encodeChildren(TableRenderer.java:157)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:849)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1643)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:164)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:849)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1643)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1646)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1646)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:389)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:127)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:117)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:97)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:135)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at requisicao.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:32)
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:344)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:110)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:98)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:95)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:55)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:36)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:188)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)
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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
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:1001)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

[b]Me disseram q eu teria q criar um construtor na classe NovaRequisicaoModel e setar os atributos da sua consulta “solta” para as propriedades da NovaRequisicaoModel.
So q nao sei fazer isso ( estou meio perdido ) !

Obrigado :)[/b]

Hebert_Coelho · Janeiro 22, 2013, 2:17pm

java.lang.NumberFormatException: For input string: “nomeUsuario”

Você por acaso não marcou nomeUsuario como int/float/long/double não?

tiago_ · Janeiro 22, 2013, 2:34pm

[quote=Hebert Coelho]java.lang.NumberFormatException: For input string: “nomeUsuario”

Você por acaso não marcou nomeUsuario como int/float/long/double não?[/quote]

Não. Ta como String.

D uma olhada no codigo, Hebert. Ja estou ficando louco com esse erro

tiago_ · Janeiro 22, 2013, 2:37pm

Eu to achando q o resultado da consulta esta sendo retornado em uma linha.
Tipo, fiz no Hql editor e deu varias 30 linhas ou + ! No Hql editor ta perfeito.

eu acho q o metodo juntou tudo em uma linha so. Acho q por isso ta dando esse erro !

tiago_ · Janeiro 22, 2013, 2:45pm

Tava vendo isso aqui mas nao soube implementar ¬¬’

CristianPalmaSola10 · Janeiro 22, 2013, 4:00pm

se voce fizer isso talvez possa resolver seu problema


query.setResultTransformer(Transformers.aliasToBean(ModelRazao.class));

da uma olhada nesse post do Stefan Horochovec, dela que tirei esse codigo

tiago_ · Janeiro 28, 2013, 6:15pm

Resolvido


public class NovaRequisicaoModel implements Serializable {

	/**
	 * 
	 */
	private static final long serialVersionUID = -1625084105340262275L;
	

	private String nomeUsuario;

	private String dataHora;

	private int quantidadeSolicitada;

	private String nomeItem;

...

@SuppressWarnings("unchecked")  
    public List<Object[]> listarTodasRequisicoesUsuario(String login, int codigoStatus) {  
        String hql = "select  u.nome as nomeUsuario, r.dataHora as dataHora, ir.quantidadeSolicitada as quantidadeSolicitada, i.nome as nomeItem from ItemRequisicao ir  inner join "  
                + "ir.item as i  inner join ir.requisicao as r inner "  
                + "join r.usuario as u where u.login = :login and codigoStatus = :codigoStatus order by r.codigo desc";  
        Query consulta = this.session.createQuery(hql);
        consulta.setParameter("login", contextoBean.getUsuarioLogado().getLogin()); 
        consulta.setInteger("codigoStatus", codigoStatus);
        return consulta.list();  
    }


	public List<NovaRequisicaoModel> getNovaRequisicaoModel() {
		
		FacesContext context = FacesContext.getCurrentInstance();		
		
		
		RequisicaoRN requisicaoRN = new RequisicaoRN();
		List<NovaRequisicaoModel> listadeRequisicoes = new ArrayList<NovaRequisicaoModel>();
		String login = contextoBean.getUsuarioLogado().getLogin();
		int codigoStatus =1; //pendente
		List<Object[]> objs = requisicaoRN.listarTodasRequisicoesUsuario(login, codigoStatus);
	
		System.out.println(objs.get(1).toString());
		List<String> listadeString = new ArrayList<String>();
		
		for (Object[] array : objs) {  
		    for (Object objeto : array) {  
		        listadeString.add(objeto.toString());
		}
		   
		   NovaRequisicaoModel nqm = new NovaRequisicaoModel();
		   nqm.setNomeUsuario(listadeString.get(0));
		   nqm.setDataHora(listadeString.get(1));
		   int qtd = Integer.parseInt(listadeString.get(2));
		   nqm.setQuantidadeSolicitada(qtd);
		   nqm.setNomeItem(listadeString.get(3));
		   listadeRequisicoes.add(nqm);
		   listadeString = new ArrayList<String>();
		   
		}
		return listadeRequisicoes;
	}

Muito obrigado a todos pela ajuda

system · Dezembro 30, 2015, 1:34pm

[Resolvido] For input string

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI