EntityList Restrictions generates invalid SQL for DB2
jfrankman Aug 20, 2007 6:33 PMI am using seam-gen (SEAM v1.2 ) to generate an simple application. After generating the application I can bring up the [entityname]List.xhtml page. I can also page through the records successfully. But when I try to set the search parameters to any sort of value the query fails.
I beleive the problem has to do with binding the parameter to the 'lower' hql function used in the generated restrictions array. The following restriction fails:
"lower(fbclient.cmpyname) like concat(lower(#{fbclientList.fbclient.cmpyname}),'%')"
But if I remove the lower function from the parameter like this:
"lower(fbclient.cmpyname) like concat(#{fbclientList.fbclient.cmpyname},'%')"
It works. The generated SQL looks ok, but I can only get the parameterized SQL with the '?''s to show up in my log. I cannot get the trace working so I don't know the exact value that is getting bound to the SQL. In any case it has something to do with the lower function because if I remove it from the restriction then the parameter causes no problems with the generated SQL.
I am not sure if this is a bug in seam or hibernate, or if there is something else I am doing wrong.
Any help or direction would be appreciated.
Thanks.
Environment:
Database: DB2 v9
Hibernate version: 3.2
JBoss version: 4.0.5 (EJB3)
Here is the persistence.xml
<?xml version="1.0" encoding="UTF-8"?> <!-- Persistence deployment descriptor for dev profile --> <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0"> <persistence-unit name="simpleclientlookup"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <jta-data-source>java:/simpleclientlookupDatasource</jta-data-source> <properties> <property name="hibernate.hbm2ddl.auto" value="validate"/> <property name="hibernate.cache.use_query_cache" value="true"/> <property name="hibernate.show_sql" value="true"/> <property name="jboss.entity.manager.factory.jndi.name" value="java:/simpleclientlookupEntityManagerFactory"/> <property name="hibernate.default_schema" value="DB2ADMIN"/> <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect"/> </properties> </persistence-unit> </persistence>
Here is the stack trace:
16:29:32,148 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 7) 16:29:32,148 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 7) 16:29:32,148 DEBUG [ConnectionManager] opening JDBC connection 16:29:32,148 DEBUG [ConnectionManager] opening JDBC connection 16:29:32,148 DEBUG [SQL] select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ? 16:29:32,148 DEBUG [SQL] select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ? 16:29:32,148 DEBUG [SQL] select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ? 16:29:32,148 INFO [STDOUT] Hibernate: select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ? 16:29:32,148 DEBUG [QueryLoader] bindNamedParameters() ua -> el5 [1] 16:29:32,148 DEBUG [QueryLoader] bindNamedParameters() ua -> el5 [1] 16:29:32,179 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 8) 16:29:32,179 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 8) 16:29:32,179 DEBUG [ConnectionManager] aggressively releasing JDBC connection 16:29:32,179 DEBUG [ConnectionManager] aggressively releasing JDBC connection 16:29:32,179 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 7) (open ResultSets: 0, globally: 0)] 16:29:32,179 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 7) (open ResultSets: 0, globally: 0)] 16:29:32,179 DEBUG [JDBCExceptionReporter] could not execute query [select fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%'] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null at com.ibm.db2.jcc.c.fg.e(fg.java:1596) at com.ibm.db2.jcc.c.fg.a(fg.java:1206) at com.ibm.db2.jcc.b.gb.g(gb.java:140) at com.ibm.db2.jcc.b.gb.a(gb.java:39) at com.ibm.db2.jcc.b.w.a(w.java:34) at com.ibm.db2.jcc.b.vb.g(vb.java:139) at com.ibm.db2.jcc.c.fg.n(fg.java:1177) at com.ibm.db2.jcc.c.gg.eb(gg.java:1862) at com.ibm.db2.jcc.c.gg.d(gg.java:2295) at com.ibm.db2.jcc.c.gg.V(gg.java:424) at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64) at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42) at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.seam.util.Reflections.invoke(Reflections.java:20) at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57) at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32) at org.jboss.seam.util.Work.workInTransaction(Work.java:37) at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103) at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151) at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87) at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java) at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438) at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82) at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141) at com.sun.el.parser.AstValue.getValue(AstValue.java:125) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195) at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71) at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56) at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157) at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53) at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278) at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54) at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176) at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291) at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63) at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96) at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 16:29:32,179 DEBUG [JDBCExceptionReporter] could not execute query [select fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%'] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null at com.ibm.db2.jcc.c.fg.e(fg.java:1596) at com.ibm.db2.jcc.c.fg.a(fg.java:1206) at com.ibm.db2.jcc.b.gb.g(gb.java:140) at com.ibm.db2.jcc.b.gb.a(gb.java:39) at com.ibm.db2.jcc.b.w.a(w.java:34) at com.ibm.db2.jcc.b.vb.g(vb.java:139) at com.ibm.db2.jcc.c.fg.n(fg.java:1177) at com.ibm.db2.jcc.c.gg.eb(gg.java:1862) at com.ibm.db2.jcc.c.gg.d(gg.java:2295) at com.ibm.db2.jcc.c.gg.V(gg.java:424) at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64) at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42) at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.seam.util.Reflections.invoke(Reflections.java:20) at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57) at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32) at org.jboss.seam.util.Work.workInTransaction(Work.java:37) at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103) at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151) at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87) at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java) at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438) at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82) at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141) at com.sun.el.parser.AstValue.getValue(AstValue.java:125) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195) at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71) at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56) at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157) at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53) at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278) at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54) at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176) at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291) at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63) at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96) at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -418, SQLState: 42610 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -418, SQLState: 42610 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610; 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610; 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610; 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610; 16:29:32,179 DEBUG [AbstractEntityManagerImpl] mark transaction for rollback 16:29:32,179 DEBUG [AbstractEntityManagerImpl] mark transaction for rollback 16:29:32,179 ERROR [ExceptionFilter] uncaught exception javax.servlet.ServletException: /FbclientList.xhtml @204,61 rendered="#{empty fbclientList.resultList}": Exception getting value of property resultList of base of type : com.idfbins.entity.FbclientList_$$_javassist_1 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:152) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63) at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96) at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 16:29:32,179 ERROR [ExceptionFilter] exception root cause javax.faces.el.EvaluationException: /FbclientList.xhtml @204,61 rendered="#{empty fbclientList.resultList}": Exception getting value of property resultList of base of type : com.idfbins.entity.FbclientList_$$_javassist_1 at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:60) at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157) at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53) at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278) at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54) at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176) at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291) at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63) at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96) at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: javax.faces.el.EvaluationException: Bean: com.idfbins.entity.FbclientList_$$_javassist_1, property: resultList at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:442) at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82) at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141) at com.sun.el.parser.AstValue.getValue(AstValue.java:125) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195) at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71) at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56) ... 49 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438) ... 56 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:647) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73) at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42) at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.seam.util.Reflections.invoke(Reflections.java:20) at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57) at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32) at org.jboss.seam.util.Work.workInTransaction(Work.java:37) at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103) at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151) at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87) at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java) ... 60 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2147) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64) ... 79 more Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null at com.ibm.db2.jcc.c.fg.e(fg.java:1596) at com.ibm.db2.jcc.c.fg.a(fg.java:1206) at com.ibm.db2.jcc.b.gb.g(gb.java:140) at com.ibm.db2.jcc.b.gb.a(gb.java:39) at com.ibm.db2.jcc.b.w.a(w.java:34) at com.ibm.db2.jcc.b.vb.g(vb.java:139) at com.ibm.db2.jcc.c.fg.n(fg.java:1177) at com.ibm.db2.jcc.c.gg.eb(gg.java:1862) at com.ibm.db2.jcc.c.gg.d(gg.java:2295) at com.ibm.db2.jcc.c.gg.V(gg.java:424) at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) ... 87 more 16:29:32,226 ERROR [DebugPageHandler] redirecting to debug page com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null at com.ibm.db2.jcc.c.fg.e(fg.java:1596) at com.ibm.db2.jcc.c.fg.a(fg.java:1206) at com.ibm.db2.jcc.b.gb.g(gb.java:140) at com.ibm.db2.jcc.b.gb.a(gb.java:39) at com.ibm.db2.jcc.b.w.a(w.java:34) at com.ibm.db2.jcc.b.vb.g(vb.java:139) at com.ibm.db2.jcc.c.fg.n(fg.java:1177) at com.ibm.db2.jcc.c.gg.eb(gg.java:1862) at com.ibm.db2.jcc.c.gg.d(gg.java:2295) at com.ibm.db2.jcc.c.gg.V(gg.java:424) at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64) at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42) at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.seam.util.Reflections.invoke(Reflections.java:20) at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57) at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32) at org.jboss.seam.util.Work.workInTransaction(Work.java:37) at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69) at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103) at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151) at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87) at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java) at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438) at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82) at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141) at com.sun.el.parser.AstValue.getValue(AstValue.java:125) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195) at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71) at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56) at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645) at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157) at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53) at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278) at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54) at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176) at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291) at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63) at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79) at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49) at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96) at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 16:29:32,726 ERROR [STDERR] Aug 20, 2007 4:29:32 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: Added Library from: jar:file:/C:/dev/jboss-4.0.5.ejb3/server/default/./deploy/simpleclientlookup.ear/simpleclientlookup.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/jstl-fn.taglib.xml 16:29:32,726 ERROR [STDERR] Aug 20, 2007 4:29:32 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit