Skip Menu |
 

This queue is for tickets about the DBD-ODBC CPAN distribution.

Report information
The Basics
Id: 63550
Status: resolved
Priority: 0/
Queue: DBD-ODBC

People
Owner: Nobody in particular
Requestors: john_corcoran [...] trepp.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 1.26_4



From john_corcoran [...] trepp.com Thu Dec 2 15: 47:37 2010
MIME-Version: 1.0
X-Spam-Status: No, score=-6.899 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5] autolearn=ham
Content-Class: urn:content-classes:message
X-Spam-Flag: NO
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
Message-ID: <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com>
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CB9262.3F8F0532"
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-MS-Tnef-Correlator:
X-Spam-Score: -6.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 17DD624129C for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Thu, 2 Dec 2010 15:47:37 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id y2OUutxVnWht for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Thu, 2 Dec 2010 15:47:34 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id BE2CC24129B for <bug-DBD-ODBC [...] rt.cpan.org>; Thu, 2 Dec 2010 15:47:32 -0500 (EST)
Received: (qmail 8330 invoked by uid 103); 2 Dec 2010 20:47:32 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 2 Dec 2010 20:47:32 -0000
Received: from mail3.trepp.com (HELO proxy1.trepp.com) (68.167.78.174) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Thu, 02 Dec 2010 12:47:27 -0800
Received: from t2.trepp.com (t2.trepp.com [98.1.0.30]) by proxy1.trepp.com (Postfix) with ESMTP id 87F87B23E8 for <bug-DBD-ODBC [...] rt.cpan.org>; Thu, 2 Dec 2010 15:49:49 -0500 (EST)
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: BUG with statement attribute not returned from $dbh do() command
Return-Path: <john_corcoran [...] trepp.com>
Thread-Index: AcuSYkWYn9txnhMNR/you/fnyOuTyw==
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-Spam-Check-BY: 16.mx.develooper.com
Date: Thu, 2 Dec 2010 15:48:17 -0500
X-Spam-Level:
Thread-Topic: BUG with statement attribute not returned from $dbh do() command
X-MS-Has-Attach:
X-Mimeole: Produced By Microsoft Exchange V6.5
To: <bug-DBD-ODBC [...] rt.cpan.org>
From: "John Corcoran" <john_corcoran [...] trepp.com>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: US-ASCII
Content-Length: 1859
Download (untitled) / with headers
text/plain 1.8k
Hi, I found the bug using the following modules DBD::ODBC -- 1.23 DBI -- 1.609 DBD::Sybase -- 1.08 Perl Version: v5.8.8 OS: Linux dev6 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:21 EST 2007 i686 i686 i386 GNU/Linux Basically, I'm writing an error handle for DBI to trap the error message and the actual SQL statement. I'm currently connecting to MS SQL 2005 using both ODBC (EasySoft) and DBD Sybase (freetds). The error only happens with DBD::ODBC. The error happens when you write an incorrect SQL statement using the dbh->do command. In ODBC, I'm unable to return the SQL Statement using the do command, it only works with a prepare statement. Its like the SQL Statements been replaced. Test Script below: use strict; use Carp qw(croak cluck); use DBI; my $dbh = DBI-> connect("dbi:ODBC:DSN=TEST;UID=sampleuser;PWD=sampleuser;Trusted_Connect ion=No;APP=$0;"); #my $dbh = DBI->connect("DBI:Sybase:TEST","sampleuser","sampleuser") || die "DBI connect failed: $DBI::errstr\n"; print "Testing the following Driver: $dbh->{Driver}->{Name} \n"; $dbh->{AutoCommit} = 1; $dbh->{RaiseError} = 0; $dbh->{PrintError} = 0; $dbh->{ShowErrorStatement} = 0; $dbh->{HandleError} = \&_err_handler; $dbh->do("select top 10 * from testTable"); sub _err_handler { my ($error, $h) = @_; print "errorMessage: $error \nerrorSql: $h->{Statement}\n" ; return 0; } ODBC Result: Testing the following Driver: ODBC errorMessage: DBD::ODBC::db do failed: Invalid object name ' testTable '. (SQL-42S02) errorSql: Expected Result: (What I get back from using DBD Sybase) Testing the following Driver: ODBC errorMessage: DBD::ODBC::db do failed: Invalid object name ' testTable '. (SQL-42S02) errorSql: select top 10 * from testTable Thanks John Corcoran
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: US-ASCII
Content-Length: 9690
MIME-Version: 1.0
In-Reply-To: <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19308-1292259817-302.63550-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 2566
Download (untitled) / with headers
text/plain 2.5k
On Thu Dec 02 15:47:37 2010, john_corcoran@trepp.com wrote: Show quoted text
> Hi, > > I found the bug using the following modules DBD::ODBC -- 1.23 > > DBI -- 1.609 > > DBD::Sybase -- 1.08 > > > > Perl Version: v5.8.8 > > OS: Linux dev6 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:21 EST 2007 i686 > i686 i386 GNU/Linux > > > > Basically, I'm writing an error handle for DBI to trap the error message > and the actual SQL statement. I'm currently connecting to MS SQL 2005 > using both ODBC (EasySoft) and DBD Sybase (freetds). > > > > The error only happens with DBD::ODBC. The error happens when you write > an incorrect SQL statement using the dbh->do command. In ODBC, I'm > unable to return the SQL Statement using the do command, it only works > with a prepare statement. Its like the SQL Statements been replaced. > > > > Test Script below: > > > > use strict; > > use Carp qw(croak cluck); > > use DBI; > > > > my $dbh = DBI-> > connect("dbi:ODBC:DSN=TEST;UID=sampleuser;PWD=sampleuser;Trusted_Connect > ion=No;APP=$0;"); > > #my $dbh = DBI->connect("DBI:Sybase:TEST","sampleuser","sampleuser") || > die "DBI connect failed: $DBI::errstr\n"; > > > > print "Testing the following Driver: $dbh->{Driver}->{Name} \n"; > > > > $dbh->{AutoCommit} = 1; > > $dbh->{RaiseError} = 0; > > $dbh->{PrintError} = 0; > > $dbh->{ShowErrorStatement} = 0; > > $dbh->{HandleError} = \&_err_handler; > > > > $dbh->do("select top 10 * from testTable"); > > > > sub _err_handler { > > my ($error, $h) = @_; > > print "errorMessage: $error \nerrorSql: $h->{Statement}\n" ; > > return 0; > > } > > > > ODBC Result: > > > > Testing the following Driver: ODBC > > errorMessage: DBD::ODBC::db do failed: Invalid object name ' testTable > '. (SQL-42S02) > > errorSql: > > > > Expected Result: (What I get back from using DBD Sybase) > > > > Testing the following Driver: ODBC > > errorMessage: DBD::ODBC::db do failed: Invalid object name ' testTable > '. (SQL-42S02) > > errorSql: select top 10 * from testTable > > > > > > Thanks > > > > John Corcoran >
I'm sorry I have not replied to this before now but I am supposed to get emails when RTs are posted and yet again I didn't get one this time. The do method works differently in DBD::ODBC as by default it uses SQLExecDirect and not SQLPrepare/SQLExecute. It appears Statement does not get set if the do method is called with no parameters. I will look into this. Thanks Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19308-1292259817-302.63550-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com> <rt-3.8.HEAD-19308-1292259817-302.63550-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19315-1292260968-547.63550-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 3385
Download (untitled) / with headers
text/plain 3.3k
On Mon Dec 13 12:03:37 2010, MJEVANS wrote: Show quoted text
> On Thu Dec 02 15:47:37 2010, john_corcoran@trepp.com wrote:
> > Hi, > > > > I found the bug using the following modules DBD::ODBC -- 1.23 > > > > DBI -- 1.609 > > > > DBD::Sybase -- 1.08 > > > > > > > > Perl Version: v5.8.8 > > > > OS: Linux dev6 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:21 EST 2007 i686 > > i686 i386 GNU/Linux > > > > > > > > Basically, I'm writing an error handle for DBI to trap the error message > > and the actual SQL statement. I'm currently connecting to MS SQL 2005 > > using both ODBC (EasySoft) and DBD Sybase (freetds). > > > > > > > > The error only happens with DBD::ODBC. The error happens when you write > > an incorrect SQL statement using the dbh->do command. In ODBC, I'm > > unable to return the SQL Statement using the do command, it only works > > with a prepare statement. Its like the SQL Statements been replaced. > > > > > > > > Test Script below: > > > > > > > > use strict; > > > > use Carp qw(croak cluck); > > > > use DBI; > > > > > > > > my $dbh = DBI-> > > connect("dbi:ODBC:DSN=TEST;UID=sampleuser;PWD=sampleuser;Trusted_Connect > > ion=No;APP=$0;"); > > > > #my $dbh = DBI->connect("DBI:Sybase:TEST","sampleuser","sampleuser") || > > die "DBI connect failed: $DBI::errstr\n"; > > > > > > > > print "Testing the following Driver: $dbh->{Driver}->{Name} \n"; > > > > > > > > $dbh->{AutoCommit} = 1; > > > > $dbh->{RaiseError} = 0; > > > > $dbh->{PrintError} = 0; > > > > $dbh->{ShowErrorStatement} = 0; > > > > $dbh->{HandleError} = \&_err_handler; > > > > > > > > $dbh->do("select top 10 * from testTable"); > > > > > > > > sub _err_handler { > > > > my ($error, $h) = @_; > > > > print "errorMessage: $error \nerrorSql: $h->{Statement}\n" ; > > > > return 0; > > > > } > > > > > > > > ODBC Result: > > > > > > > > Testing the following Driver: ODBC > > > > errorMessage: DBD::ODBC::db do failed: Invalid object name ' testTable > > '. (SQL-42S02) > > > > errorSql: > > > > > > > > Expected Result: (What I get back from using DBD Sybase) > > > > > > > > Testing the following Driver: ODBC > > > > errorMessage: DBD::ODBC::db do failed: Invalid object name ' testTable > > '. (SQL-42S02) > > > > errorSql: select top 10 * from testTable > > > > > > > > > > > > Thanks > > > > > > > > John Corcoran > >
> > I'm sorry I have not replied to this before now but I am supposed to get > emails when RTs are posted and yet again I didn't get one this time. > > The do method works differently in DBD::ODBC as by default it uses > SQLExecDirect and not SQLPrepare/SQLExecute. > > It appears Statement does not get set if the do method is called with no > parameters. I will look into this. > > Thanks > > Martin
It appears there is no statement handle to attach the Statement attribute to when you call do and there are no parameters. DBD::Sybase probably calls prepare/execute methods and the prepare will create a DBI statement handle but DBD::ODBC optimises do calls when there are no parameters into a direct call to SQLExecDirect and there is no DBI statement handle. I'm not sure there is anything I can do about this but at a minimum will document it and may be I'll consult other DBD authors. Bare with me. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19315-1292260968-547.63550-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com> <rt-3.8.HEAD-19308-1292259817-302.63550-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-19315-1292260968-547.63550-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19311-1292316470-1461.63550-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 823
Download (untitled) / with headers
text/plain 823b
On Mon Dec 13 12:22:48 2010, MJEVANS wrote: Show quoted text
> > It appears there is no statement handle to attach the Statement > attribute to when you call do and there are no parameters. DBD::Sybase > probably calls prepare/execute methods and the prepare will create a DBI > statement handle but DBD::ODBC optimises do calls when there are no > parameters into a direct call to SQLExecDirect and there is no DBI > statement handle. > > I'm not sure there is anything I can do about this but at a minimum will > document it and may be I'll consult other DBD authors. Bare with me. > > Martin
See this thread http://www.mail-archive.com/dbi-dev@perl.org/msg06175.html It appears I could set the Statement attribute on the connection handle. I will try and implement this in the next few days. Martin -- Martin J. Evans Wetherby, UK
From john_corcoran [...] trepp.com Tue Dec 14 08: 30:55 2010
MIME-Version: 1.0
X-Spam-Status: No, score=-6.899 tagged_above=-99.9 required=10 tests=[AWL=0.001, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org>
Content-Class: urn:content-classes:message
X-Spam-Flag: NO
References: <RT-Ticket-63550 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com> <rt-3.8.HEAD-19308-1292259817-302.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19315-1292260968-547.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: text/plain; charset="utf-8"
Message-ID: <7413EECCB04B5C4593E02C2DD1DFA3340A230449 [...] t2.trepp.com>
X-MS-Tnef-Correlator:
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id BB3702412E2 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 14 Dec 2010 08:30:55 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Zf+uQp+ScTgm for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 14 Dec 2010 08:30:53 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 2EEAE2412FF for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 14 Dec 2010 08:30:52 -0500 (EST)
Received: (qmail 11045 invoked by uid 103); 14 Dec 2010 13:30:52 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 14 Dec 2010 13:30:52 -0000
Received: from mail3.trepp.com (HELO proxy1.trepp.com) (68.167.78.174) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Tue, 14 Dec 2010 05:30:48 -0800
Received: from t2.trepp.com (t2.trepp.com [98.1.0.30]) by proxy1.trepp.com (Postfix) with ESMTP id 8EF4948553 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 14 Dec 2010 08:34:16 -0500 (EST)
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command
Return-Path: <john_corcoran [...] trepp.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-odbc
Thread-Index: Acuba7iTNFXMtgH2SzOwyjV+j6qSHgAJ081A
Date: Tue, 14 Dec 2010 08:31:39 -0500
X-Spam-Level:
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command
X-Mimeole: Produced By Microsoft Exchange V6.5
To: <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: "John Corcoran" <john_corcoran [...] trepp.com>
RT-Message-ID: <rt-3.8.HEAD-17550-1292333456-171.63550-0-0 [...] rt.cpan.org>
Content-Length: 1373
Download (untitled) / with headers
text/plain 1.3k
That would be great. Thanks a lot. One solution on our end was not to use the do() command, but this was easier said than done since we're moving a lot of our legacy code from DBD Sybase to DBD ODBC which relied heavily on the do() command. Show quoted text
-----Original Message----- From: Martin J Evans via RT [mailto:bug-DBD-ODBC@rt.cpan.org] Sent: Tuesday, December 14, 2010 3:48 AM To: John Corcoran Subject: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command <URL: https://rt.cpan.org/Ticket/Display.html?id=63550 > On Mon Dec 13 12:22:48 2010, MJEVANS wrote:
> > It appears there is no statement handle to attach the Statement > attribute to when you call do and there are no parameters. DBD::Sybase > probably calls prepare/execute methods and the prepare will create a
DBI
> statement handle but DBD::ODBC optimises do calls when there are no > parameters into a direct call to SQLExecDirect and there is no DBI > statement handle. > > I'm not sure there is anything I can do about this but at a minimum
will
> document it and may be I'll consult other DBD authors. Bare with me. > > Martin
See this thread http://www.mail-archive.com/dbi-dev@perl.org/msg06175.html It appears I could set the Statement attribute on the connection handle. I will try and implement this in the next few days. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-17550-1292333456-171.63550-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-63550 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com> <rt-3.8.HEAD-19308-1292259817-302.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19315-1292260968-547.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA3340A230449 [...] t2.trepp.com> <rt-3.8.HEAD-17550-1292333456-171.63550-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19313-1292339400-866.63550-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 587
Download (untitled) / with headers
text/plain 587b
On Tue Dec 14 08:30:56 2010, john_corcoran@trepp.com wrote: Show quoted text
> That would be great. Thanks a lot. One solution on our end was not to > use the do() command, but this was easier said than done since we're > moving a lot of our legacy code from DBD Sybase to DBD ODBC which relied > heavily on the do() command.
I have a version you could try which should make the Statement attribute available from the database handle passed to the error handler. If you can build DBD::ODBC youurself and test it let me know and I'll tell you where to find it. Martin -- Martin J. Evans Wetherby, UK
From john_corcoran [...] trepp.com Tue Dec 14 11: 49:03 2010
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-19313-1292339401-762.63550-6-0 [...] rt.cpan.org>
Content-Class: urn:content-classes:message
X-Spam-Flag: NO
References: <RT-Ticket-63550 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com> <rt-3.8.HEAD-19308-1292259817-302.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19315-1292260968-547.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA3340A230449 [...] t2.trepp.com> <rt-3.8.HEAD-17550-1292333456-171.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19313-1292339401-762.63550-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: text/plain; charset="utf-8"
Message-ID: <7413EECCB04B5C4593E02C2DD1DFA3340A230463 [...] t2.trepp.com>
X-MS-Tnef-Correlator:
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 92955241331 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 14 Dec 2010 11:49:03 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id s76QkdNx0eBp for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 14 Dec 2010 11:49:02 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id D175E241285 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 14 Dec 2010 11:49:01 -0500 (EST)
Received: (qmail 1872 invoked by uid 103); 14 Dec 2010 16:49:01 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 14 Dec 2010 16:49:01 -0000
Received: from mail3.trepp.com (HELO proxy1.trepp.com) (68.167.78.174) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Tue, 14 Dec 2010 08:48:59 -0800
Received: from t2.trepp.com (t2.trepp.com [98.1.0.30]) by proxy1.trepp.com (Postfix) with ESMTP id 2081948553 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 14 Dec 2010 11:52:29 -0500 (EST)
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command
Return-Path: <john_corcoran [...] trepp.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-odbc
Thread-Index: AcuboRxmXLRXN/KNTf2Mj8RPq9v+LwADciUQ
Date: Tue, 14 Dec 2010 11:49:51 -0500
X-Spam-Level:
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command
X-Mimeole: Produced By Microsoft Exchange V6.5
To: <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: "John Corcoran" <john_corcoran [...] trepp.com>
RT-Message-ID: <rt-3.8.HEAD-17551-1292345344-1260.63550-0-0 [...] rt.cpan.org>
Content-Length: 982
Download (untitled) / with headers
text/plain 982b
Sure can. Just let me know where to find it and I will test it in my environment here. Show quoted text
-----Original Message----- From: Martin J Evans via RT [mailto:bug-DBD-ODBC@rt.cpan.org] Sent: Tuesday, December 14, 2010 10:10 AM To: John Corcoran Subject: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command <URL: https://rt.cpan.org/Ticket/Display.html?id=63550 > On Tue Dec 14 08:30:56 2010, john_corcoran@trepp.com wrote:
> That would be great. Thanks a lot. One solution on our end was not
to
> use the do() command, but this was easier said than done since we're > moving a lot of our legacy code from DBD Sybase to DBD ODBC which
relied
> heavily on the do() command.
I have a version you could try which should make the Statement attribute available from the database handle passed to the error handler. If you can build DBD::ODBC youurself and test it let me know and I'll tell you where to find it. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-17551-1292345344-1260.63550-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-63550 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA334090C0C90 [...] t2.trepp.com> <rt-3.8.HEAD-19308-1292259817-302.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19315-1292260968-547.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA3340A230449 [...] t2.trepp.com> <rt-3.8.HEAD-17550-1292333456-171.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19313-1292339401-762.63550-6-0 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA3340A230463 [...] t2.trepp.com> <rt-3.8.HEAD-17551-1292345344-1260.63550-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-17548-1292346376-27.63550-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 350
Download (untitled) / with headers
text/plain 350b
On Tue Dec 14 11:49:04 2010, john_corcoran@trepp.com wrote: Show quoted text
> Sure can. Just let me know where to find it and I will test it in my > environment here.
Should be arriving on a cpan mirror near you soon as 1.26_4. If you cannot see it and want it in the next half hour or so mail me and I can email it to yo. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-17548-1292346376-27.63550-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-17550-1292432992-1000.63550-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 479
Download (untitled) / with headers
text/plain 479b
On Tue Dec 14 12:06:16 2010, MJEVANS wrote: Show quoted text
> On Tue Dec 14 11:49:04 2010, john_corcoran@trepp.com wrote:
> > Sure can. Just let me know where to find it and I will test it in my > > environment here.
> > Should be arriving on a cpan mirror near you soon as 1.26_4. > > If you cannot see it and want it in the next half hour or so mail me and > I can email it to yo. > > Martin
Any progress on this? Can I write it off in 1.26_4 yet? Martin -- Martin J. Evans Wetherby, UK
From john_corcoran [...] trepp.com Wed Dec 15 12: 51:17 2010
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-17550-1292432992-542.63550-6-0 [...] rt.cpan.org>
Content-Class: urn:content-classes:message
X-Spam-Flag: NO
References: <RT-Ticket-63550 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-17550-1292432992-542.63550-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: text/plain; charset="utf-8"
Message-ID: <7413EECCB04B5C4593E02C2DD1DFA3340A2304B1 [...] t2.trepp.com>
X-MS-Tnef-Correlator:
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 2FE232412C8 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Wed, 15 Dec 2010 12:51:17 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id beGtu11rkNlc for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Wed, 15 Dec 2010 12:51:14 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 647622412C0 for <bug-DBD-ODBC [...] rt.cpan.org>; Wed, 15 Dec 2010 12:51:14 -0500 (EST)
Received: (qmail 3977 invoked by uid 103); 15 Dec 2010 17:51:13 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 15 Dec 2010 17:51:13 -0000
Received: from mail3.trepp.com (HELO proxy1.trepp.com) (68.167.78.174) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Wed, 15 Dec 2010 09:51:09 -0800
Received: from t2.trepp.com (t2.trepp.com [98.1.0.30]) by proxy1.trepp.com (Postfix) with ESMTP id BD5EAB23E9 for <bug-DBD-ODBC [...] rt.cpan.org>; Wed, 15 Dec 2010 12:54:44 -0500 (EST)
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command
Return-Path: <john_corcoran [...] trepp.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-odbc
Thread-Index: AcucewWH/Fb2YXP6RpWHQMEpIjKMZQABb9Yg
Date: Wed, 15 Dec 2010 12:52:00 -0500
X-Spam-Level:
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command
X-Mimeole: Produced By Microsoft Exchange V6.5
To: <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: "John Corcoran" <john_corcoran [...] trepp.com>
RT-Message-ID: <rt-3.8.HEAD-19311-1292435477-1861.63550-0-0 [...] rt.cpan.org>
Content-Length: 826
Download (untitled) / with headers
text/plain 826b
Works perfectly. Thanks for the fix. Show quoted text
-----Original Message----- From: Martin J Evans via RT [mailto:bug-DBD-ODBC@rt.cpan.org] Sent: Wednesday, December 15, 2010 12:10 PM To: John Corcoran Subject: [rt.cpan.org #63550] BUG with statement attribute not returned from $dbh do() command <URL: https://rt.cpan.org/Ticket/Display.html?id=63550 > On Tue Dec 14 12:06:16 2010, MJEVANS wrote:
> On Tue Dec 14 11:49:04 2010, john_corcoran@trepp.com wrote:
> > Sure can. Just let me know where to find it and I will test it in
my
> > environment here.
> > Should be arriving on a cpan mirror near you soon as 1.26_4. > > If you cannot see it and want it in the next half hour or so mail me
and
> I can email it to yo. > > Martin
Any progress on this? Can I write it off in 1.26_4 yet? Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19311-1292435477-1861.63550-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-63550 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292316470-1990.63550-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-17550-1292432992-542.63550-6-0 [...] rt.cpan.org> <7413EECCB04B5C4593E02C2DD1DFA3340A2304B1 [...] t2.trepp.com> <rt-3.8.HEAD-19311-1292435477-1861.63550-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19308-1292442088-946.63550-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 311
Download (untitled) / with headers
text/plain 311b
On Wed Dec 15 12:51:17 2010, john_corcoran@trepp.com wrote: Show quoted text
> Works perfectly. Thanks for the fix. >
Great. Can I be a little cheeky and ask you to provide a small review of DBD::ODBC on "rate this distribution" link at http://search.cpan.org/~mjevans/DBD-ODBC-1.25/. Martin -- Martin J. Evans Wetherby, UK


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.