Re: getting rid of the Issuing rollback() warning

2004-02-17 Thread Tim Bunce
On Mon, Feb 16, 2004 at 07:46:49PM -0600, Jay Hannah wrote: Incidentally, you already don't get the warning during global destruction, so it isn't that reliable. I ran a little test against all our productions RDBMSs. As luck would have it, it seems that it is being thrown in global

RE: getting rid of the Issuing rollback() warning

2004-02-17 Thread Jay Hannah
From: Tim Bunce [mailto:[EMAIL PROTECTED] On Mon, Feb 16, 2004 at 07:46:49PM -0600, Jay Hannah wrote: ...it seems that it is being thrown in global destruction in the 2 DBD's I use the most... DBD::Informix - Informix 9.3:Issuing rollback() for database... DBD::Informix -

Problems Installing DBD::Oracle 1.15 on FreeBSD 5.1 with Oracle 9i

2004-02-17 Thread Scot Greisch
I've got Oracle9i successfully installed and am able to connect via sqlplus to databases on the local server and remote servers. I've installed DBI 1.40 and am trying to install DBD::Oracle 1.15. It gives the following warnings during perl Makefile.PL: Note (probably harmless): No library found

Subclassing DBI...

2004-02-17 Thread Tim Howell
I'd like to add a method to my statement handles so that I can do something like my $sth = $db-prepare($cipher_object, $sql_statement) and then $sth-execute_encrypt(@values) and have the values encrypted with the Crypt::CBC object before being passed on to execute. How do I go about doing

RE: Subclassing DBI...

2004-02-17 Thread Tim Howell
Posted too quickly. As soon as I sent this I realized I hadn't checked the DBI docs. My apologies, --TWH -Original Message- From: Tim Howell Sent: Tuesday, February 17, 2004 12:36 PM To: [EMAIL PROTECTED] Subject: Subclassing DBI... I'd like to add a method to my statement handles

Re: getting rid of the Issuing rollback() warning

2004-02-17 Thread Tim Bunce
On Tue, Feb 17, 2004 at 10:32:55AM -0600, Jay Hannah wrote: From: Tim Bunce [mailto:[EMAIL PROTECTED] On Mon, Feb 16, 2004 at 07:46:49PM -0600, Jay Hannah wrote: ...it seems that it is being thrown in global destruction in the 2 DBD's I use the most... DBD::Informix - Informix 9.3:

OSCON 2004

2004-02-17 Thread Jay Hannah
- Anyone presenting? - BOF (Birds of a Feather)? - Who's coming? I went last year and learned a lot. I'm still sad Tim couldn't make it. I wanted to be one of his groupies. j

program ends on fetchrow_array

2004-02-17 Thread Dianne Yumul
Hello, I'm having a problem with the code below. The program exits when it gets to the fetchrow_array() statement. It doesn't print an error message and it doesn't die. We checked the temporary table, and it exists with the right fields. STDERR shows the Got here 1.3 line but not the Got

RE: Problems Installing DBD::Oracle 1.15 on FreeBSD 5.1 with Ora

2004-02-17 Thread Scott T. Hildreth
Are you using a Linux compiled Perl? If not you need to use Perl/DBI/DBD::Oracle that are compiled for linux. I did this running under the /compat/linux/bin/bash. I was using the Oracle7 clients(FreeBSD native) from the ports tree to compile a native DBD::Oracle, but support for the Oracle7 is

Re: program ends on fetchrow_array

2004-02-17 Thread James D. White
Dianne Yumul wrote: Hello, I'm having a problem with the code below. The program exits when it gets to the fetchrow_array() statement. It doesn't print an error message and it doesn't die. We checked the temporary table, and it exists with the right fields. STDERR shows the Got here

RE: program ends on fetchrow_array

2004-02-17 Thread Dianne Yumul
print STDERR Got here 1.3\n; my @a = $sth_data-fetchrow_array() or die fetchrow_array: $DBI::errstr\n; print STDERR Got here 1.4\n; What's in @? The program ends on that line, so unfortunetly I can't examine @a. And if the answer to that doesn't help, what DBD are you using

Re: program ends on fetchrow_array

2004-02-17 Thread Michael A Chase
On 02/17/2004 04:23 PM, Dianne Yumul wrote: print STDERR Got here 1.3\n; my @a = $sth_data-fetchrow_array() or die fetchrow_array: $DBI::errstr\n; print STDERR Got here 1.4\n; Sorry about the lack of version info, we're using DBI-1.40, DBD-Pg-1.31, and PostgreSQL-7.3.5. The query works fine

RE: program ends on fetchrow_array

2004-02-17 Thread Dianne Yumul
print STDERR Got here 1.3\n; my @a = $sth_data-fetchrow_array() or die fetchrow_array: $DBI::errstr\n; print STDERR Got here 1.4\n; Sorry about the lack of version info, we're using DBI-1.40, DBD-Pg-1.31, and PostgreSQL-7.3.5. The query works fine in psql. The weird thing

Re: getting rid of the Issuing rollback() warning

2004-02-17 Thread 'Andrew Pimlott'
On Mon, Feb 16, 2004 at 07:46:49PM -0600, Jay Hannah wrote: I shouldn't need the warning, especially when it's wrong. Even so, it has been useful to me on many occasions in dialogues like this: Well, as I have thought about it more, I agree that there is some tension between the system warning