1 Reply Latest reply on Nov 15, 2011 6:01 PM by Taimur Mirza

    Seam-booking example in JBoss 7.0.1

    Taimur Mirza Newbie

      Hi, I am trying to run seam-booking example on JBoss 7 and getting following exception when I search any hotel, any idea?




      11:56:06,681 INFO  [org.jboss.seam.examples.booking.exceptioncontrol.GeneralExceptionHandler] (http--127.0.0.1-8080-1) Exception logged by seam-catch catcher: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6 hotel0_.id as id0_, hotel0_.address as address0_, hotel0_.city as city0_, hote' at line 1
      11:56:06,683 ERROR [stderr] (http--127.0.0.1-8080-1) javax.faces.FacesException: /search.xhtml @35,128 listener="#{hotelSearch.find}": javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6 hotel0_.id as id0_, hotel0_.address as address0_, hotel0_.city as city0_, hote' at line 1
      
      11:56:06,698 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:89)
      
      11:56:06,698 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
      
      11:56:06,699 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
      
      11:56:06,709 ERROR [stderr] (http--127.0.0.1-8080-1)      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
      
      11:56:06,729 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
      
      11:56:06,732 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
      
      11:56:06,736 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.ocpsoft.pretty.PrettyFilter.doFilter(PrettyFilter.java:118)
      
      11:56:06,743 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
      
      11:56:06,752 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
      
      11:56:06,766 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734)
      
      11:56:06,771 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541)
      
      11:56:06,775 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479)
      
      11:56:06,791 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407)
      
      11:56:06,792 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.ocpsoft.pretty.PrettyFilter.doFilter(PrettyFilter.java:110)
      
      11:56:06,801 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
      
      11:56:06,807 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
      
      11:56:06,811 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.solder.servlet.exception.CatchExceptionFilter.doFilter(CatchExceptionFilter.java:65)
      
      11:56:06,820 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
      
      11:56:06,829 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
      
      11:56:06,836 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.solder.servlet.event.ServletEventBridgeFilter.doFilter(ServletEventBridgeFilter.java:72)
      
      11:56:06,847 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
      
      11:56:06,854 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
      
      11:56:06,864 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
      
      11:56:06,871 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
      
      11:56:06,880 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
      
      11:56:06,897 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
      
      11:56:06,898 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:49)
      
      11:56:06,906 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
      
      11:56:06,911 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      
      11:56:06,918 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      
      11:56:06,928 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
      
      11:56:06,937 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
      
      11:56:06,943 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
      
      11:56:06,952 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
      
      11:56:06,958 ERROR [stderr] (http--127.0.0.1-8080-1)      at java.lang.Thread.run(Thread.java:619)
      
      11:56:06,968 ERROR [stderr] (http--127.0.0.1-8080-1) Caused by: javax.el.ELException: /search.xhtml @35,128 listener="#{hotelSearch.find}": javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6 hotel0_.id as id0_, hotel0_.address as address0_, hotel0_.city as city0_, hote' at line 1
      
      11:56:06,978 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:111)
      
      11:56:07,002 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.sun.faces.facelets.tag.jsf.core.AjaxBehaviorListenerImpl.processAjaxBehavior(AjaxHandler.java:447)
      
      11:56:07,004 ERROR [stderr] (http--127.0.0.1-8080-1)      at javax.faces.event.AjaxBehaviorEvent.processListener(AjaxBehaviorEvent.java:113)
      
      11:56:07,005 ERROR [stderr] (http--127.0.0.1-8080-1)      at javax.faces.component.behavior.BehaviorBase.broadcast(BehaviorBase.java:102)
      
      11:56:07,014 ERROR [stderr] (http--127.0.0.1-8080-1)      at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:768)
      
      11:56:07,016 ERROR [stderr] (http--127.0.0.1-8080-1)      at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:787)
      
      11:56:07,028 ERROR [stderr] (http--127.0.0.1-8080-1)      at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1252)
      
      11:56:07,038 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
      
      11:56:07,042 ERROR [stderr] (http--127.0.0.1-8080-1)      ... 34 more
      
      11:56:07,049 ERROR [stderr] (http--127.0.0.1-8080-1) Caused by: javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6 hotel0_.id as id0_, hotel0_.address as address0_, hotel0_.city as city0_, hote' at line 1
      
      11:56:07,065 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:158)
      
      11:56:07,066 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:237)
      
      11:56:07,071 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.required(CMTTxInterceptor.java:363)
      
      11:56:07,093 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(CMTTxInterceptor.java:219)
      
      11:56:07,094 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:35)
      
      11:56:07,102 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,108 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ejb3.component.session.SessionInvocationContextInterceptor.processInvocation(SessionInvocationContextInterceptor.java:71)
      
      11:56:07,116 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,125 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
      
      11:56:07,135 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:146)
      
      11:56:07,141 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,149 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
      
      11:56:07,158 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:76)
      
      11:56:07,175 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.seam.examples.booking.inventory.HotelSearch$$$view4.find(Unknown Source)
      
      11:56:07,178 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      
      11:56:07,184 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      
      11:56:07,191 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      
      11:56:07,197 ERROR [stderr] (http--127.0.0.1-8080-1)      at java.lang.reflect.Method.invoke(Method.java:597)
      
      11:56:07,204 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.util.reflection.SecureReflections$13.work(SecureReflections.java:305)
      
      11:56:07,212 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.util.reflection.SecureReflectionAccess.run(SecureReflectionAccess.java:54)
      
      11:56:07,221 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.util.reflection.SecureReflectionAccess.runAsInvocation(SecureReflectionAccess.java:163)
      
      11:56:07,228 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.util.reflection.SecureReflections.invoke(SecureReflections.java:299)
      
      11:56:07,236 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:125)
      
      11:56:07,242 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:62)
      
      11:56:07,254 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:125)
      
      11:56:07,264 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.seam.examples.booking.inventory.HotelSearch$Proxy$_$$_Weld$Proxy$.find(HotelSearch$Proxy$_$$_Weld$Proxy$.java)
      
      11:56:07,271 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.seam.examples.booking.inventory.HotelSearch$Proxy$_$$_WeldClientProxy.find(HotelSearch$Proxy$_$$_WeldClientProxy.java)
      
      11:56:07,297 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      
      11:56:07,307 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      
      11:56:07,308 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      
      11:56:07,314 ERROR [stderr] (http--127.0.0.1-8080-1)      at java.lang.reflect.Method.invoke(Method.java:597)
      
      11:56:07,316 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.el.parser.AstValue.invoke(AstValue.java:196)
      
      11:56:07,322 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
      
      11:56:07,323 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:43)
      
      11:56:07,333 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:56)
      
      11:56:07,344 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
      
      11:56:07,351 ERROR [stderr] (http--127.0.0.1-8080-1)      ... 41 more
      
      11:56:07,358 ERROR [stderr] (http--127.0.0.1-8080-1) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6 hotel0_.id as id0_, hotel0_.address as address0_, hotel0_.city as city0_, hote' at line 1
      
      11:56:07,365 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1344)
      
      11:56:07,376 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1277)
      
      11:56:07,395 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:261)
      
      11:56:07,396 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.ejb.criteria.CriteriaQueryCompiler$3.getResultList(CriteriaQueryCompiler.java:260)
      
      11:56:07,407 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.seam.examples.booking.inventory.HotelSearch.queryHotels(HotelSearch.java:103)
      
      11:56:07,410 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.seam.examples.booking.inventory.HotelSearch.find(HotelSearch.java:65)
      
      11:56:07,420 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      
      11:56:07,428 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      
      11:56:07,438 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      
      11:56:07,440 ERROR [stderr] (http--127.0.0.1-8080-1)      at java.lang.reflect.Method.invoke(Method.java:597)
      
      11:56:07,448 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:51)
      
      11:56:07,457 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,461 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:370)
      
      11:56:07,469 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:114)
      
      11:56:07,485 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:122)
      
      11:56:07,486 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,495 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
      
      11:56:07,503 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,509 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:45)
      
      11:56:07,519 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,525 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ejb3.component.stateful.StatefulSessionSynchronizationInterceptor.processInvocation(StatefulSessionSynchronizationInterceptor.java:132)
      
      11:56:07,536 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,542 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:44)
      
      11:56:07,552 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,559 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
      
      11:56:07,569 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,586 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
      
      11:56:07,587 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,595 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
      
      11:56:07,603 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ee.component.ViewDescription$ComponentDispatcherInterceptor.processInvocation(ViewDescription.java:202)
      
      11:56:07,609 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,619 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.jpa.interceptor.SFSBInvocationInterceptor.processInvocation(SFSBInvocationInterceptor.java:58)
      
      11:56:07,625 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,637 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ejb3.component.stateful.StatefulComponentInstanceInterceptor.processInvocation(StatefulComponentInstanceInterceptor.java:61)
      
      11:56:07,642 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:287)
      
      11:56:07,649 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.as.ejb3.component.session.SessionInvocationContextInterceptor$CustomSessionInvocationContext.proceed(SessionInvocationContextInterceptor.java:126)
      
      11:56:07,673 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:233)
      
      11:56:07,676 ERROR [stderr] (http--127.0.0.1-8080-1)      ... 75 more
      
      11:56:07,677 ERROR [stderr] (http--127.0.0.1-8080-1) Caused by: org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6 hotel0_.id as id0_, hotel0_.address as address0_, hotel0_.city as city0_, hote' at line 1
      
      11:56:07,688 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.exception.internal.SQLStateConverter.convert(SQLStateConverter.java:100)
      
      11:56:07,694 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
      
      11:56:07,705 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      
      11:56:07,714 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:131)
      
      11:56:07,721 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:80)
      
      11:56:07,722 ERROR [stderr] (http--127.0.0.1-8080-1)      at $Proxy118.executeQuery(Unknown Source)
      
      11:56:07,734 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.Loader.getResultSet(Loader.java:1979)
      
      11:56:07,745 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.Loader.doQuery(Loader.java:829)
      
      11:56:07,751 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
      
      11:56:07,760 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.Loader.doList(Loader.java:2449)
      
      11:56:07,761 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.Loader.doList(Loader.java:2435)
      
      11:56:07,763 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      
      11:56:07,764 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.Loader.list(Loader.java:2271)
      
      11:56:07,773 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)
      
      11:56:07,786 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
      
      11:56:07,788 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:196)
      
      11:56:07,793 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1105)
      
      11:56:07,800 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.internal.QueryImpl.list(QueryImpl.java:100)
      
      11:56:07,807 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:252)
      
      11:56:07,811 ERROR [stderr] (http--127.0.0.1-8080-1)      ... 109 more
      
      11:56:07,822 ERROR [stderr] (http--127.0.0.1-8080-1) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6 hotel0_.id as id0_, hotel0_.address as address0_, hotel0_.city as city0_, hote' at line 1
      
      11:56:07,828 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      
      11:56:07,842 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      
      11:56:07,842 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      
      11:56:07,843 ERROR [stderr] (http--127.0.0.1-8080-1)      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      
      11:56:07,843 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      
      11:56:07,844 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.Util.getInstance(Util.java:386)
      
      11:56:07,844 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
      
      11:56:07,846 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
      
      11:56:07,871 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
      
      11:56:07,881 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      
      11:56:07,892 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      
      11:56:07,893 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      
      11:56:07,894 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      
      11:56:07,902 ERROR [stderr] (http--127.0.0.1-8080-1)      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      
      11:56:07,905 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:107)
      
      11:56:07,916 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
      
      11:56:07,922 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      
      11:56:07,932 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      
      11:56:07,940 ERROR [stderr] (http--127.0.0.1-8080-1)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      
      11:56:07,948 ERROR [stderr] (http--127.0.0.1-8080-1)      at java.lang.reflect.Method.invoke(Method.java:597)
      
      11:56:07,953 ERROR [stderr] (http--127.0.0.1-8080-1)      at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:124)
      
      11:56:07,966 ERROR [stderr] (http--127.0.0.1-8080-1)      ... 124 more
      
      11:56:17,160 SEVERE [javax.enterprise.resource.webcontainer.jsf.context] (http--127.0.0.1-8080-1) javax.el.ELException: /search.xhtml @86,86 rendered="#{hotelSearch.previousPageAvailable}": java.lang.NullPointerException
      11:56:17,272 SEVERE [javax.enterprise.resource.webcontainer.jsf.context] (http--127.0.0.1-8080-1) javax.el.ELException: /search.xhtml @86,86 rendered="#{hotelSearch.previousPageAvailable}": java.lang.NullPointerException
      11:56:17,384 SEVERE [javax.enterprise.resource.webcontainer.jsf.context] (http--127.0.0.1-8080-1) javax.el.ELException: /search.xhtml @86,86 rendered="#{hotelSearch.previousPageAvailable}": java.lang.NullPointerException
      11:56:17,492 SEVERE [javax.enterprise.resource.webcontainer.jsf.context] (http--127.0.0.1-8080-1) javax.el.ELException: /search.xhtml @86,86 rendered="#{hotelSearch.previousPageAvailable}": java.lang.NullPointerException
      11:56:17,611 SEVERE [javax.enterprise.resource.webcontainer.jsf.context] (http--127.0.0.1-8080-1) javax.el.ELException: /search.xhtml @86,86 rendered="#{hotelSearch.previousPageAvailable}": java.lang.NullPointerException
      11:56:17,721 SEVERE [javax.enterprise.resource.webcontainer.jsf.context] (http--127.0.0.1-8080-1) javax.el.ELException: /search.xhtml @86,86 rendered="#{hotelSearch.previousPageAvailable}": java.lang.NullPointerException
      12:00:28,950 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA12117: TransactionReaper::check timeout for TX 0:ffff0ade6471:6cb3f918:4ec2c3ab:7 in state  RUN
      12:00:28,959 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA12095: Abort of action id 0:ffff0ade6471:6cb3f918:4ec2c3ab:7 invoked while multiple threads active within it.
      12:00:28,961 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA12108: CheckedAction::check - atomic action 0:ffff0ade6471:6cb3f918:4ec2c3ab:7 aborting with 1 threads active!
      12:00:29,003 WARN  [com.arjuna.ats.jta] (Transaction Reaper Worker 0) ARJUNA16029: SynchronizationImple.afterCompletion - failed for org.jboss.as.jpa.transaction.TransactionUtil$SessionSynchronization@1e7e7ac with exception: java.lang.IllegalStateException
           at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionSynchronizationRegistryImple.getTransactionImple(TransactionSynchronizationRegistryImple.java:225) [jbossjts-4.15.3.Final.jar:]
           at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionSynchronizationRegistryImple.putResource(TransactionSynchronizationRegistryImple.java:103) [jbossjts-4.15.3.Final.jar:]
           at org.jboss.as.jpa.transaction.TransactionUtil.putEntityManagerInTransactionRegistry(TransactionUtil.java:207)
           at org.jboss.as.jpa.transaction.TransactionUtil.access$200(TransactionUtil.java:46)
           at org.jboss.as.jpa.transaction.TransactionUtil$SessionSynchronization.afterCompletion(TransactionUtil.java:232)
           at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.afterCompletion(SynchronizationImple.java:117) [jbossjts-4.15.3.Final.jar:]
           at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.afterCompletion(TwoPhaseCoordinator.java:403) [jbossjts-4.15.3.Final.jar:]
           at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.afterCompletion(TwoPhaseCoordinator.java:335) [jbossjts-4.15.3.Final.jar:]
           at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.cancel(TwoPhaseCoordinator.java:121) [jbossjts-4.15.3.Final.jar:]
           at com.arjuna.ats.arjuna.AtomicAction.cancel(AtomicAction.java:212) [jbossjts-4.15.3.Final.jar:]
           at com.arjuna.ats.arjuna.coordinator.TransactionReaper.doCancellations(TransactionReaper.java:367) [jbossjts-4.15.3.Final.jar:]
           at com.arjuna.ats.internal.arjuna.coordinator.ReaperWorkerThread.run(ReaperWorkerThread.java:79) [jbossjts-4.15.3.Final.jar:]
      
      12:00:29,054 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA12127: TwoPhaseCoordinator.afterCompletion - returned failure for SynchronizationImple< 0:ffff0ade6471:6cb3f918:4ec2c3ab:9, org.jboss.as.jpa.transaction.TransactionUtil$SessionSynchronization@1e7e7ac >
      12:00:29,131 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA12121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 0:ffff0ade6471:6cb3f918:4ec2c3ab:7