-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 
  Previous topic | Next topic 
Author Message
jamesjmp
 Post subject: datediff and native sql
PostPosted: Tue Apr 15, 2008 5:49 am 
Newbie

Joined: Tue Apr 15, 2008 5:36 am
Posts: 2
Hi,
I´m using Sybase, Hibernate and Seam. My queries are via HQL (no criteria)
In native sql I have this query: (it works)

Code:
select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')



1.- I have not found a way to state datediff with HQL. is there?

I have tried with createSQLQuery like this:

Code:
         Session session = null;
         String sql = "select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')";
         try {
            List fecha1 = session.createSQLQuery(sql).list();
            for (int i=0;i<fecha1.size();i++) {
              System.out.println("fecha1"+fecha1.get(i));
         }   
         }
         catch(Exception ex) {
             System.out.println("fecha1 ex!!!"+ex.getMessage());
         }


This is the trace:


11:46:42,546 INFO [STDOUT] fecha1 ex!!!null
11:46:42,546 ERROR [STDERR] java.lang.NullPointerException
11:46:42,546 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.dateDiffQQQ(ImportsList.java:58)

11:46:42,546 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.getEjbql(ImportsList.java:38)
11:46:42,546 ERROR [STDERR] at org.jboss.seam.framework.Query.validate(Query.java:59)
11:46:42,546 ERROR [STDERR] at org.jboss.seam.framework.EntityQuery.validate(EntityQuery.java:36)
11:46:42,859 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:42,859 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:42,859 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:42,859 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)

11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:38)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:40)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:32)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)

11:46:42,859 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList_$$_javassist_15.validate(ImportsList_$$_javassist_15.java)
11:46:42,859 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:42,859 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:42,859 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:42,859 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:125)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.Component.callComponentMethod(Component.java:2082)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.Component.callCreateMethod(Component.java:2005)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.Component.newInstance(Component.java:1976)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1873)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1840)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
11:46:42,859 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:166)
11:46:43,359 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:53)
11:46:43,359 ERROR [STDERR] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
11:46:43,359 ERROR [STDERR] at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
11:46:43,359 ERROR [STDERR] at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
11:46:43,359 ERROR [STDERR] at org.jboss.el.parser.AstValue.getTarget(AstValue.java:34)
11:46:43,359 ERROR [STDERR] at org.jboss.el.parser.AstValue.invoke(AstValue.java:95)
11:46:43,359 ERROR [STDERR] at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
11:46:43,359 ERROR [STDERR] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
11:46:43,359 ERROR [STDERR] at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
11:46:43,359 ERROR [STDERR] at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
11:46:43,359 ERROR [STDERR] at javax.faces.component.UICommand.broadcast(UICommand.java:383)
11:46:43,359 ERROR [STDERR] at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
11:46:43,359 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:316)
11:46:43,359 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:291)
11:46:43,359 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:248)
11:46:43,359 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:461)
11:46:43,359 ERROR [STDERR] at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
11:46:43,375 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
11:46:43,375 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
11:46:43,375 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
11:46:43,375 ERROR [STDERR] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
11:46:43,375 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:276)
11:46:43,375 ERROR [STDERR] at org.ajax4jsf.Filter.doFilter(Filter.java:175)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:43,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:43,375 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
11:46:43,375 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
11:46:43,375 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
11:46:43,375 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
11:46:43,375 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
11:46:43,375 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
11:46:43,375 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
11:46:43,375 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
11:46:43,375 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)


2.-what am I doing wrong?

And last but not least I have tried this way:


Code:
try {
            List fecha2 = this.getEntityManager().createNamedQuery(sql).getResultList();
            for (int i=0;i<fecha2.size();i++) {
              System.out.println("fecha2"+fecha2.get(i));
            }
         }
            catch(Exception ex2) {
             System.out.println("fecha2 ex2!!!"+ex2.getMessage());
             ex2.printStackTrace();
         }

This is the trace:
[i]
11:46:43,375 INFO [STDOUT] fecha2 ex2!!!org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')
11:46:43,875 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')

11:46:43,875 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
11:46:43,875 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.createNamedQuery(AbstractEntityManagerImpl.java:106)
11:46:43,875 ERROR [STDERR] at org.jboss.seam.persistence.EntityManagerProxy.createNamedQuery(EntityManagerProxy.java:44)
11:46:43,875 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.dateDiffQQQ(ImportsList.java:68)
11:46:43,875 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.getEjbql(ImportsList.java:38)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.framework.Query.validate(Query.java:59)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.framework.EntityQuery.validate(EntityQuery.java:36)
11:46:44,375 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:44,375 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:44,375 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:44,375 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:38)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:40)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:32)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
11:46:44,375 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList_$$_javassist_15.validate(ImportsList_$$_javassist_15.java)
11:46:44,375 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:44,375 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:44,375 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:44,375 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:125)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.Component.callComponentMethod(Component.java:2082)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.Component.callCreateMethod(Component.java:2005)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.Component.newInstance(Component.java:1976)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1873)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1840)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:166)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:53)
11:46:44,375 ERROR [STDERR] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
11:46:44,375 ERROR [STDERR] at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
11:46:44,375 ERROR [STDERR] at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
11:46:44,375 ERROR [STDERR] at org.jboss.el.parser.AstValue.getTarget(AstValue.java:34)
11:46:44,375 ERROR [STDERR] at org.jboss.el.parser.AstValue.invoke(AstValue.java:95)
11:46:44,375 ERROR [STDERR] at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
11:46:44,375 ERROR [STDERR] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
11:46:44,375 ERROR [STDERR] at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
11:46:44,375 ERROR [STDERR] at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
11:46:44,375 ERROR [STDERR] at javax.faces.component.UICommand.broadcast(UICommand.java:383)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:316)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:291)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:248)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:461)
11:46:44,375 ERROR [STDERR] at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
11:46:44,375 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
11:46:44,375 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
11:46:44,375 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:276)
11:46:44,375 ERROR [STDERR] at org.ajax4jsf.Filter.doFilter(Filter.java:175)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:44,375 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:44,375 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
11:46:44,375 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
11:46:44,375 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
11:46:44,375 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
11:46:44,375 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
11:46:44,375 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
11:46:44,375 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
11:46:44,375 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
11:46:44,375 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
11:46:44,390 ERROR [STDERR] Caused by: org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')
11:46:44,390 ERROR [STDERR] at org.hibernate.impl.AbstractSessionImpl.getNamedQuery(AbstractSessionImpl.java:70)
11:46:44,390 ERROR [STDERR] at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1260)
11:46:44,390 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.createNamedQuery(AbstractEntityManagerImpl.java:103)
11:46:44,390 ERROR [STDERR] ... 97 more
11:46:44,890 INFO [ImportsList] ImportsList - listImports!
11:46:44,953 INFO [STDOUT] dateDiff!!!!
11:46:44,953 INFO [STDOUT] fecha1 ex!!!null
11:46:44,953 ERROR [STDERR] java.lang.NullPointerException
11:46:44,953 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.dateDiffQQQ(ImportsList.java:58)
11:46:44,953 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.getEjbql(ImportsList.java:38)
11:46:44,953 ERROR [STDERR] at org.jboss.seam.framework.Query.validate(Query.java:59)
11:46:44,953 ERROR [STDERR] at org.jboss.seam.framework.EntityQuery.validate(EntityQuery.java:36)
11:46:45,375 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:45,375 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:45,375 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:45,375 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:45,375 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:45,375 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
11:46:45,375 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:38)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:40)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:32)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
11:46:45,390 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList_$$_javassist_15.validate(ImportsList_$$_javassist_15.java)
11:46:45,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:45,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:45,390 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:45,390 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:125)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.Component.callComponentMethod(Component.java:2082)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.Component.callCreateMethod(Component.java:2005)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.Component.newInstance(Component.java:1976)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1873)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1840)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:166)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:53)
11:46:45,390 ERROR [STDERR] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
11:46:45,390 ERROR [STDERR] at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
11:46:45,390 ERROR [STDERR] at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
11:46:45,390 ERROR [STDERR] at org.jboss.el.parser.AstValue.getValue(AstValue.java:63)
11:46:45,390 ERROR [STDERR] at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.core.Expressions$1.getValue(Expressions.java:111)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.navigation.Param.getStringValueFromModel(Param.java:133)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.navigation.Pages.getStringValuesFromModel(Pages.java:690)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.navigation.Pages.encodePageParameters(Pages.java:858)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.faces.FacesManager.redirect(FacesManager.java:159)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.faces.Redirect.execute(Redirect.java:139)
11:46:45,390 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.listImports(ImportsList.java:143)
11:46:45,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:45,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:45,390 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:45,390 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:38)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:40)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:32)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
11:46:45,390 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList_$$_javassist_15.listImports(ImportsList_$$_javassist_15.java)
11:46:45,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:45,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:45,390 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:45,390 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:45,390 ERROR [STDERR] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
11:46:45,390 ERROR [STDERR] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
11:46:45,390 ERROR [STDERR] at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
11:46:45,390 ERROR [STDERR] at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
11:46:45,390 ERROR [STDERR] at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
11:46:45,390 ERROR [STDERR] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
11:46:45,390 ERROR [STDERR] at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
11:46:45,390 ERROR [STDERR] at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
11:46:45,390 ERROR [STDERR] at javax.faces.component.UICommand.broadcast(UICommand.java:383)
11:46:45,390 ERROR [STDERR] at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
11:46:45,390 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:316)
11:46:45,390 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:291)
11:46:45,390 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:248)
11:46:45,390 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:461)
11:46:45,390 ERROR [STDERR] at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
11:46:45,390 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
11:46:45,390 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
11:46:45,390 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
11:46:45,390 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
11:46:45,390 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
11:46:45,390 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
11:46:45,890 ERROR [STDERR] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
11:46:45,890 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:276)
11:46:45,890 ERROR [STDERR] at org.ajax4jsf.Filter.doFilter(Filter.java:175)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:45,890 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:45,890 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
11:46:45,890 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
11:46:45,890 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
11:46:45,890 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
11:46:45,890 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
11:46:45,890 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
11:46:45,890 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
11:46:45,890 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
11:46:45,890 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
11:46:45,890 INFO [STDOUT] fecha2 ex2!!!org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')
11:46:45,890 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')
11:46:45,890 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
11:46:45,890 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.createNamedQuery(AbstractEntityManagerImpl.java:106)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.persistence.EntityManagerProxy.createNamedQuery(EntityManagerProxy.java:44)
11:46:46,390 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.dateDiffQQQ(ImportsList.java:68)
11:46:46,390 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.getEjbql(ImportsList.java:38)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.framework.Query.validate(Query.java:59)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.framework.EntityQuery.validate(EntityQuery.java:36)
11:46:46,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:46,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:46,390 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:46,390 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:38)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:40)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:32)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
11:46:46,390 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList_$$_javassist_15.validate(ImportsList_$$_javassist_15.java)
11:46:46,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:46,390 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:46,390 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:46,390 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:125)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.Component.callComponentMethod(Component.java:2082)
11:46:46,390 ERROR [STDERR] at org.jboss.seam.Component.callCreateMethod(Component.java:2005)
11:46:46,406 ERROR [STDERR] at org.jboss.seam.Component.newInstance(Component.java:1976)
11:46:46,406 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1873)
11:46:46,406 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1840)
11:46:46,406 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
11:46:46,406 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
11:46:46,406 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:166)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:53)
11:46:46,906 ERROR [STDERR] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
11:46:46,906 ERROR [STDERR] at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
11:46:46,906 ERROR [STDERR] at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
11:46:46,906 ERROR [STDERR] at org.jboss.el.parser.AstValue.getValue(AstValue.java:63)
11:46:46,906 ERROR [STDERR] at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.core.Expressions$1.getValue(Expressions.java:111)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.navigation.Param.getStringValueFromModel(Param.java:133)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.navigation.Pages.getStringValuesFromModel(Pages.java:690)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.navigation.Pages.encodePageParameters(Pages.java:858)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.faces.FacesManager.redirect(FacesManager.java:159)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.faces.Redirect.execute(Redirect.java:139)
11:46:46,906 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.listImports(ImportsList.java:143)
11:46:46,906 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:46,906 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:46,906 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:46,906 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:38)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:40)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:32)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
11:46:46,906 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
11:46:46,906 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList_$$_javassist_15.listImports(ImportsList_$$_javassist_15.java)
11:46:46,906 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:46,906 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:46,906 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:46,906 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:46,906 ERROR [STDERR] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
11:46:46,906 ERROR [STDERR] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
11:46:46,906 ERROR [STDERR] at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
11:46:46,906 ERROR [STDERR] at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
11:46:46,906 ERROR [STDERR] at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
11:46:46,906 ERROR [STDERR] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
11:46:46,906 ERROR [STDERR] at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
11:46:46,906 ERROR [STDERR] at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
11:46:46,906 ERROR [STDERR] at javax.faces.component.UICommand.broadcast(UICommand.java:383)
11:46:46,906 ERROR [STDERR] at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
11:46:46,906 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:316)
11:46:47,406 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:291)
11:46:47,406 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:248)
11:46:47,406 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:461)
11:46:47,406 ERROR [STDERR] at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

11:46:47,406 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
11:46:47,406 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
11:46:47,406 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
11:46:47,406 ERROR [STDERR] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
11:46:47,406 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:276)
11:46:47,406 ERROR [STDERR] at org.ajax4jsf.Filter.doFilter(Filter.java:175)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:47,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:47,406 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
11:46:47,406 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
11:46:47,406 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
11:46:47,406 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
11:46:47,406 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
11:46:47,406 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
11:46:47,406 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
11:46:47,406 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
11:46:47,406 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)

11:46:47,406 ERROR [STDERR] Caused by: org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')
11:46:47,406 ERROR [STDERR] at org.hibernate.impl.AbstractSessionImpl.getNamedQuery(AbstractSessionImpl.java:70)
11:46:47,406 ERROR [STDERR] at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1260)
11:46:47,406 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.createNamedQuery(AbstractEntityManagerImpl.java:103)
11:46:47,406 ERROR [STDERR] ... 133 more
11:46:47,968 INFO [STDOUT] dateDiff!!!!
11:46:47,968 INFO [STDOUT] fecha1 ex!!!null
11:46:47,968 ERROR [STDERR] java.lang.NullPointerException
11:46:47,968 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.dateDiffQQQ(ImportsList.java:58)

11:46:47,968 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.getEjbql(ImportsList.java:38)
11:46:47,968 ERROR [STDERR] at org.jboss.seam.framework.Query.validate(Query.java:59)
11:46:47,968 ERROR [STDERR] at org.jboss.seam.framework.EntityQuery.validate(EntityQuery.java:36)
11:46:48,406 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:48,406 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:48,406 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:48,406 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)

11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:38)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:40)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:32)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)

11:46:48,406 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList_$$_javassist_15.validate(ImportsList_$$_javassist_15.java)
11:46:48,406 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:46:48,406 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:46:48,406 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:46:48,406 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:125)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.Component.callComponentMethod(Component.java:2082)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.Component.callCreateMethod(Component.java:2005)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.Component.newInstance(Component.java:1976)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1873)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1840)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:166)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:53)
11:46:48,406 ERROR [STDERR] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
11:46:48,406 ERROR [STDERR] at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
11:46:48,406 ERROR [STDERR] at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
11:46:48,406 ERROR [STDERR] at org.jboss.el.parser.AstValue.getTarget(AstValue.java:34)
11:46:48,406 ERROR [STDERR] at org.jboss.el.parser.AstValue.getType(AstValue.java:28)
11:46:48,406 ERROR [STDERR] at org.jboss.el.ValueExpressionImpl.getType(ValueExpressionImpl.java:174)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.core.Expressions$1.getType(Expressions.java:126)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.navigation.Param.getConverter(Param.java:65)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.navigation.Param.convertValueFromString(Param.java:205)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.navigation.Pages.convertAndValidateStringValuesInPageContext(Pages.java:745)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.navigation.Pages.postRestore(Pages.java:393)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.jsf.SeamPhaseListener.postRestorePage(SeamPhaseListener.java:533)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.jsf.SeamPhaseListener.afterRestoreView(SeamPhaseListener.java:379)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.jsf.SeamPhaseListener.afterServletPhase(SeamPhaseListener.java:216)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.jsf.SeamPhaseListener.afterPhase(SeamPhaseListener.java:182)
11:46:48,406 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:280)
11:46:48,406 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
11:46:48,406 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
11:46:48,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
11:46:48,406 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:48,406 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
11:46:48,406 ERROR [STDERR] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
11:46:48,406 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:276)
11:46:48,406 ERROR [STDERR] at org.ajax4jsf.Filter.doFilter(Filter.java:175)
11:46:48,421 ERROR [STDERR] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
11:46:48,421 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:48,421 ERROR [STDERR] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
11:46:48,421 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
11:46:48,421 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

11:46:48,421 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
11:46:48,421 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
11:46:48,421 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
11:46:48,421 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
11:46:48,421 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
11:46:48,421 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
11:46:48,421 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
11:46:48,421 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
11:46:48,421 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
11:46:48,421 INFO [STDOUT] fecha2 ex2!!!org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')
11:46:48,421 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.MappingException: Named query not known: select datediff(day, '12/12/2007 14:47:11', '12/12/2007 14:19:07')
11:46:48,421 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
11:46:48,421 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.createNamedQuery(AbstractEntityManagerImpl.java:106)
11:46:48,921 ERROR [STDERR] at org.jboss.seam.persistence.EntityManagerProxy.createNamedQuery(EntityManagerProxy.java:44)
11:46:48,921 ERROR [STDERR] at es.rbcdexia.risk.online.action.ImportsList.dateDiffQQQ(ImportsList.java:68)
Top
 Profile  
 
jamesjmp
 Post subject:
PostPosted: Tue Apr 15, 2008 7:59 am 
Newbie

Joined: Tue Apr 15, 2008 5:36 am
Posts: 2
I´ve solved this using nativeQuery this way:


Code:
List fecha3 = this.getEntityManager().createNativeQuery(sql).getResultList();


Anyway, I wonder if there is a way in HQL to compare two datetimes skipping
hours, minutes and seconds.
thank you!
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.