Problem with SQL generation

[peter2]

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

[peter2]

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

[peter2]

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

[peter2]

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

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

Greetz,
Pjotr

[shakenbrain]

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