4 Replies Latest reply on Jun 1, 2007 3:18 PM by Tom Barry

    Problem with SQL generation

    Pjotr Newbie

      Dear all, let me ask this noob question ;-)

      I created a Seam application with seam gen on a AS400/DB2 database. Clicking on the list gives me the expected result. But as soon as a add a search criteria I get errors and I pinpointed it down to this

      ......from S65E5B3F.TESTFEBEL.KLALGEMEEN klalgemeen0_ where lower(klalgemeen0_.TITEL) like lower(?)||'%' fetch first 25 rows only

      17:31:15,301 WARN [JDBCExceptionReporter] SQL Error: -418, SQLState: 42610
      17:31:15,301 ERROR [JDBCExceptionReporter] [SQL0418] Use of || is not legal for parameter

      Where can I modify code / configuration to get rid of this problem?

      Tnx for your time and effort.
      Greetz,
      Pjotr

        • 1. Re: Problem with SQL generation
          Pjotr Newbie

          Could this be a problem with the dialect I configured Hibernate to use?
          Please help, just a hint were I have to look

          • 2. Re: Problem with SQL generation
            Pjotr Newbie

            OK update. Please help me out cause I need this to work by next tuesday.

            Digging into the stuff with the debugger I got to an invocation error

            this is the message

            Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=tp_pefr/222, BranchQual=, localId=222]


            and this is the stack I got from my IDE

            T
            hread [http-localhost%2F127.0.0.1-8080-3] (Suspended)
             Reflections.invoke(Method, Object, Object...) line: 34
             RootInvocationContext.proceed() line: 31
             EE5SeamInvocationContext(SeamInvocationContext).proceed() line: 57
             RollbackInterceptor.aroundInvoke(InvocationContext) line: 34
             EE5SeamInvocationContext(SeamInvocationContext).proceed() line: 69
             TransactionInterceptor$1.work() line: 32
             TransactionInterceptor$1(Work<T>).workInTransaction() line: 37
             TransactionInterceptor.aroundInvoke(InvocationContext) line: 27
             EE5SeamInvocationContext(SeamInvocationContext).proceed() line: 69
             MethodContextInterceptor.aroundInvoke(InvocationContext) line: 27
             EE5SeamInvocationContext(SeamInvocationContext).proceed() line: 69
             JavaBeanInterceptor(RootInterceptor).invoke(InvocationContext, EventType) line: 103
             JavaBeanInterceptor.interceptInvocation(Method, Object[]) line: 151
             JavaBeanInterceptor.invoke(Object, Method, Method, Object[]) line: 87
             KlalgemeenList_$$_javassist_6.getResultList() line: not available
             NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not available [native method]
             NativeMethodAccessorImpl.invoke(Object, Object[]) line: not available
             DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: not available
             Method.invoke(Object, Object...) line: not available
             PropertyResolverImpl.getProperty(Object, String) line: 438
             PropertyResolverImpl.getValue(Object, Object) line: 82
             LegacyELContext$LegacyELResolver.getValue(ELContext, Object, Object) line: 141
             AstValue.getValue(EvaluationContext) line: 125
             AstEmpty.getValue(EvaluationContext) line: 49
             ValueExpressionImpl.getValue(ELContext) line: 195
             TagValueExpression.getValue(ELContext) line: 71
             LegacyValueBinding.getValue(FacesContext) line: 56
             HtmlOutputText(UIComponentBase).isRendered() line: 1075
             HtmlOutputText(UIComponentBase).processUpdates(FacesContext) line: 640
             HtmlPanel(UIComponentBase).processUpdates(FacesContext) line: 645
             HtmlPanel(UIComponentBase).processUpdates(FacesContext) line: 645
             HtmlPanelGrid(UIComponentBase).processUpdates(FacesContext) line: 645
             AjaxViewRoot(UIComponentBase).processUpdates(FacesContext) line: 645
             AjaxViewRoot(UIViewRoot).processUpdates(FacesContext) line: 157
             AjaxViewRoot.access$101(AjaxViewRoot, FacesContext) line: 53
             AjaxViewRoot$2.invokeRoot(FacesContext) line: 278
             JsfOneOneInvoker.invokeOnRegionOrRoot(AjaxViewRoot, FacesContext, InvokerCallback, PhaseId) line: 54
             AjaxContext.invokeOnRegionOrRoot(AjaxViewRoot, FacesContext, InvokerCallback, PhaseId) line: 176
             AjaxViewRoot.processUpdates(FacesContext) line: 291
             LifecycleImpl.updateModelValues(FacesContext, PhaseListenerManager) line: 302
             LifecycleImpl.execute(FacesContext) line: 81
             FacesServlet.service(ServletRequest, ServletResponse) line: 137
             ApplicationFilterChain.internalDoFilter(ServletRequest, ServletResponse) line: 252
             ApplicationFilterChain.doFilter(ServletRequest, ServletResponse) line: 173
             SeamFilter$FilterChainImpl.doFilter(ServletRequest, ServletResponse) line: 63
             HotDeployFilter.doFilter(ServletRequest, ServletResponse, FilterChain) line: 60
             SeamFilter$FilterChainImpl.doFilter(ServletRequest, ServletResponse) line: 49
             RedirectFilter.doFilter(ServletRequest, ServletResponse, FilterChain) line: 45
             SeamFilter$FilterChainImpl.doFilter(ServletRequest, ServletResponse) line: 49
             ExceptionFilter.doFilter(ServletRequest, ServletResponse, FilterChain) line: 57
             SeamFilter$FilterChainImpl.doFilter(ServletRequest, ServletResponse) line: 49
             MultipartFilter.doFilter(ServletRequest, ServletResponse, FilterChain) line: 79
             SeamFilter$FilterChainImpl.doFilter(ServletRequest, ServletResponse) line: 49
             SeamFilter.doFilter(ServletRequest, ServletResponse, FilterChain) line: 84
             ApplicationFilterChain.internalDoFilter(ServletRequest, ServletResponse) line: 202
             ApplicationFilterChain.doFilter(ServletRequest, ServletResponse) line: 173
             TidyXMLFilter(BaseXMLFilter).doXmlFilter(FilterChain, HttpServletRequest, HttpServletResponse) line: 96
             Filter(BaseFilter).doFilter(ServletRequest, ServletResponse, FilterChain) line: 220
             ApplicationFilterChain.internalDoFilter(ServletRequest, ServletResponse) line: 202
             ApplicationFilterChain.doFilter(ServletRequest, ServletResponse) line: 173
             ReplyHeaderFilter.doFilter(ServletRequest, ServletResponse, FilterChain) line: 96
             ApplicationFilterChain.internalDoFilter(ServletRequest, ServletResponse) line: 202
             ApplicationFilterChain.doFilter(ServletRequest, ServletResponse) line: 173
             StandardWrapperValve.invoke(Request, Response) line: 213
             StandardContextValve.invoke(Request, Response) line: 178
             SecurityAssociationValve.invoke(Request, Response) line: 175
             NonLoginAuthenticator(AuthenticatorBase).invoke(Request, Response) line: 432
             JaccContextValve.invoke(Request, Response) line: 74
             StandardHostValve.invoke(Request, Response) line: 126
             ErrorReportValve.invoke(Request, Response) line: 105
             CachedConnectionValve.invoke(Request, Response) line: 156
             StandardEngineValve.invoke(Request, Response) line: 107
             CoyoteAdapter.service(Request, Response) line: 148
             Http11Processor.process(InputStream, OutputStream) line: 869
             Http11Protocol$JmxHttp11ConnectionHandler(Http11BaseProtocol$Http11ConnectionHandler).processConnection(TcpConnection, Object[]) line: 664
             PoolTcpEndpoint.processSocket(Socket, TcpConnection, Object[]) line: 527
             MasterSlaveWorkerThread.run() line: 112
             ThreadWithAttributes(Thread).run() line: not available
            
            


            • 3. Re: Problem with SQL generation
              Pjotr Newbie

              Please tell me if I'm really asking stupid things.

              Yes sorry to spam the forum but I'm desperate.......

              Greetz,
              Pjotr

              • 4. Re: Problem with SQL generation
                Tom Barry Newbie

                This looks like a hibernate dialect issue and you're probably better off asking in the hibernate forum...