Lee,
Thanks for your response. I will try to take Quartz out of the db loop.
I had hoped to avoid doing that since my jobs are dynamic and I'll have
to write a startup listener to load them all into the quartz scheduler.
Thanks
Brett Knights
Lee Meador wrote:
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]
<mailto:[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]
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
--
-- Lee Meador
Sent from gmail. My real email address is lee AT leemeador.com
<http://leemeador.com>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
