Re: commit vs rollback on $dbh-{AutoCommit} = 1 ?

2004-01-13 Thread Jonathan Leffler
Dean Arnold wrote: On a related note, is there a need/desire for a std. readonly connection attribute to determine if the connection is currently in a transaction ? E.g., $dbh-commit() if $dbh-{InTransaction}; I've hacked my own version of this in DBD::Teradata for an IDE I've built.

RE: commit vs rollback on $dbh-{AutoCommit} = 1 ?

2004-01-13 Thread Henrik Tougaard
Dean Arnold skrev: On a related note, is there a need/desire for a std. readonly connection attribute to determine if the connection is currently in a transaction ? E.g., $dbh-commit() if $dbh-{InTransaction}; Yes, please in Ingres it is possible to ask the DBMS for transaction

Re: Announce: Release Candidate of DBD::Oracle 1.15 available

2004-01-13 Thread Tim Bunce
On Mon, Jan 12, 2004 at 05:48:48PM -0500, Jeff Urlwin wrote: Almost 4 months after the previous release candidate, and 10 months after the last full release, here's another release candidate: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.15-rc2-20040 112.tar.gz Works

Re: Announce: Release Candidate of DBD::Oracle 1.15 available

2004-01-13 Thread Tim Bunce
On Tue, Jan 13, 2004 at 09:17:51AM +0100, Steffen Goeldner wrote: Tim Bunce wrote: Almost 4 months after the previous release candidate, and 10 months after the last full release, here's another release candidate:

Re: DBI, DBD::ADO and SUCCESS_WITH_INFO

2004-01-13 Thread Steffen Goeldner
Tim Bunce wrote: My current plan is to add a $h-{HandleEvent} = sub { ... } hook that can be used for SUCCESS_WITH_INFO and other events the driver may want to communicate back to an application. Meanwhile I suggest that you add a $h-{ado_event} = sub { ... } and and use that however you

Re: Announce: Release Candidate of DBD::Oracle 1.15 available

2004-01-13 Thread Lincoln A. Baxter
On Mon, 2004-01-12 at 14:57, Andy Hassall wrote: Didn't get much time to test it on actual scripts today, but 1.15-rc2 built and tested OK on Solaris 2.7 / 9.2.0.4 / 32-bit - the build problems from 1.14 appear to be fixed. I did not get to my solaris 2.8 / oracle 9.2.04 test I promised

Re: DBI version 2

2004-01-13 Thread H.Merijn Brand
On Mon 12 Jan 2004 16:59, H.Merijn Brand [EMAIL PROTECTED] wrote: A. What changes you'd like to see in the DBI API. Me and my colleages seem very satisfied :) How about a new attribute: AutoTruncate so I can just put grkaerhgkjehrgkaerhg in a varcar/char (3) and it will store grk --

Re: DBI, DBD::ADO and SUCCESS_WITH_INFO

2004-01-13 Thread Tim Bunce
On Tue, Jan 13, 2004 at 12:35:07PM +0100, Steffen Goeldner wrote: Tim Bunce wrote: My current plan is to add a $h-{HandleEvent} = sub { ... } hook that can be used for SUCCESS_WITH_INFO and other events the driver may want to communicate back to an application. Meanwhile I suggest

RE: DBI version 2 - 3 API change suggestions

2004-01-13 Thread Henrik Tougaard
Tim Bunce skrev: A. What changes you'd like to see in the DBI API. B. What changes you'd like to see in the DBD API (that's the DBI-DBD interface). 1) The Ingres Open/API has the possibility of doing async db-access, ie starting a database request and then at a later point in time

Re: DBI version 2

2004-01-13 Thread Tim Bunce
On Mon, Jan 12, 2004 at 04:59:38PM +0100, H.Merijn Brand wrote: B. What changes you'd like to see in the DBD API (that's the DBI-DBD interface). · All dbh handel offspring (statement handles and such) available from the top level handle, for both status and cleanup purposes

Re: DBI version 2

2004-01-13 Thread H.Merijn Brand
On Tue 13 Jan 2004 15:42, Tim Bunce [EMAIL PROTECTED] wrote: On Mon, Jan 12, 2004 at 04:59:38PM +0100, H.Merijn Brand wrote: B. What changes you'd like to see in the DBD API (that's the DBI-DBD interface). · All dbh handel offspring (statement handles and such) available from

Re: commit vs rollback on $dbh-{AutoCommit} = 1 ?

2004-01-13 Thread John Siracusa
On 1/13/04 2:05 AM, Jonathan Leffler wrote: Dean Arnold wrote: On a related note, is there a need/desire for a std. readonly connection attribute to determine if the connection is currently in a transaction ? Yes! I have written more DBI wrappers in my day than I care to remember, and nearly

RE: CVS Repository for DBI (was RE: DBI version 2)

2004-01-13 Thread Jeff Urlwin
On Mon, Jan 12, 2004 at 05:53:00PM -0500, Jeff Urlwin wrote: Plans: 1. Move DBI source code to http://sourceforge.net/projects/dbi/ Tim, On and Off I've thought about moving DBD::ODBC to a CVS repository and searched for a tool that would take old tarballs of prior

RE: DBI version 2 - 3 API change suggestions

2004-01-13 Thread Dean Arnold
From: Henrik Tougaard [EMAIL PROTECTED] To: 'Tim Bunce' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: DBI version 2 - 3 API change suggestions 1) The Ingres Open/API has the possibility of doing async db-access, ie starting a database request and then at a later point in time either

RE: Announce: Release Candidate of DBD::Oracle 1.15 available

2004-01-13 Thread Jeff Urlwin
Works on Perl 5.6.1, MSWin32, Borland 5.5, Oracle 8.1.7, except the LONG issue: t\base...ok t\cursor.ok t\generalok t\long...ok 59/372# failed test 60 at line 328. t\long...ok 61/372# failed test 68 at line 328. New bug triggered by NLS lang I think. What are your

Re: Conformance test script for drivers

2004-01-13 Thread Tim Bunce
Umm, maybe I'm misunderstanding you but I looked at 11-dbi-dbh.t http://search.cpan.org/src/HMBRAND/DBD-Unify-0.26/t/11-dbi-dbh.t and it seems full of unify specifics. What's needed is for someone (us) to *design* a scheme for the infrastructure of a DBD test harness. The key part being how an

Re: DBI version 2

2004-01-13 Thread Jonathan Leffler
H.Merijn Brand wrote: Tim Bunce wrote: A. What changes you'd like to see in the DBI API. How about a new attribute: AutoTruncate so I can just put grkaerhgkjehrgkaerhg in a varcar/char (3) and it will store grk That happens anyway in DBD::Informix - the DBMS does it. There is a warning raised,