Re: perl5.004 for AIX5.1

2004-06-30 Thread Hardy Merrill
How about http://www.perl.com/download.csp rachakonda muralikrishna [EMAIL PROTECTED] 06/30/04 12:45AM Hi all, I would like to know where I can get the perl version 5.004 for AIX. I haven't found that on any of the prel sites. Any help in this regard is highly appreciated. Thanks, Murali

DBI Module.

2004-06-30 Thread Dave Mullen - Marikina CGI
Dear Mr Bunce, We are using perl 5.005 and mysql 3.23 on a Linux Redhat 7.2 system. We are trying to implement a better timeout for the DBI connections, as the one incorporated in the DBI module only has a granularity of seconds. We don't use persistent connections or mod-perl, so connection

Re: DBI Module.

2004-06-30 Thread Tim Bunce
On Wed, Jun 30, 2004 at 03:19:15PM +0200, Dave Mullen - Marikina CGI wrote: Dear Mr Bunce, We are using perl 5.005 and mysql 3.23 on a Linux Redhat 7.2 system. We are trying to implement a better timeout for the DBI connections, as the one incorporated in the DBI module only has a

fork and keeping connection DBD::Oracle ?

2004-06-30 Thread BriceBr
Hello, from main perl connect, forking n kids and waiting for them to end with their prepare/execute sth back to parent and disconnect gives DBD::Oracle::db disconnect failed: ORA-03113: end-of-file on communication channel (DBD ERROR: OCISessionEnd) even if I reconnect inside kids, do

RE: fork and keeping connection DBD::Oracle ?

2004-06-30 Thread Bruce Hartleben
n is finite and limited by the Oracle installation, not perl. You (plus all other connections) may be reaching this limit. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 12:11 PM To: [EMAIL PROTECTED] Subject: fork and keeping

RE: DBI Module.

2004-06-30 Thread Terry Maragakis
Mr Bunce, Not all of the rest of the world is using persistent database connections. There is a good reason not to use persistent database connections, it is database licensing. Licensing may not be an issue with mysql but it is an issue with commercial databases. I use Informix with

RE: DBI Module.

2004-06-30 Thread Sterin, Ilya \(I.\)
That's not true. You can have one persistant connection and reuse that for all requests, it'll just take away from having to connect/disconnect all the time. No one said you have to open 40 different connections and pay for 40 concurrent licenses. -Original Message- From: Terry

RE: DBI Module.

2004-06-30 Thread Terry Maragakis
Yes, it is true. The licensing agreement clearly states that connection pooling like you describe is not allowed under the concurrent licensing structure. Terry Maragakis Database Administrator The Inteq Group Inc. 5445 La Sierra Dr. Suite 400 Dallas, TX 75231 214-739-9494 214-739-7979 Fax

RE: DBI Module.

2004-06-30 Thread Sterin, Ilya \(I.\)
What connection pooling? You have one open database connection and the rest of the scripts wait for it? There is no concurrent access happening. The only thing that might matter is if you're using threads and/or processes. Each db vendor has different concurrent license schemes, I always

RE: DBI Module.

2004-06-30 Thread Terry Maragakis
I agree with you, that there has been a lot of confusion in the past and that the sales people are generally uninformed about the licensing of their products, and different vendors may license products differently. I believe that Oracle does not license their product on the concurent user model

RE: fork and keeping connection DBD::Oracle ?

2004-06-30 Thread L. Trindle Gennari
The child has to make and break the connection. You can't pass it from parent to child. What I do is not have the parent connect at all, just leave it to the kids ltg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 9:11 AM To:

Re: DBI Module.

2004-06-30 Thread JupiterHost.Net
Licensing may not be an issue with mysql but it is an issue with commercial databases. I use Informix with hundreds of users accessing the database for extremely short queries from a GUI. I cannot afford to have them connected constantly, I would have to spent $100,000 per server in licensing.

RE: DBI Module.

2004-06-30 Thread Sterin, Ilya \(I.\)
Commercial databases have commercial support behind them, that's what is driving it. Most non-IT companies, do not want to invest in internal departments that are responsible for supporting an open source software product. Until a giant like IBM, HP, or similar puts their support behind an

Re: DBI Module.

2004-06-30 Thread JupiterHost.Net
Sterin, Ilya (I.) wrote: Commercial databases have commercial support behind them, that's what is driving it. Most non-IT companies, do not want to invest in internal departments that are responsible for supporting an open source software product. Until a giant like IBM, HP, or similar puts

RE: DBI Module.

2004-06-30 Thread Sterin, Ilya \(I.\)
I know Tim will kill me for this OT stuff:-) I feel the likely hood of the economy changing and causing major issues for big companies is way more likely than the open source community to stop supporting and developing. It's not that the open source community doesn't support, it's

Re: DBI Module.

2004-06-30 Thread JupiterHost.Net
Sterin, Ilya (I.) wrote: I know Tim will kill me for this OT stuff:-) Tim's a pretty cool guy it seems, but maybe we should let the horse die :) I feel the likely hood of the economy changing and causing major issues for big companies is way more likely than the open source community to

RE: fork and keeping connection DBD::Oracle ?

2004-06-30 Thread BriceBr
for one child, you can pass it once you've done dbh-{InactiveDestroy}=1; inside the parent and when it ends, the same connexion can be used from the parent. But for many children, I tried to disconnect inside the parent, and connect/disconnect inside kids, and back to parent when kids end,