RE: [dbi] Execute marks end of transaction?

2006-07-11 Thread Martin J. Evans
On 11-Jul-2006 Jimmy Li wrote: > Can I end a transaction as soon as I call execute()? Yes > or do I have to wait > until I finish fetching all the rows? No > For example, I have: > > -- > -

RE: memory leak in DBI XS bootstrap code

2006-07-11 Thread Ephraim Dan
Tim, I'm experiencing further memory leaks which are causing me more grief. I put together the following test script which illustrates the leakage: #/usr/bin/perl # dbi.pl use DBI; use Devel::Leak; my $leak_handle; for ( 1 .. 1000 ) { my $dbh = DBI->connect("DBI:mysql:MYDB","user","secret"

DBD:mysql installation problems

2006-07-11 Thread Whisky
Hello List! I've got quite some trouble installing DBD:mysqli (3.0006) on a Debian box running MySQL 5.0.22. It would be great if some of you had some idea on how to solve this. So here's what happens when I try doe build the package: --

RE: mysql installation problems

2006-07-11 Thread Ephraim Dan
You're overriding the cflags, so none of the mysql include directories are present. Try leaving off the --cflags argument, so that mysql_config can supply the cflags... > -Original Message- > From: Whisky [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 11, 2006 14:18 > To: 'mailing list

AW: mysql installation problems

2006-07-11 Thread Whisky
Thank you very much, Ephraim. That helped! Now I've got a new problem. DBD:mysql compiles but make test fails. Maybe you have an idea on this one, too. Once again, here's the complete output: SERVER:/usr/src/perl/DBD-mysql

RE: mysql installation problems

2006-07-11 Thread Ephraim Dan
You're not linking in some libraries, or your runtime LD path is not right, but I couldn't tell you why. A quick google showed me: http://archive.gingerall.cz/archives/public/sablot2003/msg00537.html Which looks reasonably relevant. You could try something like: perl Makefile.PL --mysql_config=

Re: memory leak in DBI XS bootstrap code

2006-07-11 Thread Tim Bunce
I'm sorry but I simply don't have the time at the moment. Some random suggestions: - try using different sets of methods to isolate the minimum requirements. for example: call fetchrow_array just once. don't call fetchrow_array at all. call fetchrow_array in loop but do

Re: [dbi] Execute marks end of transaction?

2006-07-11 Thread Jonathan Leffler
On 7/11/06, Martin J. Evans <[EMAIL PROTECTED]> wrote: On 11-Jul-2006 Jimmy Li wrote: > Can I end a transaction as soon as I call execute()? Yes Depends on the statement, of course, and the AutoCommit mode. For something other than a cursor-based statement (fetch, or sometimes some version

CURSOR WITH UPDATE

2006-07-11 Thread pDale
From looking around with Google, it would APPEAR that you can implement a cursor WITH UPDATE in DBI, but I have not been able to find an example of that. Would anyone happen to have a bare-bones code framework for such a thing? Since I should give an example of the kind of operation I hope to d

Re: CURSOR WITH UPDATE

2006-07-11 Thread Jonathan Leffler
$sth->{CursorName} is a key part of it. See also the docs for DBD::Informix (http://search.cpan.org/) for an example - the POD has a section CURSORS FOR UPDATE that shows how to do it. On 7/11/06, pDale <[EMAIL PROTECTED]> wrote: From looking around with Google, it would APPEAR that you can im

Re: Execute marks end of transaction?

2006-07-11 Thread Martin J. Evans
Jonathan, You are of course right. I read the word transaction but saw the select and missed the do to begin a transaction. My comments were based on a simple select outside a transaction. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com On Tue, 2006-07-11 at 09:18 -0700, Jona

Re: CURSOR WITH UPDATE

2006-07-11 Thread pDale
On 7/11/06, Jonathan Leffler <[EMAIL PROTECTED]> wrote: On 7/11/06, pDale <[EMAIL PROTECTED]> wrote: > From looking around with Google, it would APPEAR that you can > implement a cursor WITH UPDATE in DBI, but I have not been able to > find an example of that. Would anyone happen to have a bare

AW: mysql installation problems

2006-07-11 Thread Whisky
Thanks for your ideas, Ephraim. Although the article you mentioned didn't apply to the problem I finally found a solution. I just used the sources of MySQL 5.0.18 and now everything works fine. Maybe the command line I used is of some help for other people searching the archives... perl Makefile.