EntityList Restrictions generates invalid SQL for DB2
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 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
