Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NumberFormatException when using more than 1 value in multiselect filter

Jose ArósteguiMar 9 2016 — edited Apr 20 2016

Hi experts,

I'm using Jdev 12.1.3 and I've successfully implemented "ADF Code Corner 98. How-to use multi select components in table filters"

When I select only 1 value in the filter it's working fine, but when I select 2 or more and the correspondent where clause "id1 OR id2 OR id3" like "30 OR 31 OR 32" is composed, I get a NumberFormatException.

This is the code of the queryListener method of the adf:table, in the ManagedBean:

    //current criteria

    Map \_criteriaMap = fqd.getFilterCriteria();

    ....

    if (\_criteriaMap.get("CategoryName") != null) {

        categoriesArray = (ArrayList\<Object>) \_criteriaMap.get("CategoryName");

        categoriesFilterString = composeORclause(categoriesArray);

        \_criteriaMap.put("CategoryId", categoriesFilterString.toString());

        fqd.setFilterCriteria(\_criteriaMap);

    }

And the code of composeORclause:

StringBuffer composeORclause(ArrayList\<Object> arr) {

    StringBuffer composedFilterString = new StringBuffer();

    String strValue = null;

    BigDecimal bigdecValue = null;

    Integer intValue = null;

    Number numValue = null;

    boolean isNumber = false;

    for (int argIndex = 0; argIndex \< arr.size(); argIndex++) {

        //Only first argument has no OR

        if (argIndex != 0) {

            composedFilterString.append(" OR ");

        }            

        if (arr.get(argIndex) instanceof String) {

            composedFilterString.append("%");

            strValue = (String) arr.get(argIndex);

            composedFilterString.append(strValue);

            composedFilterString.append("%");

        }           

        if (arr.get(argIndex) instanceof BigDecimal) {

            bigdecValue = (BigDecimal) arr.get(argIndex);

            composedFilterString.append(bigdecValue.toString()); 

            isNumber = true;

        }

       if (arr.get(argIndex) instanceof Integer) {

            intValue = (Integer) arr.get(argIndex);

            composedFilterString.append(intValue.toString()); 

            isNumber = true;

        }

    }

    if (isNumber) {

       composedFilterString.append(" OR -1");   

    }

    return composedFilterString;

}

And the exception shown:

Screen Shot 03-09-16 at 09.53 AM.PNG

<oracle.adf.controller> <Utils> <buildFacesMessage> <ADF: Adding the following JSF error message: java.lang.NumberFormatException>

java.lang.NumberFormatException

at java.math.BigDecimal.<init>(BigDecimal.java:470)

at java.math.BigDecimal.<init>(BigDecimal.java:739)

at oracle.jbo.common.JboTypeMapEntries$3.convert(JboTypeMapEntries.java:154)

at oracle.jbo.domain.TypeFactory.get(TypeFactory.java:886)

at oracle.jbo.domain.TypeFactory.getInstance(TypeFactory.java:114)

at oracle.jbo.server.AttributeDefImpl.convertToJava(AttributeDefImpl.java:2574)

at oracle.jbo.server.AttributeDefImpl.evaluateTransientExpression(AttributeDefImpl.java:2486)

at oracle.jbo.server.ViewRowStorage.getAttributeInternal(ViewRowStorage.java:2018)

at oracle.jbo.server.ViewRowImpl.getAttributeValue(ViewRowImpl.java:2036)

at oracle.jbo.server.ViewRowImpl.getAttributeInternal(ViewRowImpl.java:886)

at oracle.jbo.server.ProgrammaticViewRowImpl.getAttributeInternalDelegation(ProgrammaticViewRowImpl.java:195)

at oracle.adf.model.bean.DCDataRow.getAttributeInternal(DCDataRow.java:279)

at oracle.adf.model.bean.DCCriteriaValueRowImpl.getAttributeInternal(DCCriteriaValueRowImpl.java:240)

at oracle.jbo.server.ViewRowImpl.getAttrInvokeAccessor(ViewRowImpl.java:968)

at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:916)

at oracle.jbo.uicli.binding.JUCtrlValueBinding.internalGetAttributeValueFromRow(JUCtrlValueBinding.java:1248)

at oracle.jbo.uicli.binding.JUCtrlListBinding.setTargetAttrsFromLovRow(JUCtrlListBinding.java:3014)

at oracle.jbo.uicli.binding.JUCtrlListBinding.updateTargetFromSelectedValue(JUCtrlListBinding.java:3172)

at oracle.jbo.uicli.binding.JUCtrlListBinding.setAttributeFromValueList(JUCtrlListBinding.java:3117)

at oracle.jbo.uicli.binding.JUCtrlListBinding.setSelectedIndex(JUCtrlListBinding.java:1887)

at oracle.jbo.uicli.binding.JUCtrlListBinding.setInputValueInRow(JUCtrlListBinding.java:3793)

at oracle.jbo.uicli.binding.JUCtrlValueBinding.setInputValue(JUCtrlValueBinding.java:2987)

at oracle.jbo.uicli.binding.JUCtrlValueBinding.setInputValue(JUCtrlValueBinding.java:2950)

at oracle.adfinternal.view.faces.model.binding.FacesCtrlListBinding.setInputValue(FacesCtrlListBinding.java:457)

at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding$AdfFilterAttributeCriterion.setValue(FacesCtrlSearchBinding.java:5467)

at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding$FilterVCPassThoughMap.put(FacesCtrlSearchBinding.java:1975)

at com.xxx.scp.view.beans.ScpProjectsBean.onProjectsListTableQuery(ScpProjectsBean.java:858)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodExpression(UIXComponentBase.java:2016)

at oracle.adf.view.rich.component.UIXTable.broadcast(UIXTable.java:113)

at oracle.adf.view.rich.component.rich.data.RichTable.broadcast(RichTable.java:125)

at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

at org.apache.myfaces.trinidad.component.UIXCollection.broadcast(UIXCollection.java:189)

at org.apache.myfaces.trinidad.component.UIXTable.broadcast(UIXTable.java:281)

at oracle.adf.view.rich.component.UIXTable.broadcast(UIXTable.java:100)

at oracle.adf.view.rich.component.rich.data.RichTable.broadcast(RichTable.java:121)

at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

at org.apache.myfaces.trinidad.component.UIXCollection.broadcast(UIXCollection.java:170)

at org.apache.myfaces.trinidad.component.UIXTable.broadcast(UIXTable.java:281)

at oracle.adf.view.rich.component.UIXTable.broadcast(UIXTable.java:100)

at oracle.adf.view.rich.component.rich.data.RichTable.broadcast(RichTable.java:125)

at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:111)

at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:115)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:759)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1074)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

<org.apache.myfaces.trinidad.component.UIXComponentBase> <UIXComponentBase> <getClientId> <INVALID_CALL_TO_GETCLIENTID>

<oracle.adf.view> <SimpleSelectOneRenderer> <_getSelectedIndex> <Could not find selected item matching value "{0}" in {1}>