dbi:oracle win2k ORA-1222 problems

2005-06-15 Thread Hope Peter
Aloha. Have just inherited a failed web app. It originally was running on unix. Then got ported to NT. Then ported to Win2k. Client network admins recently updated the server and the web application will no longer connect to the database. The web server is a WIN2k w/sp4 box running IIS5

Windows DBD::Oracle and newer versions of Perl.

2005-06-15 Thread Jeff Urlwin
FYI, I've recently had to re-install perl on a machine where I'm contracting. It's 5.8.7. To test, I pulled in DBD::Oracle from the ftp.esoftmatic.com site from 5.8.4. It's working like a charm at the moment. Nothing fancy in the tests yet, but it's working. If anyone is having specific prob

Re: Cycling through open handles

2005-06-15 Thread Tim Bunce
On Wed, Jun 15, 2005 at 02:19:20PM -0400, Sam Tregar wrote: > Hello all. Is there a simple way to cycle through all open database > handles, without needing to know anything about them before-hand? > Something like: > > foreach my $dbh (DBI->all_open_database_handles()) { > ... > } > >

Re: DBD::Proxy and LOBs

2005-06-15 Thread Tim Bunce
On Wed, Jun 15, 2005 at 07:56:44AM -0500, Scott T. Hildreth wrote: > On Wed, 2005-06-15 at 10:38 +0200, Wojciech Pietron wrote: > > Hello Scott, > > > > thank you for your help. But are there any workarounds to this problems? > > Is DBD::Proxy under development? It looks like its code hasn't been

Re: DBD::Proxy and LOBs

2005-06-15 Thread Tim Bunce
On Wed, Jun 15, 2005 at 10:38:05AM +0200, Wojciech Pietron wrote: > Hello Scott, > > thank you for your help. But are there any workarounds to this problems? Attributes can be changed. DBD::Proxy tries hard to be as transparent as possible. Some atributes have special handling (see the three %A

Re: Cycling through open handles

2005-06-15 Thread Sam Tregar
On Wed, 15 Jun 2005, Tim Bunce wrote: > Not currently. It would require the use of weak-refs to avoid > reference loops. (Patches welcome etc etc.) Alright, perhaps I'll take a swing at it. Can you suggest a good place to put the code to collect open handles? Knowing nothing about the internal

Re: Cycling through open handles

2005-06-15 Thread Ian Harisay
If you are using a connection pool you could. Haven't done it with Perl but I did do it with Java. Sam Tregar wrote: Hello all. Is there a simple way to cycle through all open database handles, without needing to know anything about them before-hand? Something like: foreach my $dbh (DBI->all

Cycling through open handles

2005-06-15 Thread Sam Tregar
Hello all. Is there a simple way to cycle through all open database handles, without needing to know anything about them before-hand? Something like: foreach my $dbh (DBI->all_open_database_handles()) { ... } I looked through the documentation but I couldn't find anything that worked.

RE: Seek help installing DBD::Oracle

2005-06-15 Thread Reidy, Ron
You need to install the full Oracle client. Do not try to piece-meal an install. - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: McLean, Emmett (HQP) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 5:58 PM To: dbi-users@perl.org Subject: Seek

DBD::Oracle w/HP-UX memory leak

2005-06-15 Thread John Watson
OS: HP-UX 11i Oracle: 9.2.0.1.0 I've followed some directions to build the DBD::Oracle driver against HP's depot install of Perl 5.8.2. The make, make test, and make install went fine. However, when I execute a prepared statement multiple times using DBD::Oracle, my perl process size grows qui

Re: DBD::Proxy and LOBs

2005-06-15 Thread Scott T. Hildreth
On Wed, 2005-06-15 at 10:38 +0200, Wojciech Pietron wrote: > Hello Scott, > > thank you for your help. But are there any workarounds to this problems? > Is DBD::Proxy under development? It looks like its code hasn't been > changed for dozens of months. And now that I am starting a new project I >

DBI / DBD / MySQL installation problem

2005-06-15 Thread Jonas Andersson
Hi, (sorry for fairly lengthy post) I used to run Red Hat 9, and had a perfect relationship with Perl, DBI, and MySQL. However, after upgrading to Fedora Core 4, I am no longer able to connect to MySQL from Perl via DBI. My simple test script: --- #!/usr/bin/perl -w use

Re: DBD::Proxy and LOBs

2005-06-15 Thread Wojciech Pietron
Hello Scott, thank you for your help. But are there any workarounds to this problems? Is DBD::Proxy under development? It looks like its code hasn't been changed for dozens of months. And now that I am starting a new project I have to make a decision whether I can rely on DBD::Proxy. I also had p