Re: [cgiapp] FastCGI/Oracle timeout issue

2009-08-24 Thread Benjamin Hitz
Just an update on this... I did manage to trap the error in the teardown method and kill the process. I just had confused myself with fallback error processing. Ben On Aug 13, 2009, at 2:43 PM, Benjamin Hitz wrote: Our Oracle users have a connection limit set (usually 4 hours or so

[cgiapp] FastCGI/Oracle timeout issue

2009-08-13 Thread Benjamin Hitz
So I have a little trouble with my CGIapp running under fastCGI. These are the only two apps I run under FastCGI (currently) so I don't have a huge amount of experience with it. The phenotype is this: Our Oracle users have a connection limit set (usually 4 hours or so) - including the

Re: [cgiapp] CGIApp + FastCGI

2009-06-15 Thread Benjamin Hitz
We have a couple pages that use CGIApp/FastCGI. I believe that we stopped using CGI::Application:FastCGI, it's a little buggy, although I cannot say for sure that this is the issue you get with many processes. Also, it doesn't really do anything. I can't even tell you how I replaced

Re: [cgiapp] mod_perl vs. FastCGI

2009-02-09 Thread Benjamin Hitz
We have converted a plain cgi app under CGI::App (no dispatch) to run under FCGI without much difficulty (Solaris). The biggest problem I had was some mixed apps where I was creating 2 distinct DBI database handles. Once I got it down to 1, everything worked well. Primary gain is start

Re: [cgiapp] mod_perl vs. FastCGI

2009-02-09 Thread Benjamin Hitz
On Feb 9, 2009, at 10:47 AM, Peter Karman wrote: Benjamin Hitz wrote on 02/09/2009 12:30 PM: We have converted a plain cgi app under CGI::App (no dispatch) to run under FCGI without much difficulty (Solaris). The biggest problem I had was some mixed apps where I was creating 2 distinct

Re: [cgiapp] cached DBI connections with cgiapp/fastcgi

2008-10-23 Thread Benjamin Hitz
On Oct 22, 2008, at 10:39 AM, Michael Peters wrote: It will probably reconnect if the handle isn't there. But not if it goes bad. I don't know for sure since I don't use that plugin. But it's a common problem when dealing with persistant DB connections. If you want to see how mod_perl

[cgiapp] cached DBI connections with cgiapp/fastcgi

2008-10-22 Thread Benjamin Hitz
We are modifying our CGI::App to run under fastcgi/DBI/Oracle10g. CGI::Application::Plugin::FastCGI seems to work not at all, We use the help from this page: http://cgiapp.erlbaum.net/?FastCGI to pass the query params (uses CGI::Fast). And in the cgiapp_init method we call:

Re: [cgiapp] cached DBI connections with cgiapp/fastcgi

2008-10-22 Thread Benjamin Hitz
On Oct 22, 2008, at 10:48 AM, Perrin Harkins wrote: On Wed, Oct 22, 2008 at 1:33 PM, Benjamin Hitz [EMAIL PROTECTED] wrote: It basically calls DBI-connect_cached(dbi:Oracle:sdev2, $user, $pass, { RaiseError=1, AutoCommit=0, private_cachekey = $0 }); That ought to work

Re: [cgiapp] Question | Poll - Preferred ORM.

2008-09-25 Thread Benjamin Hitz
We have begun a conversion from an old, hand rolled ORM to DBIx::Class. There are lots of nice properties, but our DB has 120- odd tables, and the start up time is killing us (ca. 2sec.). Hopefully, we can resolve the speed issue with PersistantPerl and/or FCGI, but I will be

Re: [cgiapp] redirect/content type

2008-06-13 Thread Benjamin Hitz
); Regards, *DAVID BAXTER* * SiteSuite Australasia* Websites Made Easy Tel: 61 2 9213 0500 Fax: 61 2 9212 5161 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web: www.sitesuite.com.au http://www.sitesuite.com.au/ Benjamin Hitz wrote: This is probably a vanilla CGI question, but I am

[cgiapp] redirect/content type

2008-06-11 Thread Benjamin Hitz
This is probably a vanilla CGI question, but I am working under CGIapp so here goes. I have a cgi::app that shows a table. I want to have a link which generates a plain text (tab delim) version of the table, and pops up a save as window. Prior to cgi-app we just wrote a temp file on

[cgiapp] super fancy javascript

2007-12-22 Thread Benjamin Hitz
The short title would be: Rico vs. jQuery! Who will Win! So, we are tasked to implement js table filtering/sorting and all sorts of ajax goodness. Our current system (at least the parts we have rewritten) use CGI::Application + TT to good effect. I did a very simply demo with the

Re: [cgiapp] Class::MOP? Really?

2007-10-22 Thread Benjamin Hitz
Wow, your elegant argument has convinced me that all my issues are irrelevant and I will switch immediately. Ben On Oct 20, 2007, at 2:33 PM, Ron Savage wrote: Ben Hitz wrote: Hi Ben I am not a fan of inside-out objects in perl, because I have much old code which uses old-style hash