Re: Apache::DBI connect_on_init problem

2010-04-19 Thread Perrin Harkins
On Sat, Apr 17, 2010 at 4:42 PM, Chris Bennett wrote: > You may also have other connections, but these will reconnect-disconnect > each time For the record, Apache::DBI will work with any number of connections, keeping them persistent. It's also correct to call connect_on_init multiple times. I

Re: Apache::DBI connect_on_init problem

2010-04-17 Thread Jiri Pavlovsky
On 17.4.2010 23:21, Jiri Pavlovsky wrote: On 17.4.2010 22:42, Chris Bennett wrote: Oh, this is your error. You may only use Apache::DBI_connect_on_init for ONE connection, which stays up and running. Use your more important one (for speed) for this. This doesn't seem to make difference. It

Re: Apache::DBI connect_on_init problem

2010-04-17 Thread Jiri Pavlovsky
On 17.4.2010 22:42, Chris Bennett wrote: Oh, this is your error. You may only use Apache::DBI_connect_on_init for ONE connection, which stays up and running. Use your more important one (for speed) for this. This doesn't seem to make difference. It doesn't work even when making only one con

Re: Apache::DBI connect_on_init problem

2010-04-17 Thread Chris Bennett
On 04/17/10 15:09, Jiri Pavlovsky wrote: On 17.4.2010 22:22, Chris Bennett wrote: On 04/17/10 14:27, Jiri Pavlovsky wrote: Hello, I'm trying to prestart db connection. But Apache::DBI->connect_on_init is not working. Gives no error, but db connection is not made. Setting $Apache::DBI::DEBUG =

Re: Apache::DBI connect_on_init problem

2010-04-17 Thread Fred Moyer
On Sat, Apr 17, 2010 at 1:09 PM, Jiri Pavlovsky wrote:>  Apache::DBI->connect_on_init("dbi:Pg:dbname=p69", >    "user", >    "pass", >    { >      PrintError => 1, # warn() on errors >      RaiseError => 0, # don't die on error >      AutoCommit => 1, # commit executes immediately >      pg_enable

Re: Apache::DBI connect_on_init problem

2010-04-17 Thread Jiri Pavlovsky
On 17.4.2010 22:22, Chris Bennett wrote: On 04/17/10 14:27, Jiri Pavlovsky wrote: Hello, I'm trying to prestart db connection. But Apache::DBI->connect_on_init is not working. Gives no error, but db connection is not made. Setting $Apache::DBI::DEBUG = 2 indicates that ChildInitHandler runs. I

Re: Apache::DBI connect_on_init problem

2010-04-17 Thread Chris Bennett
On 04/17/10 14:27, Jiri Pavlovsky wrote: Hello, I'm trying to prestart db connection. But Apache::DBI->connect_on_init is not working. Gives no error, but db connection is not made. Setting $Apache::DBI::DEBUG = 2 indicates that ChildInitHandler runs. I tried to create my custom ChildInitHandle

Apache::DBI connect_on_init problem

2010-04-17 Thread Jiri Pavlovsky
Hello, I'm trying to prestart db connection. But Apache::DBI->connect_on_init is not working. Gives no error, but db connection is not made. Setting $Apache::DBI::DEBUG = 2 indicates that ChildInitHandler runs. I tried to create my custom ChildInitHandler and start db connection from it but i