Re: Savepoint support proposal

2005-03-10 Thread Tim Bunce
On Thu, Mar 10, 2005 at 08:54:54AM -, Martin J. Evans wrote: although ODBC does not define what happens if one of the commits on a connection fails (this alone probably makes commiting on an environment unpopular if used at all). Exactly. This (commit_all etc) won't make it into the DBI

Re: Savepoint support proposal

2005-03-10 Thread Tim Bunce
On Thu, Mar 10, 2005 at 10:54:37AM -, Martin J. Evans wrote: On 10-Mar-2005 Tim Bunce wrote: On Thu, Mar 10, 2005 at 08:54:54AM -, Martin J. Evans wrote: although ODBC does not define what happens if one of the commits on a connection fails (this alone probably makes commiting

Re: Savepoint support proposal

2005-03-08 Thread Tim Bunce
On Mon, Mar 07, 2005 at 11:47:32PM -, Greg Sabino Mullane wrote: While I don't have any particular objections, doesn't Pg (and most other DBMSs supporting savepoints) have SQL syntax to implement them ? If so, isn't just $dbh-do(savepoint-sql) sufficient ? Sure, but they

Re: Savepoint support proposal

2005-03-07 Thread Tim Bunce
On Sun, Mar 06, 2005 at 08:41:01PM -0800, Dean Arnold wrote: Greg Sabino Mullane wrote: We are working on implementing savepoint support in DBD::Pg, and someone pointed out (quite rightly) that perhaps there should be DBI method support for savepoints, as they are a standard SQL construct

Re: patch for DBI 1.47

2005-03-07 Thread Tim Bunce
On Mon, Mar 07, 2005 at 01:24:43PM +0100, Jens Hinrichs wrote: Hallo, in an older version of DBI (i think it was 1.43) there was an warning in line 1317. Use of uninitialized value in concatencation (.) or string at... in the 1.47 Version the bug is fixed in an (for me) unclean way: my

Re: [Fwd: Re: Handle Creation with new_child()]

2005-02-22 Thread Tim Bunce
On Mon, Feb 21, 2005 at 04:10:29PM -0800, David Wheeler wrote: On Feb 21, 2005, at 2:17 PM, Tim Bunce wrote: Which is also pretty easily done, eh? Something like this? Yes, though I wouldn't bother validating the contents of the hash. Just checking you're getting a hash ref is enough I

Re: new DBD::Yaswi

2005-02-21 Thread Tim Bunce
On Mon, Feb 21, 2005 at 05:23:47PM +, Salvador FandiƱo wrote: Hi, I am working on a DBD backend for SWI-Prolog (http://www.swi-prolog.org). As it runs on top of my module Language::Prolog::Yaswi, I have called it DBD::Yaswi and I would like to register it and the yaswi_ prefix on the

Re: Handle Creation with new_child()

2005-02-15 Thread Tim Bunce
On Tue, Feb 15, 2005 at 10:38:20AM -0800, David Wheeler wrote: On Feb 14, 2005, at 3:09 AM, Tim Bunce wrote: [On the roadmap/todo there's an item about recording the names of all attributes that have been set on a handle. That may also be useful here so drivers can be led by what attributes

Re: Handle Creation with new_child()

2005-02-14 Thread Tim Bunce
On Sun, Feb 13, 2005 at 05:54:40PM -0800, David Wheeler wrote: On Feb 13, 2005, at 2:44 PM, Tim Bunce wrote: The DBD::_::connect method then becomes just something like my $dbh = $drh-new_child($attr) or return; $dbh-connect(...) or return; return $dbh; then we kindly

Re: DBI::DBD::Metadata: type_info_all

2005-02-13 Thread Tim Bunce
Thanks Steffen, applied. Tim. On Thu, Feb 10, 2005 at 11:59:38AM +0100, Steffen Goeldner wrote: A DBI driver should pass the following tests: my @ti = $dbh-type_info; ok( @ti,'type_info'); my $tia = $dbh-type_info_all; is( ref $tia,'ARRAY','type_info_all'); my $idx = shift

Re: Callbacks

2005-02-12 Thread Tim Bunce
On Fri, Feb 11, 2005 at 11:18:34AM -0800, David Wheeler wrote: On Feb 4, 2005, at 10:38 AM, David Wheeler wrote: That's starting to get might complex, isn't it? Uh, mite. :-) Or mighty, perhaps. Tim.

Callbacks

2005-02-04 Thread Tim Bunce
On Thu, Feb 03, 2005 at 03:49:11PM -0800, David Wheeler wrote: On Feb 3, 2005, at 3:30 PM, Tim Bunce wrote: Should be pretty straight-forward. Are there other events for which you'd like to add callbacks? OnPrepare, perhaps? OnExecute? OnFetch? Yes, but let's just start with the connect

Re: problems building DBD::Oracle 1.16 - help - please

2005-02-03 Thread Tim Bunce
On Wed, Feb 02, 2005 at 10:20:32PM -0500, Adam Stoller wrote: PREAMBLE: This may be the wrong address to send this to, if so I appologize and hope some kind soul will help direct me to whom/where I can get some assistance. And yes, I did read the README files - and I either

Re: AutoCommit and connect_cached()

2005-02-03 Thread Tim Bunce
On Wed, Feb 02, 2005 at 10:50:20AM -0800, David Wheeler wrote: On Feb 2, 2005, at 2:59 AM, Tim Bunce wrote: Ah, I see. But loking at DBI::_::dr::connect_cached, it looks as though connect() isn't called if it finds an active, pingable driver in the cache. That's right. I must still

Re: AutoCommit and connect_cached()

2005-02-03 Thread Tim Bunce
On Thu, Feb 03, 2005 at 08:40:48AM -0800, David Wheeler wrote: On Feb 3, 2005, at 7:45 AM, Tim Bunce wrote: + my $no_reset = delete $attr-{NoReset}; + %$attr = () if $no_reset; If this looks good to you, I can add a test for it and update the docs and send that patch. Any

DBI v2 - or not

2005-02-03 Thread Tim Bunce
On Thu, Feb 03, 2005 at 08:40:48AM -0800, David Wheeler wrote: That's planned for DBI v2, but it seems DBI v2 isn't going to happen anytime soon so I'm wondering if it's something I should squeeze into DBI v1. What's happened on the DBI v2 front? Nothing much. The call for funding wasn't a

Re: DBD::JDBC prefix registration request

2005-01-14 Thread Tim Bunce
On Thu, Jan 13, 2005 at 03:17:28PM -0800, Gennis Emerson wrote: Could the prefix jdbc_ be registered for DBD::JDBC? Done. Tim.

Re: DBD::JDBC autoload/func implementation question

2005-01-14 Thread Tim Bunce
On Thu, Jan 13, 2005 at 04:04:57PM -0800, Gennis Emerson wrote: I'm trying to get DBD::JDBC functional with the latest DBI release. Great. Architecturally, it's a Perl DBD layer which marshals requests and sends them to a Java server which then uses JDBC to talk to the underlying database.

Re: Proposing an API for the extension for simplifying database connections

2005-01-14 Thread Tim Bunce
On Fri, Jan 14, 2005 at 03:30:33PM -0600, David Nicol wrote: wow I did not expect such negativity... See Yves Orton's dicsussion on dbi-users for what this does. I'm simply convinced of the correctness of the feature and proposing a low-impact way to fit it into the larger DBI picture.

Re: JPL v/s Java Inline

2005-01-12 Thread Tim Bunce
On Wed, Jan 12, 2005 at 02:56:47PM +0530, Manoj Kumar wrote: Hi, Would any one plz tell me what is difference between JPL and Java Inline. Which one is best..? . This is not the right forum for such questions. The dbi-dev@perl.org list is for issues related to developing the Perl

Re: How to call a java method in PERL

2005-01-11 Thread Tim Bunce
On Tue, Jan 11, 2005 at 02:46:46PM +0530, Manoj Kumar wrote: I would like to know from Perl community , how to I give call to a java method from perl . Thanks --mksheoran http://www.catb.org/~esr/faqs/smart-questions.html Tim.

Re: DBD::ExampleP: attribute handling (outer/inner handles, $h-STORE vs. $h-{})

2004-12-17 Thread Tim Bunce
Thanks, applied. Tim. On Fri, Dec 17, 2004 at 11:33:24AM +0100, Steffen Goeldner wrote: Changed DBD::ExampleP to reflect the recent changes to DBI::DBD. Steffen Index: lib/DBD/ExampleP.pm === --- lib/DBD/ExampleP.pm

Re: DBI::DBD: Other statement methods

2004-12-17 Thread Tim Bunce
On Fri, Dec 17, 2004 at 02:15:57PM +0100, Steffen Goeldner wrote: P.S.: This was my last patch this year. Thanks, applied. I wish all a Merry Christmas and a Happy New Year! Thanks Steffen. And many thanks for all your well-considered and well-presented patches. Tim.

Re: DBI::DBD: attribute handling (outer/inner handles, $h-STORE vs. $h-{})

2004-12-17 Thread Tim Bunce
On Thu, Dec 16, 2004 at 10:58:35AM +0100, Steffen Goeldner wrote: However, it's placed below the connect() method: http://search.cpan.org/~timb/DBI-1.46/lib/DBI/DBD.pm#The_database_handle_constructor where we have an outer handle by way of an exception! Instead of changing the nice

Re: DBI::DBD: attribute handling (outer/inner handles, $h-STORE vs. $h-{})

2004-12-16 Thread Tim Bunce
On Thu, Dec 16, 2004 at 03:19:57PM +0100, Steffen Goeldner wrote: Tim Bunce wrote: [...] + # add driver prefix to attribute name if it doesn't have it already + $attr_name = $driver_prefix.$attr_name + unless $attr_name =~ /^$driver_prefix/o

Re: DBI::DBD: attribute handling (outer/inner handles, $h-STORE vs. $h-{})

2004-12-16 Thread Tim Bunce
I've added this: + $my $driver_prefix = drv_; # the assigned prefix for this driver + + # Process attributes from the DSN; we assume ODBC syntax + # here, that is, the DSN looks like var1=val1;...;varN=valN + foreach my $var ( split /;/, $dbname ) { + my ($attr_name,

Re: DBI::DBD: err/errstr/state - and how it has helped DBD::Informix

2004-12-15 Thread Tim Bunce
On Tue, Dec 14, 2004 at 06:24:40PM -0800, Jonathan Leffler wrote: On Tue, 14 Dec 2004 16:47:39 +, Tim Bunce [EMAIL PROTECTED] wrote: On Tue, Dec 14, 2004 at 07:08:08AM -0800, Jonathan Leffler wrote: I had certainly managed to miss this change - which could easily account for some

Re: DBI::DBD: err/errstr/state - and how it has helped DBD::Informix

2004-12-15 Thread Tim Bunce
On Wed, Dec 15, 2004 at 07:27:59AM -0800, Jonathan Leffler wrote: Sorry for this flurry of half-researched questions... :-( I'll probably be able to submit another patch to DBI::DBD.pm out of this. Great! Thanks. Tim. p.s. Patch against subversion if possible. If not grab the latest from

Re: DBI::DBD: err/errstr/state

2004-12-14 Thread Tim Bunce
On Tue, Dec 14, 2004 at 07:08:08AM -0800, Jonathan Leffler wrote: I had certainly managed to miss this change - which could easily account for some of the weirdnesses I'd been seeing in DBD::Informix. (I haven't had a chance to do a thing for a week and more.) This sort of backwards

Re: Perl complaining when I pass a list of nulls (undef) to $sth-execute() - workaround?

2004-12-14 Thread Tim Bunce
On Tue, Dec 14, 2004 at 02:13:17PM -0800, Jonathan Leffler wrote: On Fri, 3 Dec 2004 20:54:00 +, Tim Bunce [EMAIL PROTECTED] wrote: On Fri, Dec 03, 2004 at 12:15:06PM -0800, Jonathan Leffler wrote: Use of uninitialized value in subroutine entry at t/t91udts.t line 97. $sth

Re: DBI::DBD: err/errstr/state

2004-12-13 Thread Tim Bunce
Thanks, applied. Tim. On Tue, Dec 14, 2004 at 10:12:54AM +0100, Steffen Goeldner wrote: DBI 1.31 suggests that lexically scoped variables should be passed to _new_dbh(): http://search.cpan.org/~timb/DBI/Changes#Changes_in_DBI_1.31,_29th_November_2002 DBI 1.33 suggests that drivers

Re: Perl complaining when I pass a list of nulls (undef) to $sth-execute() - workaround?

2004-12-06 Thread Tim Bunce
On Mon, Dec 06, 2004 at 10:09:25AM +0100, Steffen Goeldner wrote: Jonathan Leffler wrote: Testing null handling in DBD::Informix 2004.02 (pre-release), I'm getting a warning from Perl: Use of uninitialized value in subroutine entry at t/t91udts.t line 97. Some day I got the same warning

Re: DBI::DBD: Should DESTROY() call finish()?

2004-12-06 Thread Tim Bunce
On Mon, Dec 06, 2004 at 09:46:06AM +0100, Steffen Goeldner wrote: DBI::DBD informs us that The DBI Driver.xst code will call dbd_st_finish for you, if the sth has the ACTIVE flag set, before calling dbd_st_destroy. However, a pure perl DBD doesn't operate in such a luxurious

Re: Perl complaining when I pass a list of nulls (undef) to $sth-execute() - workaround?

2004-12-06 Thread Tim Bunce
On Mon, Dec 06, 2004 at 10:30:03AM +, Tim Bunce wrote: I've appended a provisional patch. Here's one that works: @@ -2870,7 +2872,11 @@ sprintf(intro,%s %s %s: , HvNAME(DBIc_IMP_STASH(imp_xxh)), err_meth_name, SvTRUE(err_sv) ? failed : is_warning ? warning : information

Re: Perl 5.6.1 - What changed in error handling between DBI 1.42 and DBI 1.43 that would affect $SIG{__WARN__} handling?

2004-12-06 Thread Tim Bunce
On Mon, Dec 06, 2004 at 09:10:33AM -0800, Jonathan Leffler wrote: On Fri, 3 Dec 2004 21:04:11 +, Tim Bunce [EMAIL PROTECTED] wrote: On Thu, Dec 02, 2004 at 04:07:13PM -0800, Jonathan Leffler wrote: unless ($dbh = $drh-$connect_meth($dsn, $user, $pass, $attr

Re: what does it take to make DBI:: DBD::* thread-safe?

2004-12-03 Thread Tim Bunce
On Fri, Dec 03, 2004 at 07:55:39AM +0100, Michael Peppler wrote: On Thu, 2004-12-02 at 18:28, Stas Bekman wrote: Hi, As mod_perl 2 is going to be released shortly the issue with DBI and friends not being thread-safe (I believe DBI is fine, but DBDs are not) becomes a problem. Since

Re: what does it take to make DBI:: DBD::* thread-safe?

2004-12-03 Thread Tim Bunce
On Fri, Dec 03, 2004 at 10:05:50AM -0500, Stas Bekman wrote: Michael Peppler wrote: On Thu, 2004-12-02 at 18:28, Stas Bekman wrote: Hi, As mod_perl 2 is going to be released shortly the issue with DBI and friends not being thread-safe (I believe DBI is fine, but DBDs are not) becomes a

Re: Perl 5.6.1 - What changed in error handling between DBI 1.42 and DBI 1.43 that would affect $SIG{__WARN__} handling?

2004-12-03 Thread Tim Bunce
On Thu, Dec 02, 2004 at 04:07:13PM -0800, Jonathan Leffler wrote: Dear Tim, I was just getting ready to ship DBD::Informix 2004.02 when I made the mistake of testing it with Perl 5.6.1 and DBI 1.46. I ran into problems with a DBD::Informix test that was expecting an error code to be set

Re: DBDI website?

2004-11-28 Thread Tim Bunce
On Sun, Nov 28, 2004 at 02:01:23PM -0500, Stas Bekman wrote: I wanted to point someone to the DBDI project, but didn't find anything but http://groups.google.com/[EMAIL PROTECTED] Are there plans for dbdi.perl.org or something like that? Yes, once there's something other than vapor. At

Re: the scope of dbi-dev (was: lifetime of prepared ...)

2004-11-24 Thread Tim Bunce
On Tue, Nov 23, 2004 at 10:39:48PM -0800, Jonathan Leffler wrote: On Tue, 23 Nov 2004 13:20:20 -0800, Darren Duncan [EMAIL PROTECTED] wrote: First of all, thanks to those of you who replied to my question. Very helpful. At 3:18 PM + 11/23/04, Tim Bunce wrote: You've got a lot

Re: Problem with 'Username' attribute

2004-11-17 Thread Tim Bunce
On Wed, Nov 17, 2004 at 09:09:32AM -0500, Steven N. Hirsch wrote: Tim, I'm working on qualifying perl-5.8.3 and DBI-1.46 for a critical application which uses DBI. We've been running with perl-5.8.0 + DBI-1.35 for quite a while (color me conservative when my job's at stake). After

ANNOUNCE: DBI 1.46 release candidate

2004-11-14 Thread Tim Bunce
http://homepage.eircom.net/~timbunce/DBI-1.46-rc1-20041114.tar.gz =head2 Changes in DBI 1.46 (svn rev 581),14th November 2004 Fixed parsing bugs in DBI::SQL::Nano thanks to Jeff Zucker. Fixed a couple of bad links in docs thanks to Graham Barr. Fixed test.pl Win32 undef warning

Re: New execute_array() semantics break existing code

2004-11-12 Thread Tim Bunce
On Thu, Nov 11, 2004 at 08:39:42PM +, Brian McCauley wrote: $sth-execute_array({ ArrayTupleStatus = [] }, FOO, [] ); ...used to be a no-op and now is equvalent to... $sth-execute ( FOO, undef); IMHO there is no good reason for this. If I pass an empty array I expect nothing to

Re: DBI::DBD::Metadata: VERSION, SQL_DRIVER_NAME

2004-11-08 Thread Tim Bunce
[EMAIL PROTECTED], -Steffen Goeldner [EMAIL PROTECTED], +Steffen Goeldner [EMAIL PROTECTED], and Tim Bunce [EMAIL PROTECTED]. =cut

Re: ANNOUNCE: DBD::Oracle 1.16

2004-10-28 Thread Tim Bunce
On Thu, Oct 28, 2004 at 05:19:53PM +0200, H.Merijn Brand wrote: On Fri 22 Oct 2004 23:36, Tim Bunce [EMAIL PROTECTED] wrote: Added Test::More as a prerequisite module. Now you're (also) using Test::More, I suggest using it a way that makes debugging easier once things fail: Patches

Re: ANNOUNCE: DBD::Oracle 1.16

2004-10-27 Thread Tim Bunce
On Wed, Oct 27, 2004 at 09:39:33AM +0200, H.Merijn Brand wrote: On Fri 22 Oct 2004 23:36, Tim Bunce [EMAIL PROTECTED] wrote: file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.16.tar.gz size: 235224 bytes md5: 9711550ed0ebfc743920a6a357ed717c I know you can't blame the test

Re: [svn:dbd-oracle] rev 515 - dbd-oracle/trunk

2004-10-23 Thread Tim Bunce
On Fri, Oct 22, 2004 at 11:30:20PM -0400, Lincoln A. Baxter wrote: On Fri, 2004-10-22 at 17:28, Andy Hassall wrote: [snip] I can see there being an ultimate character set torture test with the Encode module, and working out the intersection between NLS_LANG's character set and that of the

Re: Suggestion - use gmail accounts for receiving bug reports, etc.

2004-10-22 Thread Tim Bunce
On Thu, Oct 21, 2004 at 11:05:22PM -0700, Jonathan Leffler wrote: You can decide whether or not it is a good idea for you to follow suit, but for the next release of DBD::Informix, the documented email contact point is going to be [EMAIL PROTECTED] I'd use a dash if Gmail allowed it, but they

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing (RC8)

2004-10-22 Thread Tim Bunce
On Fri, Oct 22, 2004 at 09:53:06AM +0200, Steffen Goeldner wrote: Tim Bunce wrote: On Thu, Oct 21, 2004 at 06:57:20PM +0200, Honza Pazdziora wrote: On Thu, Oct 21, 2004 at 06:46:15PM +0200, H.Merijn Brand wrote: On Thu 21 Oct 2004 18:20, Tim Bunce [EMAIL PROTECTED] wrote: Please try

Re: Named bind params with DBD::Proxy

2004-10-22 Thread Tim Bunce
On Thu, Oct 21, 2004 at 05:00:56PM -0500, Scott T. Hildreth wrote: Tim, Are you still maintaining DBD::Proxy? Yes, with a loose definition of the word maintaining. Have you had a request for supporting named parameters? Tim Howell [CC'd] volunteered but not much has happened. I could

Re: Suggestion - use gmail accounts for receiving bug reports, etc.

2004-10-22 Thread Tim Bunce
On Fri, Oct 22, 2004 at 01:14:42PM -0700, Jonathan Leffler wrote: On Fri, 22 Oct 2004 09:31:00 +0100, Tim Bunce [EMAIL PROTECTED] wrote: On Thu, Oct 21, 2004 at 11:05:22PM -0700, Jonathan Leffler wrote: You can decide whether or not it is a good idea for you to follow suit

Re: Named bind params with DBD::Proxy

2004-10-22 Thread Tim Bunce
On Fri, Oct 22, 2004 at 09:00:23AM -0700, Tim Howell wrote: Just a quick note to let everyone know that I haven't dropped off the face of the planet and am, indeed working on DBD::Proxy. I got slammed by a couple of projects on my return from OSCON and the programming side of my job was

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing (RC8)

2004-10-21 Thread Tim Bunce
On Thu, Oct 21, 2004 at 08:53:40AM +0200, Steffen Goeldner wrote: Tim Bunce wrote: Yes, another release candidate! You know, my Borland compiler is now in picky mode: 'typename' is only allowed in template declarations in function ... Patch attached. Thanks, applied. Tim

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing (RC8)

2004-10-21 Thread Tim Bunce
On Thu, Oct 21, 2004 at 09:07:01AM +0200, Steffen Goeldner wrote: Tim Bunce wrote: t\21nchar... Database and client versions and character sets: Database 8.1.7.2.1 CHAR set is WE8ISO8859P1 (Non-Unicode), NCHAR set is WE8ISO8859P1 (Non-Unicode) Client 8.1.7.0 NLS_LANG

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing (RC8)

2004-10-21 Thread Tim Bunce
ON Thu, Oct 21, 2004 at 10:41:28AM +0100, Tim Bunce wrote: On Thu, Oct 21, 2004 at 07:52:42AM +0200, Honza Pazdziora wrote: t/25plsql is now clean. The perl -Mblib yields Can't select from function (ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG2' ORA-06553

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing (RC8)

2004-10-21 Thread Tim Bunce
On Thu, Oct 21, 2004 at 06:57:20PM +0200, Honza Pazdziora wrote: On Thu, Oct 21, 2004 at 06:46:15PM +0200, H.Merijn Brand wrote: On Thu 21 Oct 2004 18:20, Tim Bunce [EMAIL PROTECTED] wrote: Please try this patch over the original. Describe failed during DBI::st=HASH(0x402091a8)-FETCH

ANNOUNCE: DBD::Oracle 1.16 release candidate for testing (RC8)

2004-10-20 Thread Tim Bunce
Yes, another release candidate! I think I've finally got to the bottom of the character set issues. (Thanks in part to Lincoln providing me with an account on a system with several test databases with different combinations of CHAR and NCHAR character sets. Thanks Lincoln.) This release has

(Fwd) CPAN Upload: T/TI/TIMB/DBI-1.45.tar.gz

2004-10-08 Thread Tim Bunce
Since I've not announced this yet, and DBD::Sybase required some changes[1] for it I figure I should announce it here to give you all a chance to check your drivers with it. file: $CPAN/authors/id/T/TI/TIMB/DBI-1.45.tar.gz size: 369502 bytes md5: 31ac7c8aea0ebc61c3a9fc120a770fbd Early

Re: DBD::Oracle: 'no prototype' warnings (Borland)

2004-10-04 Thread Tim Bunce
On Mon, Oct 04, 2004 at 03:58:54PM +0200, Steffen Goeldner wrote: Tim Bunce wrote: On Fri, Oct 01, 2004 at 01:46:45PM +0200, Steffen Goeldner wrote: Tim Bunce wrote: I can live with assuming support for ANSI C style prototypes since we already effectively require perl 5.6

Re: DBD::Oracle: 'no prototype' warnings (Borland)

2004-10-01 Thread Tim Bunce
On Fri, Oct 01, 2004 at 01:46:45PM +0200, Steffen Goeldner wrote: Tim Bunce wrote: I can live with assuming support for ANSI C style prototypes since we already effectively require perl 5.6 and that requires ANSI C. O.k., attached are the KR = ANSI patches for dbdimp.c and oci8.c. Thanks

Re: DBD::Oracle: 'no prototype' warnings (Borland)

2004-09-30 Thread Tim Bunce
On Thu, Sep 30, 2004 at 10:29:25AM +0200, Steffen Goeldner wrote: Tim Bunce wrote: On Wed, Sep 22, 2004 at 03:52:09PM +0200, Steffen Goeldner wrote: Compiling DBD::Oracle with Borland C++ 5.5, I have a bunch of warnings: [...] 1. ignore the warnings :-( 2. suppress the warnings (-w

Re: Shared lib problem

2004-09-28 Thread Tim Bunce
On Mon, Sep 27, 2004 at 07:14:58PM +0200, H.Merijn Brand wrote: I'm trying to build a 64bit DBD::Unify on DBI::1.43 on HP-UX 11i with 5.8.5-dor/64, and all tests fail. tusc/truss (HP's counterpart of strace) shows me the need to open DESTROY.al, which cannot be found. I don't think that's

Re: interface ideas for non-blocking mode

2004-09-10 Thread Tim Bunce
On Fri, Sep 10, 2004 at 03:15:38AM -0500, David Nicol wrote: I was not aware of the risk of select hanging due to a signal coming in before select can set its timer. Has anyone on this list ever been bitten by such a thing? Is Perl vulnerable to this situation or is it taken care of

Re: [Patch] DBI tests on Win32 dealing with /dev/null.

2004-09-09 Thread Tim Bunce
On Thu, Sep 09, 2004 at 12:28:27PM -0400, Jeff Urlwin wrote: Doh. Yes. Didn't think about File::Spec and devnull()...I learn something new every day. -- yet it seems that it's still not fast enough ;) The patch would have been perfect[1] if it hadn't been wrapped by your mailer :) Thanks.

Re: Test cases on DBI-1.43

2004-09-08 Thread Tim Bunce
On Wed, Sep 08, 2004 at 03:49:57PM +0200, H.Merijn Brand wrote: I have this piece of test case in my DBD test code that succeeded in 1.42, but now fails in 1.43 ok ($sth-execute, execute); ok ($sth-{NUM_OF_FIELDS}, NUM_OF_FIELDS); eval { my $typo = $sth-{NUM_OFFIELDS_typo} };

Re: UTF-8 flags (again)

2004-09-08 Thread Tim Bunce
On Wed, Sep 08, 2004 at 09:15:36AM -0700, David Wheeler wrote: On Sep 8, 2004, at 4:45 AM, Tim Bunce wrote: I was thinking of doing at least 0 on that list for DBI 1.44. I'd especially like to do $dbh-{SetUTF8} = 2; And be done with it. I'll take a look. Patches welcome

Re: interface ideas for non-blocking mode

2004-09-02 Thread Tim Bunce
On Thu, Sep 02, 2004 at 01:52:59PM +0100, Matt Sergeant wrote: On 1 Sep 2004, at 03:13, david nicol wrote: Based on this comment I would like to extend the proposed extension to include an optional $h-fileno() method, which would return an arrayref containing file descriptor numbers for use

Re: MakeMaker question

2004-08-31 Thread Tim Bunce
On Mon, Aug 30, 2004 at 04:47:01PM -0700, Darren Duncan wrote: More than one of my pure-Perl CPAN distributions contains extra .pm files which are only used during 'make test', but I have so far had to put them in my 'lib' directory with the normal modules so that they can be seen during

Re: How to use sequences in DBI/DBD::Oracle

2004-08-31 Thread Tim Bunce
This is a question for the dbi-users mailing list not dbi-dev. Please repost there. Also, research Oracle's RETURNING clause for INSERTstatements. Tim.

DEFAULT clause without NOT NULL?

2004-08-29 Thread Tim Bunce
Do any databases support CREATE TABLE statement with fields having a DEFAULT clause without a NOT NULL? CREATE TABLE foo ( bar INTEGER, baz INTEGER DEFAULT 42 ) and if so, under what circumstances is the default applied? I can imagine it meaning that

Re: interface ideas for non-blocking mode

2004-08-26 Thread Tim Bunce
On Thu, Aug 26, 2004 at 12:02:19AM -0500, david nicol wrote: In the recent roadmap announcement, Tim Bunce wrote: =head2 Other Enhancements * Support non-blocking mode for drivers that can enable it in their client API. I have just startedworking with DBI but I'm doing something

I have 6 google gmail invites if anyone wants one

2004-08-25 Thread Tim Bunce
I have 6 google gmail invites available. If anyone wants one please reply to me (not the list). It's first come first served. To save time I reply to anyone after the 6 are gone. FYI I find gmail doesn't work well for the volume of mailing list email I get. But the searching is handy so I just

Re: I have 6 google gmail invites if anyone wants one

2004-08-25 Thread Tim Bunce
All gone. (I've received more than 6 requests but haven't replied yet.) Tim. On Wed, Aug 25, 2004 at 02:14:19PM +0100, Tim Bunce wrote: I have 6 google gmail invites available. If anyone wants one please reply to me (not the list). It's first come first served. To save time I reply to anyone

Re: DBI-1.43 + DBD-CSV-0.21

2004-08-24 Thread Tim Bunce
Aplied. Thanks. Tim. On Wed, Aug 11, 2004 at 07:01:11PM -0700, Jan Dubois wrote: Merijn wrote: HP-UX 11i (11.11) + perl-5.8.5-dor + DBI-1.43 + DBD-CSV-0.21 Failed Test Stat Wstat Total Fail Failed List of Failed

Re: DBI-1.43 on Cygwin

2004-08-24 Thread Tim Bunce
On Tue, Aug 24, 2004 at 09:49:41AM +0200, H.Merijn Brand wrote: t/zvpp_01basics...ok 104/110Argument 1.70_01 isn't numeric in numeric ge (=) at /P/DBI-1.43/blib/lib/DBI/PurePerl.pm line 525. Argument 1.70_01 isn't numeric in numeric ge (=) at /P/DBI-1.43/blib/lib/DBI/PurePerl.pm line

Re: DBI Roadmap

2004-08-24 Thread Tim Bunce
On Tue, Aug 10, 2004 at 10:44:49PM -0700, Jonathan Leffler wrote: DBD::Informix has always implemented things so that the $drh has a list of the $dbh that have been opened on it, and each $dbh has a list of the $sth that have been created on it. But I don't particularly like having to do

Re: commoditization suggestion #1 - disconnect() transaction behaviour

2004-08-24 Thread Tim Bunce
On Mon, Aug 09, 2004 at 10:16:10PM -0700, Darren Duncan wrote: [30 lines] I suggest that the disconnect() function follow the same behaviour as DESTROY for how transactions are dealt with. Or in other words, any current transaction should *always* be rolled back when a database

Re: DBI Roadmap

2004-08-24 Thread Tim Bunce
On Tue, Aug 10, 2004 at 10:38:31AM -0700, Henri Asseily wrote: * The DBD::Multiplex driver is intended to enable a wide range of dynamic functionality including support for various high-availability and load-balancing scenarios. The old version has been used successfully but was limited.

Re: dbd_db_last_insert_id in 1.42

2004-08-23 Thread Tim Bunce
On Mon, Aug 23, 2004 at 11:54:04AM +0100, Matt Sergeant wrote: There was a change in prototype for dbd_db_last_insert_id in 1.43. How should DBD developers handle this change in their code? (last_insert_id was fairly broken until 1.43.) The simplest way is just to have the Makefile.PL check

Re: DBI Roadmap

2004-08-13 Thread Tim Bunce
On Tue, Aug 10, 2004 at 05:42:05PM +0200, H.Merijn Brand wrote: On Tue 10 Aug 2004 00:52, Tim Bunce [EMAIL PROTECTED] wrote: Comments welcome. =head1 DBI ROAD-MAP 9th August 2004 This document aims to provide a high level overview of the future direction of the DBI

DBI Roadmap

2004-08-09 Thread Tim Bunce
Comments welcome. =head1 DBI ROAD-MAP 9th August 2004 This document aims to provide a high level overview of the future direction of the DBI. It outlines the broad categories of changes, along with some rational, but does not go into implementation details and ignores many more minor planned

Re: UTF-8 flags (again)

2004-08-08 Thread Tim Bunce
On Sun, Aug 08, 2004 at 06:15:39PM +0100, Matt Sergeant wrote: On 8 Aug 2004, at 17:35, David Wheeler wrote: On Aug 8, 2004, at 9:14 AM, Matt Sergeant wrote: i.e. for every fetch call, you need to do: SvUTF8_off(AvARRAY(av)[i]); Now, people using your DBD can decide to upgrade the

Re: DBI 2.0 interface change request

2004-08-04 Thread Tim Bunce
On Tue, Aug 03, 2004 at 10:37:57AM +0100, Tim Bunce wrote: Meanwhile, now isn't the time to be getting into debates about such future details. Enough already, please. More heat than light is being generated. The DBI interface is not going to change significantly anytime soon. If anyone

Re: DBI 2.0 interface change request

2004-08-03 Thread Tim Bunce
On Mon, Aug 02, 2004 at 07:56:47PM -0400, John Siracusa wrote: Maybe this is DBI 3.0 I'm talking about, or maybe I'll forever be doomed to implement DBI wrapper after DBI wrapper, but I thought I'd give it a shot :) It is indeed DBI 3.0 that you're talking about. I'm thinking of DBI v3 as the

Re: ORA-12154

2004-08-03 Thread Tim Bunce
On Tue, Aug 03, 2004 at 04:06:17PM -0500, Scott T. Hildreth wrote: This should be on the dbi-users list. So anyone replying should edit the CC to only include [EMAIL PROTECTED] Thanks. Tim.

Re: notes from OSCON BoFs?

2004-08-02 Thread Tim Bunce
On Mon, Aug 02, 2004 at 12:32:47PM -0700, Henri Asseily wrote: I see that the new todo list says: Add $h-swap_internal_handle($other_h) I submitted a simple patch a few days ago for set_internal_handle(). Why would we swap instead of set? swap suggests that h becomes other_h and vice

Re: notes from OSCON BoFs?

2004-08-02 Thread Tim Bunce
On Mon, Aug 02, 2004 at 11:39:14AM -0700, Jeff Zucker wrote: Darren Duncan wrote: To whomever was at OSCON and attended the DBI Driver Developers BoF, I would appreciate it if some notes or a summary of goings-on at that event could be posted to this list. This would help people such as

Re: bug for DBD-Oracle-1.15/16

2004-07-27 Thread Tim Bunce
: () # # MakeMaker Parameters: # ABSTRACT_FROM = q[Oracle.pm] # AUTHOR = q[Tim Bunce ([EMAIL PROTECTED])] # DEFINE = q[ -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\9.2\] # DIR = [] # EXE_FILES = [q[ora_explain]] # INC = q[-I/oracle/product/9.2.0.5/rdbms/demo

Re: Replacing $sth

2004-07-27 Thread Tim Bunce
On Tue, Jul 27, 2004 at 02:13:03AM +0200, Jochen Wiedmann wrote: Henri Asseily wrote: I'm trying to do the following, and was wondering where I should look to get a good handle on what's going on: I have an $sth that's pointing to a dead server. I have a new $sth2 that's pointing to a

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Tim Bunce
On Mon, Jul 26, 2004 at 07:15:13AM +0100, Tim Bunce wrote: On Sun, Jul 25, 2004 at 01:31:51PM -0700, Dean Arnold wrote: caveat while not strictly a DBI issue, I'm going to kick this off here, since its pretty relevant (ala SQL::Statement). If I'm out of line, or should restrict

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-19 Thread Tim Bunce
On Thu, Jul 15, 2004 at 01:27:12PM +0100, Tim Bunce wrote: On Thu, Jul 15, 2004 at 10:35:14AM +0200, Steffen Goeldner wrote: FYI, t\30long produced a core dump, t\30long + trace: t\30longok 460/460DBI::db=HASH(0x1a748c4) trace level set to 0x0/9 (DBI @ 0x0/0) in DBI 1.43

ANNOUNCE: DBI Driver Developers BoF at OSCON

2004-07-16 Thread Tim Bunce
On Fri, Jul 16, 2004 at 11:26:44AM +0100, Tim Bunce wrote: I've arranged a BoF for DBI users at OSCON on Thursday evening (July 29) http://conferences.oreillynet.com/cs/os2004/view/e_sess/5783 And I've arranged a DBI Driver Developers BoF on the Tuesday from 6:30pm: http

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-15 Thread Tim Bunce
On Thu, Jul 15, 2004 at 10:35:14AM +0200, Steffen Goeldner wrote: Tim Bunce wrote: Warning W8075 dbdimp.c 82: Suspicious pointer conversion in function GetEnvOrRegKey Fixed. Warning W8075 dbdimp.c 94: Suspicious pointer conversion in function GetRegKey Not sure what that one is - I

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-15 Thread Tim Bunce
On Wed, Jul 14, 2004 at 01:08:55AM +0100, Tim Bunce wrote: A release candidate of DBD::Oracle 1.16 is available for testing at: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc1-20040713.tar.gz and now http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc4-20040715.tar.gz

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-15 Thread Tim Bunce
On Wed, Jul 14, 2004 at 09:59:40PM +0100, Tim Bunce wrote: t/30longDBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments: [122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line 317. Um, that's actually using

Re: Bulk-Loading routines in DBD::Sybase

2004-07-14 Thread Tim Bunce
On Wed, Jul 14, 2004 at 11:46:21AM +0200, Michael Peppler wrote: On Tue, 2004-07-13 at 17:04, Michael Peppler wrote: On Tue, 2004-07-13 at 16:46, Tim Bunce wrote: On Tue, Jul 13, 2004 at 03:26:13PM +0200, Michael Peppler wrote: Sample code: my $dbh = DBI-connect

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-14 Thread Tim Bunce
On Wed, Jul 14, 2004 at 01:08:55AM +0100, Tim Bunce wrote: A release candidate of DBD::Oracle 1.16 is available for testing at: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc1-20040713.tar.gz and now: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc2-20040714.tar.gz

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-14 Thread Tim Bunce
On Wed, Jul 14, 2004 at 01:48:33PM +0100, Tim Bunce wrote: On Wed, Jul 14, 2004 at 01:08:55AM +0100, Tim Bunce wrote: A release candidate of DBD::Oracle 1.16 is available for testing at: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc1-20040713.tar.gz and now: http

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-14 Thread Tim Bunce
On Wed, Jul 14, 2004 at 01:38:56PM -0500, Stephen Clouse wrote: Red Hat Enterprise Linux AS 3.0 Oracle 9.2.0.4 Building against current tip (r395), build throws lots of warnings that I'm much too lazy to investigate right now, but all tests pass. `make` log attached. Thanks. I've asked

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate for testing

2004-07-14 Thread Tim Bunce
On Wed, Jul 14, 2004 at 06:08:47PM +0200, Honza Pazdziora wrote: On Wed, Jul 14, 2004 at 03:02:24PM +0100, Tim Bunce wrote: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc3-20040714.tar.gz Hello Tim, Hello Honza. This is perl, v5.8.3 built for i386-linux-thread-multi

<    4   5   6   7   8   9   10   11   12   13   >