Re: possible leak in 1.52

2006-08-22 Thread Jonathan
it definitely seems to be a leak, and i've been able to reproduce it outside of mod_perl it seems that there are a few potential sources / behaviors a_ the statement handle created by a prepare never seems to expire in the lifetime of a db connection i could trace this a

Rows returned are out of sync with the request.

2006-08-22 Thread Stephen Carville
I'm not quite sure how to describe this problem. When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. For example, If I send the following: select a.statid, b.webstatdesc, a.pendid, c.penddesc, a.certno, t

Re: AutoCommit does not work

2006-08-22 Thread Artem Harutyunyan
Dear Mary, In MySQL your table must be of type INNOB for transactions to be supported. Thanks a lot ! I have change the database type and now the program works properly. Thanks to all. Artem.

Re: AutoCommit does not work

2006-08-22 Thread Artem Harutyunyan
On 8/22/06, Kevin Carothers <[EMAIL PROTECTED]> wrote: On 8/22/06, Artem Harutyunyan <[EMAIL PROTECTED]> wrote: > > Hi, > > > > > BEGIN TRANSACTION > > write a sales slip > > write a journal record > > > write a check record > > > COMMIT > > END TRANSACTION > > > > But what h

RE: Re: AutoCommit does not work

2006-08-22 Thread Garrett, Philip \(MAN-Corporate\)
Artem Harutyunyan wrote: > Hi, > > Are you using a table type in mysql that supports transactions? >> > Well, I am not sure, how can I check it ? mysql> show table status like '%transaction%'; The second column (engine) is what you're interested in... needs to be InnoDB to support transactions.

RE: AutoCommit does not work

2006-08-22 Thread Mary Anderson
>Artem Harutyunyan wrote: Hi, > > Consider, please, the following piece of code: > ___ __ > my $dbh = DBI->connect($dsn, $user, $pass, {RaiseError => > 1,PrintError =>1}); > > $dbh->{'AutoCommit'} = 0

Re: Re: AutoCommit does not work

2006-08-22 Thread Artem Harutyunyan
Hi, Are you using a table type in mysql that supports transactions? Well, I am not sure, how can I check it ? Artem.

RE: AutoCommit does not work

2006-08-22 Thread Garrett, Philip \(MAN-Corporate\)
Artem Harutyunyan wrote: > Hi, > > Consider, please, the following piece of code: [snip] > > It connects to the database, turns AutoCommit off, prepares the > statement, executes it, waits for 60 seconds and commits the > statement. > Although I do not get any errors, it does not work as I expe

Re: AutoCommit does not work

2006-08-22 Thread Kevin Carothers
On 8/22/06, Artem Harutyunyan <[EMAIL PROTECTED]> wrote: Hi, Consider, please, the following piece of code: {code fragment} It connects to the database, turns AutoCommit

AutoCommit does not work

2006-08-22 Thread Artem Harutyunyan
Hi, Consider, please, the following piece of code: _ my $dbh = DBI->connect($dsn, $user, $pass, {RaiseError => 1,PrintError =>1}); $dbh->{'AutoCommit'} = 0; my $sth = $dbh->prepare(q{INSERT INTO TRAN