Martin,
Thanks for the info. Do you have a script that does this?
mysql_st_execute41 should be called if mysql supports prepared
statements, that is, >= SERVER_PREPARE_VERSION. I'm a bit suprised it
works, but I think I have code that catches it even if it doesn't
support prepared statements
Jie Zhang wrote:
Yeah, I mean the disconnect should not commit if autocommit is set to 0.
In most of the case, this is not a problem because people probably do
rollback and commit. Could you change oci code? Is it owned by Oracle?
From what I remember we did not make any change to OCI, we
Yeah, I mean the disconnect should not commit if autocommit is set to 0.
In most of the case, this is not a problem because people probably do
rollback and commit. Could you change oci code? Is it owned by Oracle?
thanks,
Jie
Martin J. Evans wrote:
Jie Zhang wrote:
Tom and Martin,
Th
Jie Zhang wrote:
Tom and Martin,
Thank you both!
It is a bit counter intuitive.
If by that you mean that you expected disconnect with a commit to
rollback the changes then I agree. We had an Oracle ODBC driver which
used oci which did this and ended up changing it to NOT commit on
disconnec
Tom and Martin,
Thank you both!
It is a bit counter intuitive.
Jie
Tom Schindl wrote:
Well I was already familiar with this behaviour because it's the same
with JDBC-Drivers.
Tom
Martin J. Evans wrote:
On 07-Apr-2006 Jie Zhang wrote:
Hi,
If I initiate a connection using autoc
On 2006-03-29 09:58:16 -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:
> > > Since mysql supports different charsets per table and even per column,
> > > I'd like an option to automatically convert them to and fr
Well I was already familiar with this behaviour because it's the same
with JDBC-Drivers.
Tom
Martin J. Evans wrote:
> On 07-Apr-2006 Jie Zhang wrote:
>
>>Hi,
>>
>>If I initiate a connection using autocommit=0 in DBI and I don't do a
>>explicit connection->commit(), should transactions automatic
man DBI:
---8<---
...
The transaction behaviour of the "disconnect" method is, sadly,
undefined. Some database systems (such as Oracle and Ingres) will
automatically commit any outstanding changes, but others (such as
Informix) will rollback any outstanding changes. Applic
On 07-Apr-2006 Jie Zhang wrote:
> Hi,
>
> If I initiate a connection using autocommit=0 in DBI and I don't do a
> explicit connection->commit(), should transactions automatically commit
> after I do an explicit connection->disconnect()? I was expecting an
> automatica rollback. But the testin
Hi,
If I initiate a connection using autocommit=0 in DBI and I don't do a
explicit connection->commit(), should transactions automatically commit
after I do an explicit connection->disconnect()? I was expecting an
automatica rollback. But the testing result is just the opposite.
For exampl
10 matches
Mail list logo