0 Replies Latest reply on Aug 21, 2007 9:44 AM by jfrankman

    EntityList Restrictions generates invalid SQL for DB2

    jfrankman Novice

      I 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 list 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