2 Replies Latest reply: Jun 25, 2014 9:01 AM by 2687472 RSS

    ADF table filtering error on date columns

    2687472

      Hi,

      Jdev version : 11.1.1.7

      I'm displaying a table on a page. The data is coming from simple bean in the model project.

      I enabled the filtering for the table and is working fine for all the columns except for date column.

      You can find my sample application here: https://drive.google.com/file/d/0B_vVQ-jFl-n-ZXhodGJMbktwYk0/edit?usp=sharing

       

      I'm getting below exception when I try to enter a valid date and press enter. Can some body help me how to avoid this?

       

      <Utils> <buildFacesMessage> ADF: Adding the following JSF error message: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

      java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

          at java.sql.Timestamp.valueOf(Timestamp.java:194)

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

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

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

          at oracle.jbo.common.JboTypeMapEntries.convertValue(JboTypeMapEntries.java:382)

          at oracle.jbo.common.OracleTypeMapEntries.convertValue(OracleTypeMapEntries.java:284)

          at oracle.jbo.common.JboTypeMap.convertValue(JboTypeMap.java:869)

          at oracle.jbo.domain.TypeConvMapEntry.convert(TypeConvMapEntry.java:120)

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

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

          at oracle.jbo.RowComparator.compareEquals(RowComparator.java:34)

          at oracle.jbo.RowValueSupplier.compareValues(RowValueSupplier.java:253)

          at oracle.jbo.expr.JIParserNode.evaluate(JIParserNode.java:1274)

          at oracle.jbo.ExprEval.doEvaluate(ExprEval.java:1587)

          at oracle.jbo.ExprEval.doEvaluate(ExprEval.java:1540)

          at oracle.jbo.ExprEval.evaluateForRow(ExprEval.java:1288)

          at oracle.jbo.RowMatch.rowQualifies(RowMatch.java:187)

          at oracle.jbo.server.ViewObjectImpl.rowQualifies(ViewObjectImpl.java:2983)

          at oracle.jbo.server.QueryCollection.rowQualifies(QueryCollection.java:3945)

          at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:3830)

          at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:3623)

          at oracle.jbo.server.QueryCollection.get(QueryCollection.java:2336)

          at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:5180)

          at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2971)

          at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2827)

          at oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:3068)

          at oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2841)

          at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1311)

          at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1449)

          at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1355)

          at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1340)

          at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:7236)

          at oracle.adf.model.bean.DCBeanDataControl.executeIteratorBinding(DCBeanDataControl.java:989)

          at oracle.adf.model.binding.DCIteratorBinding.doExecuteQuery(DCIteratorBinding.java:2186)

          at oracle.jbo.uicli.binding.MyIteratorBinding.executeQuery(JUAccessorIteratorDef.java:741)

          at oracle.jbo.uicli.binding.JUSearchBindingCustomizer.applyAndExecuteViewCriteria(JUSearchBindingCustomizer.java:615)

          at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding.processQuery(FacesCtrlSearchBinding.java:464)

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

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

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

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

          at com.sun.el.parser.AstValue.invoke(Unknown Source)

          at com.sun.el.MethodExpressionImpl.invoke(Unknown Source)

          at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)

          at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1415)

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

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

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

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

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

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

          at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.broadcastEvents(LifecycleImpl.java:1086)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

          at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.jav