[JBoss Seam] - EntityList Restrictions generates invalid SQL for DB2
by jfrankman
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
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4076060#4076060
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4076060
18Â years, 9Â months
[JBoss Messaging] - Exception launching second node in cluster (Cannot find obje
by daveespo
I'm running JBOSSAS 4.2.1GA
I installed JBoss Messating 1.4.0 using the instructions here:
http://labs.jboss.com/file-access/default/members/jbossmessaging/freezone...
(Sections 4.1.1 followed by 4.1.3)
I have two machines that are sharing the same MySQL database ... I have configured one with ServerPeerID = 0 and the other with ServerPeerID = 1
When I launch the first node, it starts cleanly.
When I launch the second node, it seems to be starting cleanly and the first node shows that it has joined the cluster. But shortly before the second node finishes initialization, I receive the following stack trace (snipped)
| 18:06:32,715 ERROR [JBossConnectionFactory] Failed to download and/or install client side AOP stack
| org.jboss.jms.exception.MessagingJMSException: Failed to invoke
| at org.jboss.jms.client.delegate.DelegateSupport.handleThrowable(DelegateSupport.java:247)
| at
| <SNIP>
| Caused by: java.lang.IllegalStateException: Cannot find object with ID 8-q1poil5f-1-ozvnil5f-xpin8f-1n12a in dispatcher
| at org.jboss.jms.wireformat.ConnectionFactoryGetClientAOPStackRequest.serverInvoke(ConnectionFactoryGetClientAOPStackRequest.java:75)
| at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:165)
| at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:734)
| at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:101)
| at org.jboss.remoting.Client.invoke(Client.java:1550)
| at org.jboss.remoting.Client.invoke(Client.java:530)
| at org.jboss.remoting.Client.invoke(Client.java:518)
| at org.jboss.jms.client.delegate.DelegateSupport.doInvoke(DelegateSupport.java:186)
| ... 132 more
|
I receive a similar exception on the first node:
| 18:06:34,816 ERROR [ClusterConnectionManager] Failed to start connection info
| org.jboss.jms.exception.MessagingJMSException: Failed to invoke
| at org.jboss.jms.client.delegate.DelegateSupport.handleThrowable(DelegateSupport.java:247)
| at org.jboss.jms.client.delegate.ClientConnectionFactoryDelegate.org$jboss$jms$client$delegate$ClientConnectionFactoryDelegate$createConnectionDelegate$aop(ClientConnectionFactoryDelegate.java:179)
| <SNIP>
| Caused by: java.lang.IllegalStateException: Cannot find object in dispatcher with id 8-kgnpil5f-1-wvwoil5f-p1sux9-1q12a
| at org.jboss.jms.wireformat.ConnectionFactoryCreateConnectionDelegateRequest.serverInvoke(ConnectionFactoryCreateConnectionDelegateRequest.java:100)
| at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:165)
| at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:734)
| at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:101)
| at org.jboss.remoting.Client.invoke(Client.java:1550)
| at org.jboss.remoting.Client.invoke(Client.java:530)
| at org.jboss.jms.client.delegate.ClientConnectionFactoryDelegate.org$jboss$jms$client$delegate$ClientConnectionFactoryDelegate$createConnectionDelegate$aop(ClientConnectionFactoryDelegate.java:159)
| ... 21 more
|
What is my next step for troubleshooting this problem?
Thanks in advance,
Dave
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4076057#4076057
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4076057
18Â years, 9Â months