Confusion on Apache::DBI

2000-05-18 Thread Niral Trivedi
All, Sorry if this question sounds stupid.. but I am new to mod_perl and Apache::DBI.. I have successfully installed Apache Server 1.3.12 and mod_perl 1.24 and Apache::DBI 0.87 on Solaris 2.7. And I have tested all successfully... But confusion arised when I created a startup.pl file and tried

RE: Confusion on Apache::DBI

2000-05-18 Thread Geoffrey Young
-Original Message- From: Niral Trivedi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 1:11 PM To: '[EMAIL PROTECTED]' Subject: Confusion on Apache::DBI All, Sorry if this question sounds stupid.. but I am new to mod_perl and Apache::DBI.. I have successfully

Re: Confusion on Apache::DBI

2000-05-18 Thread Niral Trivedi
Thanks Geoff, You were right... I was using "DBI:mysql:DBNAME::localhost" as connect string in startup file whereas "DBI:mysql:DBNAME" in my mod_perl script.. I have changed that and it worked... Now, another question.. As we agreed, we can have as many db handle available as server processes

RE: Confusion on Apache::DBI

2000-05-18 Thread Geoffrey Young
-Original Message- From: Niral Trivedi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 3:15 PM To: Geoffrey Young Cc: '[EMAIL PROTECTED]' Subject: Re: Confusion on Apache::DBI Thanks Geoff, You were right... I was using "DBI:mysql:DBNAME::localhost"

RE: Confusion on Apache::DBI

2000-05-18 Thread Geoffrey Young
-Original Message- From: Niral Trivedi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 3:57 PM To: Geoffrey Young Cc: '[EMAIL PROTECTED]' Subject: Re: Confusion on Apache::DBI Geoff, I know, once child dies, db handle goes out of scope and DBI cleans up

Re: Confusion on Apache::DBI

2000-05-18 Thread Perrin Harkins
On Thu, 18 May 2000, Niral Trivedi wrote: Now, with Apache::DBI, we'll have one DBI handle per child process during the server startup. Now, let's say one child has started its processing and hasn't served any request yet. Now, first request comes in and it will look for DB handle, which is

Re: Confusion on Apache::DBI

2000-05-18 Thread Niral Trivedi
I understood now... Thank you all for your responses.. Niral Perrin Harkins wrote: On Thu, 18 May 2000, Niral Trivedi wrote: Now, with Apache::DBI, we'll have one DBI handle per child process during the server startup. Now, let's say one child has started its processing and hasn't