anyone using c3p0 with seam???
deanhiller2000 May 25, 2010 7:32 AMI was trying out c3p0 with tomcat and seam, and c3p0's testConnectionOnCheckout so it behaves like jboss but on taking the database down and hitting any page in seam, seam ends up in infinite redirect with IE (with firefox, firefox had the smarts to break the redirect after 15 tries or so and say it detected a redirect).
This is really bad if the database goes down and then the server is nailed as all your users who hit one page go into infinite redirect.
I notice that in any connection pools, testConnectionOnCheckout causes these seam infinite redirects(jboss pool did the same thing to me on another project).
Any ideas how to work around this? I just want the same hack I used on jboss project....redirect to error.jsp and don't use error.xhtml at all so it ends up in JSF instead of seam.
The exact log I keep seeing is these over and over....(NOTICE there is no exception for me to redirect on or I could fix this with the hack I had last time). THANKS for any ideas you can give me.
May 24, 2010 11:21:14 PM org.hibernate.util.JDBCExceptionReporter logExceptions WARNING: [mainapp][s:72EC56,r:3]SQL Error: 0, SQLState: null May 24, 2010 11:21:14 PM org.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: [mainapp][s:72EC56,r:3]An attempt by a client to checkout a Connection has timed out. May 24, 2010 11:21:14 PM org.exadel.jsf.PhaseTracker beforePhase INFO: [mainapp][s:72EC56,r:3]BEFORE RENDER_RESPONSE 6 May 24, 2010 11:21:14 PM org.exadel.jsf.PhaseTracker afterPhase INFO: [mainapp][s:72EC56,r:3]AFTER RENDER_RESPONSE 6 May 24, 2010 11:21:14 PM com.alvazan.logging.FilterLogHttpRequest doFilter INFO: [mainapp][s:72EC56,r:3][time(ms):2122] url=http://dev.alvazan.com:8081/mainapp/web/debug.xhtml May 24, 2010 11:21:14 PM com.alvazan.logging.FilterLogHttpRequest doFilter INFO: [mainapp][s:72EC56,r:4]url=http://dev.alvazan.com:8081/mainapp/web/debug.xhtml params={cid=2,} May 24, 2010 11:21:14 PM org.exadel.jsf.PhaseTracker beforePhase INFO: [mainapp][s:72EC56,r:4]BEFORE RESTORE_VIEW 1 May 24, 2010 11:21:14 PM org.exadel.jsf.PhaseTracker afterPhase INFO: [mainapp][s:72EC56,r:4]AFTER RESTORE_VIEW 1 May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jboss-seam-mail.jar!/META-INF/seam-mail.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jboss-seam-pdf.jar!/META-INF/seam-pdf.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jboss-seam-ui.jar!/META-INF/s.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jsf-facelets.jar!/META-INF/jsf-core.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jsf-facelets.jar!/META-INF/jsf-html.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jsf-facelets.jar!/META-INF/jsf-ui.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jsf-facelets.jar!/META-INF/jstl-core.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/jsf-facelets.jar!/META-INF/jstl-fn.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/richfaces-ui.jar!/META-INF/a4j.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/richfaces-ui.jar!/META-INF/ajax4jsf.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/xsoftware/tomcat6ForDev/shared/lib/richfaces-ui.jar!/META-INF/jsp.taglib.xml May 24, 2010 11:21:15 PM com.sun.facelets.compiler.TagLibraryConfig loadImplicit INFO: [mainapp][s:72EC56,r:4]Added Library from: jar:file:/C:/AAROOT/areas/x