[JBoss Seam] - Re: Mail examples broken in CVS?
by pete.muirï¼ jboss.org
JavaMail (and hence mail-ra.rar) should work with any standards compliant IMAP or POP3 implementation (SSL support is missing, TLS support is there). I've used it with some free POP3/IMAP accounts you can sign up for on the net. POP3 with flush=true is probably the easiest option as then it just pulls all mail from the mailbox and deletes after the MDB has run without an exception being thrown. If you have problems with the connector, post back here and I'll try to help (or post in another forum and tell me about the topic).
We distribute Meldware as its good for examples/dev, not because we recommend using it in your production environment (I'm guessing most places have some email infrastructure existing).
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4076299#4076299
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4076299
18Â years, 8Â months
[Installation, Configuration & DEPLOYMENT] - error null pointer exception
by Mazarj
hey
I get this error:
2007-08-21 16:43:12,199 INFO [STDOUT] Début de la boucle du timeout
2007-08-21 16:43:12,199 INFO [STDOUT] beyrouthyf
2007-08-21 16:43:12,199 INFO [STDOUT] SessID arriving from request: 0
2007-08-21 16:43:12,246 INFO [STDOUT]
IBM SecureWay Host Access Class Library
Version: 3.0.1a-B19990820
Copyright IBM Corporation 1997, 1999. All rights reserved.
2007-08-21 16:43:19,952 INFO [STDOUT] SessID assigned for BEYROUTHYF is 1 The ECLSession id is: com.ibm.eNetwork.ECL.ECLSession@92666
2007-08-21 16:43:19,952 INFO [STDOUT] La connexion de la session 1 est égale = true Et sessID = 0
2007-08-21 16:43:20,046 INFO [STDOUT] Checking beyrouthyf on PHOBOS
2007-08-21 16:43:20,405 INFO [STDOUT] java.lang.NullPointerException
2007-08-21 16:43:20,405 INFO [STDOUT] at java.io.Reader.(Reader.java:61)
2007-08-21 16:43:20,405 INFO [STDOUT] at java.io.InputStreamReader.(InputStreamReader.java:55)
2007-08-21 16:43:20,405 INFO [STDOUT] at sabswing.noyau.accesBase.Lecteur.createStreamReader(Lecteur.java:119)
2007-08-21 16:43:20,405 INFO [STDOUT] at sabswing.noyau.accesBase.Lecteur.createReader(Lecteur.java:137)
2007-08-21 16:43:20,405 INFO [STDOUT] at sabswing.noyau.accesBase.LecteurProjet.build(LecteurProjet.java:72)
2007-08-21 16:43:20,405 INFO [STDOUT] at sabswing.noyau.util.ProjectDeliverer.initProjet(ProjectDeliverer.java:45)
2007-08-21 16:43:20,405 INFO [STDOUT] at sabswing.noyau.util.ProjectDeliverer.getAccesBaseManager(ProjectDeliverer.java:31)
2007-08-21 16:43:20,405 INFO [STDOUT] at sabswing.noyau.util.ProjectDeliverer.getAccesBaseManager(ProjectDeliverer.java:18)
2007-08-21 16:43:20,405 INFO [STDOUT] at sabswing.interactif.context.GestionEnvironnement.login(GestionEnvironnement.java:2062)
2007-08-21 16:43:20,405 INFO [STDOUT] at w2h.servlet.W2HServlet.treatRequest(W2HServlet.java:385)
2007-08-21 16:43:20,405 INFO [STDOUT] at w2h.servlet.W2HServlet.doStuff(W2HServlet.java:170)
2007-08-21 16:43:20,405 INFO [STDOUT] at w2h.servlet.W2HServlet.doPost(W2HServlet.java:166)
2007-08-21 16:43:20,405 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
2007-08-21 16:43:20,405 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
2007-08-21 16:43:20,405 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
2007-08-21 16:43:20,405 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
2007-08-21 16:43:20,421 INFO [STDOUT] java.lang.NullPointerException
2007-08-21 16:43:20,421 INFO [STDOUT] at sabswing.interactif.context.GestionEnvironnement.login(GestionEnvironnement.java:2162)
2007-08-21 16:43:20,421 INFO [STDOUT] at w2h.servlet.W2HServlet.treatRequest(W2HServlet.java:385)
2007-08-21 16:43:20,421 INFO [STDOUT] at w2h.servlet.W2HServlet.doStuff(W2HServlet.java:170)
2007-08-21 16:43:20,421 INFO [STDOUT] at w2h.servlet.W2HServlet.doPost(W2HServlet.java:166)
2007-08-21 16:43:20,421 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
2007-08-21 16:43:20,421 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
2007-08-21 16:43:20,421 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
2007-08-21 16:43:20,421 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
2007-08-21 16:43:20,561 INFO [STDOUT] java.lang.NullPointerException
2007-08-21 16:43:20,561 INFO [STDOUT] at w2h.servlet.W2HServlet.treatRequest(W2HServlet.java:388)
2007-08-21 16:43:20,561 INFO [STDOUT] at w2h.servlet.W2HServlet.doStuff(W2HServlet.java:170)
2007-08-21 16:43:20,561 INFO [STDOUT] at w2h.servlet.W2HServlet.doPost(W2HServlet.java:166)
2007-08-21 16:43:20,561 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
2007-08-21 16:43:20,561 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,561 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
2007-08-21 16:43:20,577 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
2007-08-21 16:43:20,577 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
I need your help as soon as possible
thanks
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4076298#4076298
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4076298
18Â years, 8Â months
[Persistence, JBoss/CMP, Hibernate, Database] - 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 list like this:
| "lower(fbclient.cmpyname) like concat(#{fbclientList.fbclient.cmpyname},'%')"
It works. The generated SQL looks ok, but I can only get the parameterized SQL with the '?''s to show up in my log. I cannot get the trace working so I don't know the exact value that is getting bound to the SQL. In any case it has something to do with the lower function because if I remove it from the restriction then the parameter causes no problems with the generated SQL.
I am not sure if this is a bug in seam or hibernate, or if there is something else I am doing wrong.
Any help or direction would be appreciated.
Thanks.
Environment:
Database: DB2 v9
Hibernate version: 3.2
JBoss version: 4.0.5 (EJB3)
Here is the persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
| <!-- Persistence deployment descriptor for dev profile -->
| <persistence xmlns="http://java.sun.com/xml/ns/persistence"
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
| xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
| version="1.0">
|
| <persistence-unit name="simpleclientlookup">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <jta-data-source>java:/simpleclientlookupDatasource</jta-data-source>
| <properties>
| <property name="hibernate.hbm2ddl.auto" value="validate"/>
| <property name="hibernate.cache.use_query_cache" value="true"/>
| <property name="hibernate.show_sql" value="true"/>
| <property name="jboss.entity.manager.factory.jndi.name" value="java:/simpleclientlookupEntityManagerFactory"/>
| <property name="hibernate.default_schema" value="DB2ADMIN"/>
| <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect"/>
| </properties>
| </persistence-unit>
|
| </persistence>
Here is the stack trace:
| 16:29:32,148 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 7)
| 16:29:32,148 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 7)
| 16:29:32,148 DEBUG [ConnectionManager] opening JDBC connection
| 16:29:32,148 DEBUG [ConnectionManager] opening JDBC connection
| 16:29:32,148 DEBUG [SQL] select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ?
| 16:29:32,148 DEBUG [SQL] select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ?
| 16:29:32,148 DEBUG [SQL] select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ?
| 16:29:32,148 INFO [STDOUT] Hibernate: select * from ( select rownumber() over() as rownumber_, fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%' ) as temp_ where rownumber_ <= ?
| 16:29:32,148 DEBUG [QueryLoader] bindNamedParameters() ua -> el5 [1]
| 16:29:32,148 DEBUG [QueryLoader] bindNamedParameters() ua -> el5 [1]
| 16:29:32,179 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 8)
| 16:29:32,179 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 8)
| 16:29:32,179 DEBUG [ConnectionManager] aggressively releasing JDBC connection
| 16:29:32,179 DEBUG [ConnectionManager] aggressively releasing JDBC connection
| 16:29:32,179 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 7) (open ResultSets: 0, globally: 0)]
| 16:29:32,179 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 7) (open ResultSets: 0, globally: 0)]
| 16:29:32,179 DEBUG [JDBCExceptionReporter] could not execute query [select fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%']
| com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
| at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
| at com.ibm.db2.jcc.c.fg.a(fg.java:1206)
| at com.ibm.db2.jcc.b.gb.g(gb.java:140)
| at com.ibm.db2.jcc.b.gb.a(gb.java:39)
| at com.ibm.db2.jcc.b.w.a(w.java:34)
| at com.ibm.db2.jcc.b.vb.g(vb.java:139)
| at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
| at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
| at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
| at com.ibm.db2.jcc.c.gg.V(gg.java:424)
| at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
| at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
| at org.hibernate.loader.Loader.doQuery(Loader.java:662)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
| at org.hibernate.loader.Loader.doList(Loader.java:2144)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
| at org.hibernate.loader.Loader.list(Loader.java:2023)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
| at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42)
| at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.jboss.seam.util.Reflections.invoke(Reflections.java:20)
| at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
| at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32)
| at org.jboss.seam.util.Work.workInTransaction(Work.java:37)
| at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103)
| at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151)
| at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87)
| at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java)
| at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438)
| at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82)
| at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141)
| at com.sun.el.parser.AstValue.getValue(AstValue.java:125)
| at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49)
| at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195)
| at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
| at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56)
| at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278)
| at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54)
| at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291)
| at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302)
| at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81)
| at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
| at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
| at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
| at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
| at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
| at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
| at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
| at java.lang.Thread.run(Thread.java:595)
| 16:29:32,179 DEBUG [JDBCExceptionReporter] could not execute query [select fbclient0_.CLIENTID as CLIENTID0_, fbclient0_.PREFIX as PREFIX0_, fbclient0_.SUFFIX as SUFFIX0_, fbclient0_.CLNTTYPE as CLNTTYPE0_, fbclient0_.MEMBERNO as MEMBERNO0_, fbclient0_.FNAME as FNAME0_, fbclient0_.MNAME as MNAME0_, fbclient0_.LNAME as LNAME0_, fbclient0_.CMPYNAME as CMPYNAME0_, fbclient0_.BIRTHDATE as BIRTHDATE0_, fbclient0_.SEX as SEX0_, fbclient0_.MARITAL as MARITAL0_, fbclient0_.SSN as SSN0_, fbclient0_.SEARCH as SEARCH0_, fbclient0_.NOTES as NOTES0_, fbclient0_.OCCUPATION as OCCUPATION0_, fbclient0_.CLNTTYPE2 as CLNTTYPE17_0_, fbclient0_.FEDSUFFIX as FEDSUFFIX0_, fbclient0_.HOMEPHONENUMBER as HOMEPHO19_0_, fbclient0_.WORKPHONENUMBER as WORKPHO20_0_, fbclient0_.EMAILADDRESS as EMAILAD21_0_, fbclient0_.CELLPHONENUMBER as CELLPHO22_0_, fbclient0_.PARENTCLIENTID as PARENTC23_0_, fbclient0_.CLIENTSUBTYPE as CLIENTS24_0_, fbclient0_.LEGACY_MEMBERNO as LEGACY25_0_, fbclient0_.LEGACY_FEDSUFFIX as LEGACY26_0_, fbclient0_.LEGACY_NAMEANDADDRESS1 as LEGACY27_0_, fbclient0_.LEGACY_NAMEANDADDRESS2 as LEGACY28_0_, fbclient0_.LEGACY_NAMEANDADDRESS3 as LEGACY29_0_, fbclient0_.LEGACY_NAMEANDADDRESS4 as LEGACY30_0_, fbclient0_.LEGACY_NAMEANDADDRESS5 as LEGACY31_0_, fbclient0_.LEGACY_NAMEANDADDRESS6 as LEGACY32_0_, fbclient0_.LEGACY_NAMEADDRESSCODE1 as LEGACY33_0_, fbclient0_.LEGACY_NAMEADDRESSCODE2 as LEGACY34_0_, fbclient0_.LEGACY_NAMEADDRESSCODE3 as LEGACY35_0_, fbclient0_.LEGACY_NAMEADDRESSCODE4 as LEGACY36_0_, fbclient0_.LEGACY_NAMEADDRESSCODE5 as LEGACY37_0_, fbclient0_.LEGACY_NAMEADDRESSCODE6 as LEGACY38_0_, fbclient0_.LEGACY_NAMEORDINAL as LEGACY39_0_, fbclient0_.LEGACY_MEMBERSHIPTYPE as LEGACY40_0_, fbclient0_.LEGACY_TYPEBUSINESS as LEGACY41_0_, fbclient0_.LEGACY_X_REFERENCE_1 as LEGACY42_0_, fbclient0_.LEGACY_X_REFERENCE_2 as LEGACY43_0_, fbclient0_.LEGACY_X_REFERENCE_3 as LEGACY44_0_ from DB2ADMIN.FBCLIENT fbclient0_ where lower(fbclient0_.CMPYNAME) like lower(?)||'%']
| com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
| at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
| at com.ibm.db2.jcc.c.fg.a(fg.java:1206)
| at com.ibm.db2.jcc.b.gb.g(gb.java:140)
| at com.ibm.db2.jcc.b.gb.a(gb.java:39)
| at com.ibm.db2.jcc.b.w.a(w.java:34)
| at com.ibm.db2.jcc.b.vb.g(vb.java:139)
| at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
| at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
| at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
| at com.ibm.db2.jcc.c.gg.V(gg.java:424)
| at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
| at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
| at org.hibernate.loader.Loader.doQuery(Loader.java:662)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
| at org.hibernate.loader.Loader.doList(Loader.java:2144)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
| at org.hibernate.loader.Loader.list(Loader.java:2023)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
| at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42)
| at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.jboss.seam.util.Reflections.invoke(Reflections.java:20)
| at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
| at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32)
| at org.jboss.seam.util.Work.workInTransaction(Work.java:37)
| at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103)
| at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151)
| at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87)
| at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java)
| at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438)
| at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82)
| at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141)
| at com.sun.el.parser.AstValue.getValue(AstValue.java:125)
| at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49)
| at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195)
| at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
| at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56)
| at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278)
| at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54)
| at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291)
| at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302)
| at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81)
| at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
| at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
| at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
| at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
| at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
| at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
| at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
| at java.lang.Thread.run(Thread.java:595)
| 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -418, SQLState: 42610
| 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -418, SQLState: 42610
| 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
| 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
| 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098
| 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098
| 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610;
| 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610;
| 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098
| 16:29:32,179 WARN [JDBCExceptionReporter] SQL Error: -727, SQLState: 56098
| 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610;
| 16:29:32,179 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-418;42610;
| 16:29:32,179 DEBUG [AbstractEntityManagerImpl] mark transaction for rollback
| 16:29:32,179 DEBUG [AbstractEntityManagerImpl] mark transaction for rollback
| 16:29:32,179 ERROR [ExceptionFilter] uncaught exception
| javax.servlet.ServletException: /FbclientList.xhtml @204,61 rendered="#{empty fbclientList.resultList}": Exception getting value of property resultList of base of type : com.idfbins.entity.FbclientList_$$_javassist_1
| at javax.faces.webapp.FacesServlet.service(FacesServlet.java:152)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
| at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
| at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
| at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
| at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
| at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
| at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
| at java.lang.Thread.run(Thread.java:595)
| 16:29:32,179 ERROR [ExceptionFilter] exception root cause
| javax.faces.el.EvaluationException: /FbclientList.xhtml @204,61 rendered="#{empty fbclientList.resultList}": Exception getting value of property resultList of base of type : com.idfbins.entity.FbclientList_$$_javassist_1
| at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:60)
| at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278)
| at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54)
| at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291)
| at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302)
| at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81)
| at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
| at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
| at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
| at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
| at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
| at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
| at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
| at java.lang.Thread.run(Thread.java:595)
| Caused by: javax.faces.el.EvaluationException: Bean: com.idfbins.entity.FbclientList_$$_javassist_1, property: resultList
| at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:442)
| at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82)
| at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141)
| at com.sun.el.parser.AstValue.getValue(AstValue.java:125)
| at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49)
| at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195)
| at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
| at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56)
| ... 49 more
| Caused by: java.lang.reflect.InvocationTargetException
| at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438)
| ... 56 more
| Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
| at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:647)
| at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)
| at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42)
| at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.jboss.seam.util.Reflections.invoke(Reflections.java:20)
| at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
| at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32)
| at org.jboss.seam.util.Work.workInTransaction(Work.java:37)
| at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103)
| at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151)
| at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87)
| at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java)
| ... 60 more
| Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.loader.Loader.doList(Loader.java:2147)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
| at org.hibernate.loader.Loader.list(Loader.java:2023)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
| ... 79 more
| Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
| at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
| at com.ibm.db2.jcc.c.fg.a(fg.java:1206)
| at com.ibm.db2.jcc.b.gb.g(gb.java:140)
| at com.ibm.db2.jcc.b.gb.a(gb.java:39)
| at com.ibm.db2.jcc.b.w.a(w.java:34)
| at com.ibm.db2.jcc.b.vb.g(vb.java:139)
| at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
| at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
| at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
| at com.ibm.db2.jcc.c.gg.V(gg.java:424)
| at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
| at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
| at org.hibernate.loader.Loader.doQuery(Loader.java:662)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
| at org.hibernate.loader.Loader.doList(Loader.java:2144)
| ... 87 more
| 16:29:32,226 ERROR [DebugPageHandler] redirecting to debug page
| com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
| at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
| at com.ibm.db2.jcc.c.fg.a(fg.java:1206)
| at com.ibm.db2.jcc.b.gb.g(gb.java:140)
| at com.ibm.db2.jcc.b.gb.a(gb.java:39)
| at com.ibm.db2.jcc.b.w.a(w.java:34)
| at com.ibm.db2.jcc.b.vb.g(vb.java:139)
| at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
| at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
| at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
| at com.ibm.db2.jcc.c.gg.V(gg.java:424)
| at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
| at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
| at org.hibernate.loader.Loader.doQuery(Loader.java:662)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
| at org.hibernate.loader.Loader.doList(Loader.java:2144)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
| at org.hibernate.loader.Loader.list(Loader.java:2023)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
| at org.jboss.seam.framework.EntityQuery.getResultList(EntityQuery.java:42)
| at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.jboss.seam.util.Reflections.invoke(Reflections.java:20)
| at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
| at org.jboss.seam.interceptors.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:34)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.TransactionInterceptor$1.work(TransactionInterceptor.java:32)
| at org.jboss.seam.util.Work.workInTransaction(Work.java:37)
| at org.jboss.seam.interceptors.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27)
| at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
| at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103)
| at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:151)
| at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:87)
| at com.idfbins.entity.FbclientList_$$_javassist_1.getResultList(FbclientList_$$_javassist_1.java)
| at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438)
| at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82)
| at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141)
| at com.sun.el.parser.AstValue.getValue(AstValue.java:125)
| at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:49)
| at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195)
| at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
| at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56)
| at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1075)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:640)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIComponentBase.processUpdates(UIComponentBase.java:645)
| at javax.faces.component.UIViewRoot.processUpdates(UIViewRoot.java:157)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.access$101(AjaxViewRoot.java:53)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot$2.invokeRoot(AjaxViewRoot.java:278)
| at org.ajax4jsf.framework.ajax.JsfOneOneInvoker.invokeOnRegionOrRoot(JsfOneOneInvoker.java:54)
| at org.ajax4jsf.framework.ajax.AjaxContext.invokeOnRegionOrRoot(AjaxContext.java:176)
| at org.ajax4jsf.framework.ajax.AjaxViewRoot.processUpdates(AjaxViewRoot.java:291)
| at org.apache.myfaces.lifecycle.LifecycleImpl.updateModelValues(LifecycleImpl.java:302)
| at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:81)
| at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
| at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79)
| at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
| at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:96)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:220)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
| at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
| at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
| at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
| at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
| at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
| at java.lang.Thread.run(Thread.java:595)
| 16:29:32,726 ERROR [STDERR] Aug 20, 2007 4:29:32 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit
| INFO: Added Library from: jar:file:/C:/dev/jboss-4.0.5.ejb3/server/default/./deploy/simpleclientlookup.ear/simpleclientlookup.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/jstl-fn.taglib.xml
| 16:29:32,726 ERROR [STDERR] Aug 20, 2007 4:29:32 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4076296#4076296
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4076296
18Â years, 8Â months