Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Hi pals, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I looked around I come to Parallel::ForkManager module, easy to use. When I wrote script, I saw it

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Thilo Planz
Hello, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I looked around I come to Parallel::ForkManager module, easy to use. I do not know Parallel::ForkManager

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Moosmann, James [MJ], on Wednesday, December 29, 2004 at 07:07 (-0500) thoughtfully wrote the following: MJ I am really disappointed with Perl's lack of support for any reliable. MJ multithreaded behavior. I keep hoping it gets fixed. But I have waited for MJ 2 years. ahm, I wrote some posts

RE: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Follett, Robert
You will get much better performance by connecting once, outside your foreach loop as well as disconnecting and finishing after the loop. Also read up on prepare_cached using bind params. You will want to prepare outside your foreach as well. The only thing you need to do inside your loop is

Can't install DBI

2004-12-29 Thread Bender Eliyahu-Yosef-BEB067
Hi, I installed ActivePerl- 5.8.6.811-MSWin32 opened MS-DOS window wrote ppm and then install DBI. The respond I got was : Error : No Valid repositories: Error : 500 Can't connect to ppm.Activestate.com:80 Bad hostname 'ppm.ActiveState.com' What should I do ? Best Regards, Eli. Email:

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ron Wingfield
I know my comments do not provide an immediate solution, but this could be a very interesting thread. Infact, I'm going to be writing some IPC intensive code in the near future, and I want to interface via Perl and web browsers. First, are you running on an MS/Windows or Unix server? Fork is

Re: RE: Evaluated require $database not found.

2004-12-29 Thread amonotod
From: Ron Goral [EMAIL PROTECTED] Date: 2004/12/26 Sun PM 10:35:37 CST -Original Message- From: Jeff Zucker [mailto:[EMAIL PROTECTED] Sent: Sunday, December 26, 2004 10:30 PM Paul Boutros wrote: use strict; my $val = 'DBI'; require $val; Try it with $val = 'DBI.pm'

Problem with while/fetchrow_array

2004-12-29 Thread Ron Wingfield
Hello everyone, I'm having difficulty solving this code problem. I can load a popup list of states from a states table, but I can't seem to get-it-right when I execute a SHOW, rather than a SELECT query. Actually, I want to create a popup list of all DATABASES through the CGI. From the

Re: Problem with while/fetchrow_array

2004-12-29 Thread Hardy Merrill
Ron, someone else will correct me if I'm wrong, but long ago this bit me also. I believe I remember the answer being that SHOW is a mysql client command - that is not a valid SQL command. I'm not sure if mysql has a mysql-only sql command you can give to get the names of the databases - or

RE: Problem with while/fetchrow_array

2004-12-29 Thread Graeme St. Clair
The relevant line in an app I support says:- while (my @row = $sth-fetchrow_array) { blah } # Note @ not $, also no operands. I am no Perl expert, but I think you may have one of those differences arising from context. Rgds, GStC. -Original Message- From: Ron Wingfield

DBD::Oracle and m2o.pl

2004-12-29 Thread Maldonado, Daniel CW2 CTARNG
Hi there again, this may not be the best forum to ask this question but I don't think there is a DBD::Oracle list available. Does anyone have a script that can convert a mysqldump file to a sqlplus script? Oreilly lists it at: http://www.oreillynet.com/oracle/os_dir/commandline.csp But I can't

Re: Problem with while/fetchrow_array

2004-12-29 Thread Ron Wingfield
Thanks Hardy, I suspect that you are correct, sir! I'm going to go pickup a copy of Programming the Perl DBI book, today. I believe that's an O'Reilly publication, isn't it? (I can Google it.) By the way, I've just executed the following code. Notice that there is no while loop, but rather

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Cosimo Streppone
Follett, Robert wrote: You will get much better performance by connecting once, outside your foreach loop as well as disconnecting and finishing after the loop. Having tried this, I can assure you that connecting *inside* the loop is the only alternative here. In fact, for every loop iteration,

Re: Problem with while/fetchrow_array

2004-12-29 Thread Chris Denman (Protext)
With all due respect, why don't you learn how to program like the rest of us. I learned to program with research and trial and error. I used search engines, purchased books and borrowed code. It took me ages to get a script to run, let alone connect to a database (permissions!). I think I have

Off Topic: Tsunami

2004-12-29 Thread Ron Wingfield
I know that this is off-topic, but I'm fortunate to be able to work at home these days, and I keep the TV on for white noise. Still, the news that is filtering-in about this Indian Ocean tsunami is nothing short of apocalyptic. I know that this list has an international audience and some of

RE: unable to install DBD::Oracle

2004-12-29 Thread Capacio, Paula J
Adjusted from top post, which is frowned on, to bottom/intersperse Jan 28th Conversation: From: liooil Response by: Paula Hope this topic is not [EMAIL PROTECTED] relevant. My Apologies if it's the case... No, the right list is the DBI-Users list

FW: unable to install DBD::Oracle

2004-12-29 Thread Capacio, Paula J
Sorry if double posted: Got a delivery error on liooil's eaddr and correcting Adjusted from top post, which is frowned on, to bottom/intersperse Jan 28th Conversation: From: liooil Response by: Paula Hope this topic is not [EMAIL PROTECTED] relevant. My Apologies if it's the case... No, the

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Ron Wingfield [RW], on Wednesday, December 29, 2004 at 10:29 (-0600) wrote the following: RW I know my comments do not provide an immediate solution, but RW this could be a very interesting thread.  Infact, I'm going to be RW writing some IPC intensive code in the near future, and I want to RW

Re: Can't install DBI

2004-12-29 Thread Michael A Chase tech
On 12/29/2004 08:05 AM, Bender Eliyahu-Yosef-BEB067 said: I installed ActivePerl- 5.8.6.811-MSWin32 opened MS-DOS window wrote ppm and then install DBI. The respond I got was : Error : No Valid repositories: Error : 500 Can't connect to ppm.Activestate.com:80 Bad hostname 'ppm.ActiveState.com'

Re: DBD::Oracle and m2o.pl

2004-12-29 Thread Michael A Chase tech
On 12/29/2004 10:56 AM, Maldonado, Daniel CW2 CTARNG said: Hi there again, this may not be the best forum to ask this question but I don't think there is a DBD::Oracle list available. This is the right place. The DBI list is a good first stop for all DBI and DBD user issues. Does anyone have a

RE: DBD::Oracle and m2o.pl

2004-12-29 Thread Reidy, Ron
Or he can use SQL*Loader to load it in. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Michael A Chase tech [mailto:[EMAIL PROTECTED] Sent: Wed 12/29/2004 7:04 PM To: Maldonado, Daniel CW2 CTARNG Cc: dbi-users@perl.org Subject:Re: DBD::Oracle