Connection pooling in mod_perl

[prev] [thread] [next] [Date index for 2004/11/22]

All,

	I'm writing a Mason based application that uses CDBI to talk to MySQL. 
The app uses ithreads to perform several tasks in parallel, and uses 
Apache::DBI for connection pooling. I am experiencing intermittent 
omissions of output when running the code through the web, but get 
consistent results from the command line. When Apache::DBI is not 
loaded in the web server conf, the application runs consistently. As 
such, I'm fairly convinced that it's some problem with Apache::DBI 
running in mod_perl (2.0). Not sure what the exact issue is (perhaps 
the Ima::DBI compatibility issue? perhaps a thread safety with 
Apache::DBI?), but I'd very much like to deliver the app with 
connection pooling. Are there any alternatives to Apache::DBI which are 
more cooperative with Class::DBI? Thanks in advance.

	-- Alex