Skip to Main Content

ADF table filtering error on date columns

2687472Jun 25 2014 — edited Jun 25 2014

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jul 23 2014
Added on Jun 25 2014
2 comments
908 views