On Sat, Jan 28, 2006 at 09:48:17PM +0200, Marko Asplund wrote:
hi
I've been doing some more tests concerning this issue and it seems
that it only appears with the combination of Oracle Instant client
libraries, Perl configured with -Dusemymalloc on RHEL 3. When I
configure Perl
On Wed, Feb 01, 2006 at 02:08:32AM +0100, [EMAIL PROTECTED] wrote:
use backticks instead of double quotes:
my $sth=$dbh-prepare('select * from taskhours_per_date where `employee
name`=?');
That's not portable.
The DBI has a $dbh-quote_identifier method to abstract this and
On Wed, Feb 01, 2006 at 01:52:02PM +0200, Marko Asplund wrote:
On 2006-02-01, at 00.45, Tim Bunce wrote:
There are memory allocation debugging tools that may help to isolate
the original problem and so give some confidence that it's not present
in the other configurations.
I'am not really
On Tue, Jan 31, 2006 at 01:23:12PM -0800, Tyler MacDonald wrote:
Apache::DBI and DBI's connect_cached both claim to keep your database
handles fresh and happy, but I've had numerous problems trying to get either
of them to work properly. If a database connection is dropped, sometimes I'd
have
On Wed, Feb 01, 2006 at 02:06:22PM -0800, Tyler MacDonald wrote:
Perrin Harkins [EMAIL PROTECTED] wrote:
You have to expect certain basic things to work, and one of them is that a
connection which can't be ping'ed is not holding a table lock.
I completely disagree. Here's some more
On Thu, Feb 09, 2006 at 04:21:01PM -0800, Tyler MacDonald wrote:
However, this reveals a more sinister problem with the Makefile.PL
in DBI:
use Test::Harness; # tests use it so check it's loadable early
use Test::More 0.4; # tests use it so check it's loadable early
I'd
On Fri, Feb 10, 2006 at 02:50:11PM -0800, Bill Moseley wrote:
I'd like to see all of the prepared_cached() and execute() statements
when tracing. Currently that output is truncated.
How do I change where it truncates?
From memory it's $DBI::max_neatlen - but it is in the docs.
Were the
I think $h-trace($level, $filehandle) works now so I think you can
used a tied filehandle - certainly that's my intention.
Then the PRINT method of your tied filehandle class can do whatever you
want.
Tim.
On Fri, Feb 10, 2006 at 08:55:30PM -0800, Ben Tilly wrote:
Is there any easy way of
to it at some point but, as always, patches welcome!
Tim.
I just tried it on a machine at $VERSION 1.48 and it didn't work. :-(
(This with a filehandle pointing at a pipe, I was going to try a tied
filehandle if that worked.)
Thanks,
Ben
On 2/11/06, Tim Bunce [EMAIL PROTECTED] wrote:
I think
On Mon, Feb 13, 2006 at 10:30:46AM -0500, Robert Hicks wrote:
Tim Bunce wrote:
On Fri, Feb 10, 2006 at 02:50:11PM -0800, Bill Moseley wrote:
I'd like to see all of the prepared_cached() and execute() statements
when tracing. Currently that output is truncated.
How do I change where
On Tue, Feb 14, 2006 at 06:16:30PM -, Martin J. Evans wrote:
Regarding my posting with a problem using DBI 1.50 and DBD:mysql 3.0002_4
(reprinted below) I wonder if someone who knows DBI and DBD::mysql better
than I can point me in the right direction. I've discovered if I make a small
On Tue, Feb 21, 2006 at 10:17:44AM +0530, Hemlata Lalwani wrote:
Hi,
Which code do you want?Like the error says abt this path..
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Oracle.pm
So shall i give you the code of this?If not which code we want
..please tell
Isn't that the same as this?:
Changes in DBI 1.47 (svn rev 854), 2nd February 2005
Fixed DBI::ProxyServer to not create pid files by default.
References: Ubuntu Security Notice USN-70-1, CAN-2005-0077
Thanks to Javier Fernández-Sanguino Peña from the
Debian Security Audit Project,
On Mon, Mar 27, 2006 at 02:04:30PM +0100, Martin J. Evans wrote:
Hi,
I have my own error handler in which I'd like to log as much detail about the
error as possible. In this handler I do something like:
sub _error_handler {
my ($msg, $h, $method_ret) = @_;
my $dbh = $h;
$dbh
On Wed, Mar 29, 2006 at 10:53:56AM +0200, Peter J. Holzer wrote:
On 2006-01-31 01:24:18 +0100, Patrick Galbraith wrote:
I apologise for what might seem somewhat of a bit of neglect on my part to
get
some features into DBD::mysql, features such as UTF support, some bugs in
3.0002_4.
On Wed, Mar 29, 2006 at 11:54:32AM +0100, Martin J. Evans wrote:
The issue I am seeing is not quite as general as I made it sound. For
selectrow_hashref I see prepare/execute/fetch/fetchrow_hashref (as I expect)
but
for selectrow_arrayref and selectrow_array I only see prepare.
Generally...
On Wed, Mar 29, 2006 at 09:58:16AM -0800, Mark Hedges wrote:
On Wed, 29 Mar 2006, Tim Bunce wrote:
On Wed, Mar 29, 2006 at 10:53:56AM +0200, Peter J. Holzer wrote:
On 2006-01-31 01:24:18 +0100, Patrick Galbraith wrote:
I apologise for what might seem somewhat of a bit of neglect on my
into the implementation to
check for edge cases or other subtle issues.
b) is there an easy way to identify which other methods this could apply to
Nope. You'd have to use the above on all of them.
Tim.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 29-Mar-2006 Tim
On Wed, Mar 29, 2006 at 03:57:39PM +0100, Martin J. Evans wrote:
According to the docs for execute_array:
The mandatory ArrayTupleStatus attribute is used to specify a reference to
array which will receive the execute status of each executed parameter tuple.
It would appear in DBI 1.50 you
and I need it as light weight as I can make it because slowing it
down sometimes hides the problem.
Sounds interesting.
Tim.
Martin
Tim Bunce wrote:
On Wed, Mar 29, 2006 at 04:49:32PM +0100, Martin J. Evans wrote:
Tim,
Thanks, I do keep forgetting about Driver.xst.
So, just
- Forwarded message from Tomas Karlsson [EMAIL PROTECTED] -
Date: Wed, 12 Apr 2006 16:47:18 -0400
From: Tomas Karlsson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization: 10 East Corp.
To: [EMAIL PROTECTED]
Subject: suggestion for DBI
Hi Tim,
I would like to suggest a new
On Wed, Apr 12, 2006 at 04:33:39PM +0200, Dr.Ruud wrote:
Jeffrey Seger schreef:
perl -MData::Dumper -e' print Dumper @INC'
Alternative:
perl -MData::Dumper -e' print Data::Dumper-Dump([EMAIL PROTECTED],
[qw(*INC)])'
Alternative:
perl -V
Tim.
On Thu, Apr 13, 2006 at 03:22:19PM -0700, Loo, Peter # PHX wrote:
Hi,
I am passing the correct arguments to dump_results, but it appears that
the records are not getting separated with new line.
$maxlen = 500;
$lsep = '\n';
$fsep = '|';
$fh = \*FH;
$rows =
On Mon, Apr 10, 2006 at 03:14:21PM +0800, Allan Dyer wrote:
I've found that the problem with table_info has been reported three
times before in this group:
Here's how I call table_info(...). I have not used DBD::Proxy.
Who's maintaining DBD::Proxy? Perhaps I should contact them
On Thu, Apr 20, 2006 at 04:45:12PM +1000, Ron Savage wrote:
Hi Tim
Near the end of parse_dsn()'s write up, $driver_dsn should be $driver.
Um, I don't think so:
=item Cparse_dsn
($scheme, $driver, $attr_string, $attr_hash, $driver_dsn) =
DBI-parse_dsn($dsn)
or die Can't
Time to wind up this thread now guys.
Tim.
On Thu, Apr 27, 2006 at 06:36:09PM -0500, Jay Strauss wrote:
Hi,
Maybe this is old news to some, but the
FAQ link and support-details links (any of them) aren't working on
dbi.perl.org.
Ilya Sterin [CC'd] let me know recently he was back and able to take on
maintenance of the web site
On Fri, Apr 28, 2006 at 05:59:19PM +0100, Martin J. Evans wrote:
Tim,
Just a gentle reminder that I posted the attached patch to the POD for
ParamArrays (at your request) but I don't see it in subversion as yet
and I also mailed about a ParamArrays test being missing from around
line 1982
On Wed, May 10, 2006 at 09:11:29AM -0400, Mark Galbreath wrote:
Hi Guys,
I'm using a subclass of DBI called DBD::XBase for reading Oralce DBF
tablespace datafiles, translating them into delimited text files, and then
loading them into MySQL with DBI. The problem is the only way DBD:XBase
On Wed, May 10, 2006 at 09:26:52AM -0400, Mark Galbreath wrote:
Of course it's a string. It was a typo.
my $rows = $dbh-do(LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS
TERMINATED BY '|');
'db.table' == database_name.table_name
Don't put single quotes around the table name.
On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote:
I'm trying to load balance reads across two MySQL database that have
replication. The reads are working wonderfully. The inserts actually do
insert. However, there are some table that use auto increment primary keys.
I
On Thu, May 11, 2006 at 08:59:25AM -0400, Mark Galbreath wrote:
Tim,
I have preactically memorized the docs I have read them so many times. If
you have a better suggestion, I am wide open for it!
Something simple would do:
$sth = $dbh-prepare(...);
$sth-execute;
On Sun, May 14, 2006 at 02:05:32PM +0200, Rhesa Rozendaal wrote:
Hi all,
We've just setup MySQL replication, using the example from the
DBD::Multiplex
pod to connect to the master and slaves. This works beautifully: writes go
to
the master, and reads go to the slaves.
But now I'm
- Forwarded message from Joe McTigue [EMAIL PROTECTED] -
Subject: Just a quick question on the DBI perl mod
Date: Wed, 17 May 2006 14:22:38 -0400
From: Joe McTigue [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
X-Virus-Checked: Checked
Hi Tim,
I am currently getting the following error
On Fri, May 19, 2006 at 07:24:13PM +0100, Martin J. Evans wrote:
but I'm doing a select * from table and getting back a true value
which is 1. I thought for a successful select, execute would return
0E0 (which is true) but not 1. I was hoping to use true but not
0E0 to identify a non-select
- Forwarded message from Joe McTigue [EMAIL PROTECTED] -
Subject: Just a quick question on the DBI perl mod
Date: Wed, 17 May 2006 14:22:38 -0400
From: Joe McTigue [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
X-Virus-Checked: Checked
Hi Tim,
I am currently getting the following error
-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 11, 2006 7:44 AM
To: Peter Halliday
Cc: dbi-users@perl.org
Subject: Re: Problem with DBI::Multiplex
On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote:
I'm trying to load balance reads across two MySQL
(In addition to Clive's comments.)
On Fri, May 26, 2006 at 09:28:37AM -0700, Loo, Peter # PHX wrote:
The problem I am having is, when I execute INSERT INTO real_table
SELECT * FROM ex_table before I start writing to the named pipe, this
process immediately stops because there is no data to
It is, as google would agree. Fixed in the next release.
Tim.
On Tue, May 30, 2006 at 01:21:23PM +0200, ROBe Systemprogrammierung wrote:
Hi
I just installed DBI-1.50. The only problem I had is the following test:
not ok 60
# Test 60 got: '25 0.93 0.11 1e-02 0.23 102311 1023110010'
Please post a *small but complete* example that demonstrates the problem.
Tim.
On Tue, May 30, 2006 at 09:19:25PM -0700, Don Mies wrote:
I'm running the Perl DBI module with MySQL under cygwin on a Windows XP
system
and I'm having trouble using the DBI error handling/trapping procedures.
On Wed, May 31, 2006 at 08:57:23PM -0700, Don Mies wrote:
Tim, et. al. Following is a small sample program that demonstrates my
problem:
my $stmtHandle = $dbHandle-prepare ( $insert );
$dbHandle-{AutoCommit} = 0;
$dbHandle-{PrintError} = 0;
$dbHandle-{RaiseError} = 1;
On Mon, Jun 05, 2006 at 07:51:22PM -0700, David Brewer wrote:
OK, I have pared my problem down to a small test script and I've cut
away a lot of the modules I'm using that don't seem to be part of the
issue. The test script is included at the end of this message.
Thanks.
This small script
;
leak_test {
for (1..50) {
my $dbd = DBI-connect($dsn, $options);
$dbd-disconnect();
undef($dbd);
}
};
###
On 6/6/06, Tim Bunce [EMAIL PROTECTED] wrote:
On Mon, Jun 05, 2006 at 07:51:22PM -0700, David Brewer wrote:
OK, I
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.51.tar.gz
size: 415205 bytes
md5: d2ecc92395c4ab8221bac2866afbae04
=head2 Changes in DBI 1.51 (svn rev 6475), 6th June 2006
Fixed $dbh-clone method 'signature' thanks to Jeffrey Klein.
Fixed default ping() method to return false if
At this point I'm pretty sure it's a bug in DBD::ODBC, so I'll let
Jeff Urlwin pick up from here.
Tim.
On Wed, Jun 07, 2006 at 11:52:15AM -0700, David Brewer wrote:
I'm still not able to replicate on mysql. However, I have created a
test script (included below) which, given access to an empty
On Mon, Jun 12, 2006 at 03:24:55PM +0100, Martin J. Evans wrote:
Hi,
DBI documentation says execute on a an active statement should imply a finish
call but DBD::DB2 does no appear to do this - see example below.
This issue is now causing me a severe amount of grief as we have no finish
Hello Ron. Just a couple of minor comments on your example code...
On Sun, Jun 18, 2006 at 10:31:01AM +1000, Ron Savage wrote:
$sth_1 = $dbh_1 - prepare('insert into t(i) values (?)');
$sth_1 - execute($_) for (1 .. 5);
$sth_1 - finish();
FYI the call to finish() isn't needed here (or in
On Sat, Jun 17, 2006 at 03:43:44PM -0500, Erik Paulson wrote:
Hello -
fetchrow_arrayref has a big warning that you need to copy the data
in the array before using it, because the next call to fetchrow_arrayref
will reuse the array.
Does fetchall_arrayref have similiar limitations, and if
I think a similar issue came up a few months ago.
It turns out that the *::dr::connect method is not called.
There's a comment in t/30subclass.t that says:
# the MyDBI::dr::connect method is NOT called!
# you can either override MyDBI::connect()
# or use MyDBI::db::connected()
but
is not being called and I
need to create a DBIx::Log4perl::db::connected method and call
DBD::Oracle::dr::connect in it and if so how?
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 20-Jun-2006 Tim Bunce wrote:
I think a similar issue came up a few months ago
On Fri, Jun 23, 2006 at 08:45:20AM -0700, Brad Kroeger wrote:
Hello,
I'm having problems building DBD 1.51 on Solaris 9. I have not found
anything in google that has helped with with this problem, aside from
that I should be using a compiler that was built on Solaris 9.
I needed a 64
On Tue, Jun 27, 2006 at 04:37:24PM +0100, Martin J. Evans wrote:
Hi,
I am trying to locate the parameter values passed to a do method call in an
error handler called when the do method fails.
The error handler is called with a db handle and what follows is all I can
currently find out:
Try building perl with options to make valgrind leak tracing more
effective (see perl's INSTALL file). That may help you pinpoint
the problem.
Tim.
On Thu, Jun 29, 2006 at 04:33:40AM -0700, Ephraim Dan wrote:
I am experiencing what I believe to be a memory leak in the DBI bootstrap
code.
...
-edan
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 14:47
To: Ephraim Dan
Cc: dbi-users@perl.org
Subject: Re: memory leak in DBI XS bootstrap code
Try building perl with options to make valgrind leak tracing more
effective
so far, Tim.
I've taken a look at the code. I'd guess that it's due to savepnv:
ima-usage_msg = savepv( (svp) ? SvPV(*svp,lna) : );
But
Tim.
-edan
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 14:47
To: Ephraim Dan
Cc
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Fri 6/30/2006 11:35
To: Ephraim Dan
Cc: Tim Bunce; dbi-users@perl.org
Subject: Re: memory leak in DBI XS bootstrap code
On Fri, Jun 30, 2006 at 12:24:33AM -0700, Ephraim Dan wrote:
I don't see what you mean
On Tue, Jul 04, 2006 at 02:18:33PM +0100, Martin J. Evans wrote:
Thanks for the explanation. You have not however convinced me this behavior is
right. If RaiseError caused a die on error and someone wanted to ignore errors
they could just do what they always do - turn RaiseError off and do
On Wed, Jul 05, 2006 at 01:38:04PM +0100, Martin J. Evans wrote:
Tim,
Thanks for the clarification and untested patch. I've tried it and it now
fails (returns undef) and the HandleError routine is called. The error I'm
getting now is:
executing ARRAY(0x8ce4c08) generated 1
D'oh. Thanks.
scared of the
DBI.xs internals, despite my recent exposure...
Thanks a lot,
edan
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Monday, July 03, 2006 12:16
To: Ephraim Dan
Cc: Tim Bunce; dbi-users@perl.org
Subject: Re: memory leak in DBI XS bootstrap code
Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 16:59
To: Ephraim Dan
Cc: Tim Bunce; dbi-users@perl.org
Subject: Re: memory leak in DBI XS bootstrap code
I'm sorry but I simply don't have the time at the moment.
Some random suggestions:
- try using different sets
more about the cause.
or explain to me what I can do to make the
leak go away using the current code?
I need more info - see above.
Tim.
Thanks so much,
edan
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 16:59
To: Ephraim
On Wed, Jul 12, 2006 at 10:44:38PM -0700, Ephraim Dan wrote:
Did you try the other suggestions?
How much improvement did each give? (when testing by destroying the
interpreter)
Yeah, sorry I didn't give more detail on that. Here goes:
The first change (Doru Petrescu):
No change,
On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-Corporate) wrote:
Paul Griffin wrote:
I'm running Win XP with Perl 5.8.8.
If I try and run the following code :
use DBI;
my %drivers = DBI-installed_drivers();
foreach (keys( %drivers)) {
print $_ uses
- Forwarded message from Gene Zhang [EMAIL PROTECTED] -
Date: Wed, 19 Jul 2006 14:47:53 -0700
From: Gene Zhang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: dbh handle in forked processes
DKIM-Signature: a=rsa-sha1; q=dns; l=618; t=1153345674; x=1154209674;
c=relaxed/simple;
- Forwarded message from Oscar Gomez [EMAIL PROTECTED] -
X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no PTR record,
or PTR and A records do not match
From: Oscar Gomez [EMAIL PROTECTED]
To: Tim Bunce [EMAIL PROTECTED]
Subject: dbd-oracle-1.16
Date: Wed, 19 Jul 2006 16
Without support from the driver and underlying database client library,
timeouts using alarm signals may leave the driver and/or underlying
database client library in an inconsistent state.
Always disconnecting after a timeout may help, but isn't guaranteed.
Tim.
On Mon, Jul 24, 2006 at
On Wed, Jul 26, 2006 at 09:51:02AM +0100, Martin J. Evans wrote:
On 25-Jul-2006 Tim Bunce wrote:
Use DBI::Profile to see where the time is being spent.
I am looking into this.
My first attempt at setting DBI_PROFILE=2 and running my script returned with:
DBI::Profile on_destroy
On Wed, Jul 26, 2006 at 10:43:34AM +0100, Martin J. Evans wrote:
On 25-Jul-2006 Tim Bunce wrote:
Use DBI::Profile to see where the time is being spent.
I got this working and could not see anything taking longer. However, on
further investigation of my logs I have found the reason why
On Fri, Jul 28, 2006 at 03:46:20PM +0100, Martin J. Evans wrote:
On 27-Jul-2006 Tim Bunce wrote:
On Wed, Jul 26, 2006 at 10:43:34AM +0100, Martin J. Evans wrote:
On 25-Jul-2006 Tim Bunce wrote:
Use DBI::Profile to see where the time is being spent.
I got this working and could
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.52.tar.gz
size: 419674 bytes
md5: 57208ef6dccb3e72cf2df665983ce313
file: $CPAN/authors/id/T/TI/TIMB/DBI_WhatsNewTalk_200607.pdf
size: 313734 bytes
md5: 8168b9d931e5288b614461a7b53b8360
=head2 Changes in DBI 1.52 (svn rev 6734), 30h July 2006
On Thu, Aug 10, 2006 at 11:04:29AM -0400, Garrett, Philip (MAN-Corporate) wrote:
Is there a reason I would want to use execute_array() with
ArrayTupleFetch instead of execute_for_fetch()?
Probably not. Just use what comes most naturally for your code, which is
typically execute_for_fetch().
- Forwarded message from Narendran via RT [EMAIL PROTECTED] -
Subject: [perl #40244] req:regarding support for BerkeleyDB
From: Narendran via RT [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
RT-Ticket: perl #40244
RT-Originator: [EMAIL PROTECTED]
To: AdminCc of perl Ticket #40244: ;
On Thu, Aug 24, 2006 at 09:47:56AM +0200, Henri Asseily wrote:
Is the below the correct usage for finishing still active child
handles of a dbh?
foreach my $childh (@{$dbh-{ChildHandles}}) {
$childh-finish() if ($childh-{Type} eq 'st');
}
The children of a dbh will always be sth,
On Wed, Aug 09, 2006 at 10:01:06AM -0400, Matthew Persico wrote:
http://www.cpan.org/modules/by-authors/id/TIMB/DBI_WhatsNewTalk_200607.pdf
Very nit picky, but is there a version of this that I can print
without killing all the black ink in my printer?
I've updated it with a plain one (as
On Fri, Sep 01, 2006 at 04:45:07PM -, Eriam Schaffter wrote:
my software crashes badly due to the fact that DBD::ODBC has not a
last_insert_rowid method:
It's called last_insert_id
Tim.
On Fri, Sep 01, 2006 at 01:06:54PM +0100, John Gallagher wrote:
Hi
I've encountered the below error when running a make for the DBI module;
Make runs up to a certain point but then just bombs with the below message
Perl.c: In function `XS_DBD__Perl__st_DESTROY':
Perl.c:1054: warning:
Did t/72childhandles also fail, or was it
only t/zvpp_72childhandles?
Both t/72childhandles.t and lib/DBI/PurePerl.pm use the same code to
decide if there's a working Scalar::Util::weaken() available:
my $HAS_WEAKEN = eval {
require Scalar::Util;
# this will
On Mon, Sep 04, 2006 at 09:43:11AM +0100, John Gallagher wrote:
Hi Tim,
I've just run make again and included the output
The system I'm trying to install DBI on is a hp-ux 11.11
And the version of perl installed is 5.8.7
cc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT
is correct?
(We've got Scalar::Util 1.13 - looking at the change log for this hints
that weaken hasn't changed in the later versions - should I try 1.18
anyway?)
cheers,
clive
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: Clive George [EMAIL PROTECTED]
Cc: dbi-users
On Mon, Sep 04, 2006 at 09:36:30AM +0100, John Escott wrote:
The problems start when I try to set '$dbh-{AutoCommit} =0' (or call
$dbh-begin_work' ) for the SECOND time (after the first call to
'$dbh-commit'). The error says that AutoCommit is not supported by my
driver.
I've been
file: $CPAN/authors/id/T/TI/TIMB/DBI_AdvancedTalk_200608.pdf
size: 486540 bytes
md5: c305fe9ae393a534f17efc83a4563d28
Slides for this years version of my Advanced DBI tutorial are available online.
Tim.
On Mon, Sep 04, 2006 at 05:21:17PM +0100, Martin J. Evans wrote:
It did raise an issue where I could do with some clarification. The slides
say:
Execute a statement for multiple values
$sth = $dbh-prepare(insert into table (foo,bar) values (?,?));
$tuples =
On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote:
I'll report the problems just as soon as I'm certain what they are. Here is
my summary:
1. insert into table values (?,?) where all values are valid and 3 rows of
values
returns: 3
(correct as 3 tuples
On Tue, Sep 05, 2006 at 02:10:24PM +0100, Martin J. Evans wrote:
The DBIs default behaviour is the official behaviour.
That is fair enough. I wasn't really suggesting it was changed, it was more of
a pointing out the inconvenience in case it led to a better way for me to get
the rows
On Tue, Sep 05, 2006 at 09:13:04PM +0100, Martin J. Evans wrote:
On Tue, 2006-09-05 at 20:36 +0100, Tim Bunce wrote:
@@ -1921,10 +1921,12 @@
# start with empty status array
($tuple_status) ? @$tuple_status = () : $tuple_status = [];
+ my $rc_total = 0
It would be simpler to
$h-{PrintWarn} = 0;
at the right spot. (Perhaps in a block and using local.)
Tim.
On Wed, Sep 06, 2006 at 10:13:15AM -0400, Garrett, Philip (MAN-Corporate) wrote:
John Scoles wrote:
t/26exe_array...DBD::Oracle::st execute_array warning:
ORA-24381:
- Forwarded message from srilata devineni [EMAIL PROTECTED] -
Date: Tue, 12 Sep 2006 14:18:21 +0530
From: srilata devineni [EMAIL PROTECTED]
To: [EMAIL PROTECTED], Anupama [EMAIL PROTECTED]
Subject: plzzz help me out
HI, CAN ANY ONE HELP ME
ACTUALLY i'm new tp perl
I installed
On Sat, Sep 16, 2006 at 08:31:54PM -0400, Sam Tregar wrote:
On Sat, 16 Sep 2006, Dean Arnold wrote:
I think your best bet might be to work with the DBD::mysql maintainers
to implement some driver-specific nonblocking versions of
execute/prepare (and maybe fetch), as well as support for
'out
On Tue, Sep 05, 2006 at 06:28:37PM -0700, [EMAIL PROTECTED] wrote:
Hi, I'm having troubles trying to upgrade the DBI module in Perl. When I
do the following (as root):
/usr/bin/perl -MCPAN -e 'install DBI'
it downloads the new module, builds everything, and then starts running
the make
On Sun, Sep 17, 2006 at 10:59:48AM -0700, Dean Arnold wrote:
(I've added dbi-dev as this seems relevant)
Tim Bunce wrote:
On Sat, Sep 16, 2006 at 08:31:54PM -0400, Sam Tregar wrote:
On Sat, 16 Sep 2006, Dean Arnold wrote:
I think your best bet might be to work with the DBD::mysql
On Mon, Sep 18, 2006 at 05:05:52PM -0400, Sam Tregar wrote:
On Mon, 18 Sep 2006, Sam Tregar wrote:
On Mon, 18 Sep 2006, Sam Tregar wrote:
Looks like it turns PrintError off, huh? Actually, as far as I can
tell it turns it on. The relevent C code is (from dbih_set_attr_k):
else if
On Mon, Sep 18, 2006 at 10:30:49PM -0400, Sam Tregar wrote:
On Mon, 18 Sep 2006, Tim Bunce wrote:
Yes, and the same applies to AutoCommit. Whether it's a good thing or
not is debatable but it's been that way forever. The 'workaround' is
to explicitly state the attributes you want.
Hmmm
On Tue, Sep 19, 2006 at 02:47:18PM +0100, Martin J. Evans wrote:
Hi,
Back in March this year Jonathan Gillespie reported the following
error in DBD::ODBC test suite:
Can't change param 1 maxlen (51-50) after first bind at
t/20SqlServer.t line 180.
(see
On Fri, Sep 22, 2006 at 01:37:42PM -0700, Philip M. Gollucci wrote:
Hi,
I've a several 100 thousand line application. I did not introduce this
issue, but I need to fix it.
prepare_cached(SELECT foo FROM A where X = ?)
statement handle MyDBI::st=HASH(0xd630194) was still active at X.pm
Perhaps http://www.connectionstrings.com/ can help.
Tim.
On Mon, Oct 02, 2006 at 12:59:48PM +0100, Martin J. Evans wrote:
Hi,
I'm using DB2 8.2 on Linux and have downloaded and installed the DB2 ODBC
driver which is installed under unxiODBC. I have defined a data source to
connect to the
On Wed, Oct 04, 2006 at 11:53:48AM -0700, Henri Asseily wrote:
I have an issue with proper usage of swap_inner_handle:
Say I have a dbh with an active sth.
I create a new dbh (new_dbh) and swap its inner handle with dbh.
Now is sth a child of dbh or new_dbh? i.e., is sth linked to the
On Thu, Oct 05, 2006 at 12:21:17PM -0700, Henri Asseily wrote:
On Oct 5, 2006, at 6:19 AM, Tim Bunce wrote:
Say I have a dbh with an active sth.
I create a new dbh (new_dbh) and swap its inner handle with dbh.
Now is sth a child of dbh or new_dbh? i.e., is sth linked to the
inner dbh
On Mon, Oct 09, 2006 at 04:49:12PM +0300, Eugene Krivdyuk wrote:
Hi all.
I'm having trouble with stored pl/sql function which returns ref cursor.
This stored proc runs for 6 minutes while SQL itself executed for 6
seconds when executed outside pl/sql function.
Possibly due to a bug where
Thanks Steve. Applied.
I hope to make a new DBI release within a few days.
Tim.
On Mon, Oct 23, 2006 at 09:10:38AM -0500, Steve Peters wrote:
On Sat, Oct 14, 2006 at 08:40:14AM +0200, Andreas J. Koenig wrote:
On Fri, 13 Oct 2006 17:00:46 +0200, demerphq [EMAIL PROTECTED] said:
Are
Reread the mysql docs on InnoDB transaction isolation.
Then you'll see why a commit works. You could also change the default
isolation level of your session.
Tim.
On Mon, Oct 30, 2006 at 09:42:52AM -, [EMAIL PROTECTED] wrote:
Linux, mysql 4.1.14, DBI 1.38, DBD mysql 2.9002
Lo,
This
901 - 1000 of 2336 matches
Mail list logo