We are using Quartz (1.5.?) without problems (for a year) with spring (1.2.6) and acegi but its not Appfuse. We have three things hitting the database: Hibernate, Spring JDBC template code and Quartz. (I didn't see you mention if you tied Quartz to the database.) We are using Struts 1.2 and WebSphere instead of Tomcat but have run the code against MySql, Oracle and HSQLDB (testing only). The whole thing is clustered including WebSphere and Quartz.
You might try putting Quartz into memory only mode and disabling its DB access. You do have to set up the schedules in the XML and that might not work on your app. If the connection problem goes away with Quartz not hitting the DB then you know Quartz is key to the problem. Thanks. -- Lee On 9/21/07, Brett Knights <[EMAIL PROTECTED]> wrote: > > Hello, > > I have an appfuse 1.9.3 project that uses Spring MVC and iBatis and > mysql. I have integrated the Quartz engine. My problem is that the > application eventually hangs. Jobs don't run and users can no longer log > in. The tomcat manager webapp shows login threads stuck in > /j_security_check. > > I have nothing in my logs to indicate why any of this is happening. > > One thing that's suspicious is that I don't ever seem to see any new > database connections. I set my BasicDataSource connection pool to have > 10 initial connections. mysql's 'show processlist' command shows the > list of connections decreasing over time but on my production server > (Linux) I never see a new connection. This is not the case on my > development machine (XP Pro). > > "show innodb status" doesn't show any stuck db transactions. > > I've added a log writer to the BasicDataSource configuration but that > stays empty even on my development machine. > > I once found a mailing list thread that talked about quartz eating > threads and never letting them go but the thread is old and didn't have > anything to say about a resolution. Anyone else using quartz with > Appfuse and mysql? > > TIA > > Brett Knights > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- -- Lee Meador Sent from gmail. My real email address is lee AT leemeador.com
