I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good way of using them. I make an array with all
the query's I loop through them. like this mysql_query($qarray[$i])or
die($flag = false);. After the loop I do if($flag) commit; else rollback;
Is this a
gital
www.becomingdigital.com
- Original Message -
From: "Jonas Geiregat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 2003 13:44
Subject: transactions with php
I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good wa
l.com
- Original Message -
From: "Jonas Geiregat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 2003 13:44
Subject: transactions with php
I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good way of
ssage -
From: "Jonas Geiregat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 2003 13:44
Subject: transactions with php
I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good way of using them. I make
At 10:44 -0700 6/17/03, Jonas Geiregat wrote:
I'm trying to implement transaction (mysql) in my php code. Could
anyone tell me if this is a good way of using them. I make an array
with all the query's I loop through them. like this
mysql_query($qarray[$i])or die($flag = false);. After the loop I
18:44
Subject: INNODB Transactions
Hi :
I would like to know what happen if I start a transaction using BEGIN
command I do some insert or update statements, and just before executing a
ROLLBACK or COMMIT command I get disconnected and I can't execute those
commands.
For how long does the table
Hi :
I would like to know what happen if I start a transaction using BEGIN
command I do some insert or update statements, and just before executing a
ROLLBACK or COMMIT command I get disconnected and I can't execute those
commands.
For how long does the table remain locked, or in other words h
Carlos,
- Original Message -
From: ""Carlos Proal"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, June 08, 2003 2:14 PM
Subject: Re: start innodb without transactions
>
> Hi Heikki et al.
> I have solve my problem :). The fact
Hi Heikki et al.
I have solve my problem :). The fact about my missed table was my fault,
because indeed those tables doesnt exist anymore (one developer had deleted
them).
Even when my db is up and running im figuring out why there is not an option
to skip commit/rollback pending transactions
Carlos,
- Original Message -
From: ""Carlos Proal"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, June 06, 2003 4:04 AM
Subject: start innodb without transactions
>
> Hi all
> Is there any way to start mysql/innodb skipping tr
Hi all
Is there any way to start mysql/innodb skipping transactions ?, i had a
crash and i cant get the database to work.
i tried the force_recovery option level 3:
# 3 (SRV_FORCE_NO_TRX_UNDO) do not run transaction rollbacks after recovery;
this way i can get it to work, but as the manual said
ade to 4.0.13. Then do some heavy processing, for example, a
table import, and crash mysqld artificially by
killall -9 mysqld
Look then if InnoDB is able to scan the log in crash recovery.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup too
67744
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 119167355
030605 12:14:32 InnoDB: Assertion failure in thread 1 in file btr0cur.c
line 3350
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
mysql
hi guys , i am trying to sort out if the app i am about to build would require the use
of transactions, there may be a few users simultanously entering data, but possible
not updating the same data and maybe a lot of users accessing the data (search/select)
, will this require some form of
At 13:22 +0100 3/27/03, Stefan Hinz wrote:
Christian,
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this sho
Christian,
> It looks like 'drop table' implicitely does a 'commit', at least when
> issued by the mysql commandline utility with mysql 3.23.51. This
> happens even if it was a temporary heap table as typically used to
> emulate subselects.
> I think this should be documented. (Or better yet, n
Christian,
- Original Message -
From: "Christian Jaeger" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, March 27, 2003 1:42 PM
Subject: Innodb transactions and drop table
> Hello
>
> It looks like 'drop table' implicitely does
Hello
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this should be documented. (Or better yet, not do a commit
Hi.
On Sun 2003-03-09 at 11:34:33 -0500, [EMAIL PROTECTED] wrote:
> From what I understand, "transactions" are a kind of protection that
> prevents certain commands from executing if certain other conditions
> haven't been met.
Not completely. They can do much more.
From what I understand, "transactions" are a kind of protection that
prevents certain commands from executing if certain other conditions
haven't been met. And this is particularly important for ecommerce,
among other things. Do I more or less have that right?
My main question,
Does anyone know how to view uncommited transactions for a session?
This is more of a problem when using MySQL Manager when it asks whether
or not to commit the transaction list. Is there a definitive way to
know what queries have yet to be committed/rolled back
Raghu,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, March 05, 2003 7:03 AM
Subject: Peculiar Problem During Transactions
>
> Placed At : MAATDLN
>
> Hi,
>
Placed At : MAATDLN
Hi,
I have a database with a table that has 3 columns - name, age and status
and this table has 10 rows.
This table is an Innodb table with dyname table type (incase this is
important) and so I can conduct transactions
nobase Oy
sql query
...
Subject: Bug? InnoDB transactions and temporary table hanging
From: Samuel Liddicott
Date: Thu, 6 Feb 2003 10:57:13 -
I came accross a problem porting our tv listings system from postgres to
mysql with InnoDB.
With InnoDB tables, read-only transactions
I came accross a problem porting our tv listings system from postgres to
mysql with InnoDB.
With InnoDB tables, read-only transactions started after a read-write
transaction touching the same rows are able to read data as it was before
the read-write transaction began; UNLESS the "read
, what kind
of theoretical work is required to allow nested transactions?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php
Thad,
- Original Message -
From: "Thad Humphries" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, December 30, 2002 4:09 PM
Subject: nested transactions?
> Any word when/if MySQL might support nested transactions? I have a large
> Oracle ESQL
stly, the 'other' features of InnoDB
(transactions and reliability) aren't as important to me as overall speed.
Setup a test system and try it. I saw the benchmarks indicating a
speed improvement with innoDB and tried it within my system. My
longest query program took two times
l DuBois [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 10:26 AM
> To: Dana Diederich; [EMAIL PROTECTED]
> Subject: RE: transactions...
>
> At 9:40 -0500 9/23/02, Dana Diederich wrote:
> >Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch
&
res better when your query mix contains
many updates, rather than just a lot of selects. MyISAM tables use table-level
locking, which works well for a mix of selects, but degrades when you start
throwing updates into the mix.
> Honestly, the 'other' features of InnoDB
>(transaction
ve me
better overall performance in such a high contention environment. For
example, each update won't block other updates or selects or deletes.
Is this a fair assumption? Honestly, the 'other' features of InnoDB
(transactions and reliability) aren't as important to me as over
On Mon, 23 Sep 2002 08:40:59 +0300 (EEST) Iikka Meriläinen
<[EMAIL PROTECTED]> wrote:
> On Mon, 23 Sep 2002, Daniel Kiss wrote:
>
> > Hi!
> >
> > At 00:56 2002.09.23._ -0300, you wrote:
> > >Do I loose
> > >too much performance using InnoDB tables in autocommit mode instead of
> > >using MyISAM
On Mon, 23 Sep 2002, Daniel Kiss wrote:
> Hi!
>
> At 00:56 2002.09.23._ -0300, you wrote:
> >Do I loose
> >too much performance using InnoDB tables in autocommit mode instead of
> >using MyISAM tables?
>
> The real quiestion is: Why do you want to use InnoDB tables when you don't
> want to use it
Hi!
At 00:56 2002.09.23._ -0300, you wrote:
>Do I loose
>too much performance using InnoDB tables in autocommit mode instead of
>using MyISAM tables?
The real quiestion is: Why do you want to use InnoDB tables when you don't
want to use its transaction safe features?
Anyway yes. I'm sure it is
Joao,
> I think I've already asked this before, but I will try again. Do I loose
> too much performance using InnoDB tables in autocommit mode instead of
> using MyISAM tables?
Possibly, but "too much" is really relative on what your needs are. What
are you trying to achieve and what is more im
I think I've already asked this before, but I will try again. Do I loose
too much performance using InnoDB tables in autocommit mode instead of
using MyISAM tables?
Thanks.
Joao
sql
-
Before posting, please check:
http://www.
Anyone know of an email marketing software suite that works well with MySQL
on the
backend?
I've seen stuff that works with ODBC db connectivity but I'm not interested
in moving to MS SQL or Access.
Any feedback is appreciated
Thanks
Mark
-
, 2002 9:33 PM
To: Bob Boden
Cc: [EMAIL PROTECTED]
Subject: Re: Transactions not supported by database - Perl
Send the set autocommit=0 just as you send any other query in perl.
Bob Boden wrote:
>Attempts to disable auto-commit mode in Perl using the DBI command
>$dbh->{AutoCommit} = 0; re
Send the set autocommit=0 just as you send any other query in perl.
Bob Boden wrote:
>Attempts to disable auto-commit mode in Perl using the DBI command
>$dbh->{AutoCommit} = 0; returns the following message, "Transactions not
>supported by database".
>
>I am using
Attempts to disable auto-commit mode in Perl using the DBI command
$dbh->{AutoCommit} = 0; returns the following message, "Transactions not
supported by database".
I am using the latest version of MySQL-Max (3.23.51) as well as the latest
version of DBD::mysql.
Executing the foll
Hi, I'm developing a system which will use transactions with InnoDB.
In principle, when you use transactions, there is some risk that a
deadlock will happen and MySQL will abort the transaction. In this
situation, you should generally try to do the transaction again. I'm
Hi again,
I really think you should walk yourself through the InnoDB user manual at
http://www.innodb.com/ibman.html
There's a lot of usefull and explanory information in there.
For your question:
ib_arch and ib_logfileX are the logs that InnoDB uses to track
committed transaction
el.
Bert> To test wether your datasource supports the transactions, do a test and look
Bert> at the InnoDB-logfiles, it should
Bert> indicate some thing like SET AUTOCOMMIT=0 and COMMIT.
Ok, I determined that innodb wasn't being initialized because I didn't have
"
my experience, most of the detailed
transaction-handling
can only be done at mysql-query level.
To test wether your datasource supports the transactions, do a test and look
at the InnoDB-logfiles, it should
indicate some thing like SET AUTOCOMMIT=0 and COMMIT.
Greetz,
CB.
-Original Message
One thing that I find a little confusing is the notion of transactional
behavior in mySQL. I read that it's possible to enable transactions in
mySQL-max, however, it's never really been clear to me exactly what I'm
supposed to do, or whether I have to do anything. If I'm u
Thanks alot Cal.
-Steve.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 9:38 AM
To: Steve Bradwell; [EMAIL PROTECTED]
Subject: RE: Innodb and transactions
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('I
into it, it's a great piece of code)
HTH,
=C=
-Original Message-
From: Steve Bradwell [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 7:58 AM
To: [EMAIL PROTECTED]
Subject: Innodb and transactions
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to do begin rollback commit with
php and mysql Innodb tables?
Thanks for any and all help,
Steve.
-
Before posting, please check:
http://ww
Kiss Dániel; [EMAIL PROTECTED]
Asunto: Re: WinZeos and Transactions
It's easy to upgrade. I just did a search and replace in the .dfm files.
Fredrick
- Original Message -
From: "Informatica Handem" <[EMAIL PROTECTED]>
To: "Kiss Dániel" <[EMAIL PROTECT
It's easy to upgrade. I just did a search and replace in the .dfm files.
Fredrick
- Original Message -
From: "Informatica Handem" <[EMAIL PROTECTED]>
To: "Kiss Dániel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 3:
Thanks for your help Daniel.
I've tried transactions with ZeosDBO 5.3.0 beta6 and it worked well.
The problem is that I want not to change zeos component 3.0.3 to 5.3.0
because it changes some things (first changes the names of the components)
and I have to change the code of the applic
can find
it in the MySQL manual.
Bye,
niel
At 09:38 2002.06.04.s +0200, you wrote:
>Hi all.
>
>I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using
>InnoDB tables and I want to use transactions.
>
>I try to begin a transaction with BEGIN and SET
Hi all.
I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using
InnoDB tables and I want to use transactions.
I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work
I can see the rows inserted in the database
with another connection.
What is t
- Original Message -
From: "Luca Lafranchi" <[EMAIL PROTECTED]>
To: "Arul" <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 5:10 PM
Subject: Re: JDBC Transactions
> Hi Arul, this is not a direct answer to your question, only a note about
> foreig
Thanx Mark
But i am new to MySQL...
First of all i would like to know the basic difference between Inno DB and
My ISAM Table types..
I wanted mySQL to support AutoIncrement , Transactions,Foreign Key
Constraints,Blob, Text etc...so as per the documents i thought of using a
InnoDB Table
Arul wrote:
>Hi All,
>
>We are currently running a website which is running on Weblogic and Oracle
>DB.I just thought of porting it to JBoss and MySQL.
>
>Well..i am not sure how far does MySQL supports Transactions..
>I am currently using 3.23.49 Max on Win 2K.
>
>
Hi All,
We are currently running a website which is running on Weblogic and Oracle
DB.I just thought of porting it to JBoss and MySQL.
Well..i am not sure how far does MySQL supports Transactions..
I am currently using 3.23.49 Max on Win 2K.
Does this version of MySQL Supports transaction
First question: did you set autocommit=0?
--Walt Weaver
Bozeman, Montana
-Original Message-
From: a a [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: transactions on MySQL (innoDB)
Hello
I can't create innoDB tables in db MySQL
please let us know the SQL query you are trying, and a DESCRIBE TABLENAME so we can
see how your table(s) are laid out. also, please tell us what you actually changed
in your my.cnf file
by the way, before you can do transactions, you must set the AUTOCOMMIT variable to
0
-Ryan Hatch
a a
Hello
I can't create innoDB tables in db MySQL to do
rollback and commit
transactions.
I try to modify the my.cnf file with the instructions
that I find in manuel.pdf but it don't work.
Can you help me please ?
Thanks.
Ps :
Hello,
I had written last week because I tried to send a mail to
[EMAIL PROTECTED] about MySQL transactions without success.
[EMAIL PROTECTED] answered me, but I can't send a mail to him.
Using "set autocommit=0;" doesn't fix the problem...
My problem was :
We have
Dear all,
The message I enclose is dated almost a year back. I would greately
appreciate if you let me know if transaction support in MySQL has stabilised
in sub-sequent releases ? secondly, if one does use transactions by
converting to BDB of InnoDB what is the impact on indexing/ speed of
John,
Thursday, May 02, 2002, 3:17:59 PM, you wrote:
JN> I would greately appreciate if someone could advise me on which version of
JN> MySQL supports transactions ?
Transaction is supported with transaction-safe tables (InnoDB, BDB).
http://www.mysql.com/doc/T/a/Table_types.h
I would greately appreciate if someone could advise me on which version of
MySQL supports transactions ?
Thanks,
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi,
We are currently facing the same problem (Deadlock found when trying to
get lock; Try restarting transaction)
in our production environnement. We are using InnoDB tables (mysqk
3.23.48-max) with
Jboss 2.4.4 and JDBC driver mm.mysql-2.0.11-bin.jar / RedHat 7.1.
Could you please tell me how to f
Jeremy,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 9:37 AM
Subject: Re: InnoDB transactions with Connection Pooling
> On Mon, Apr 2
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote:
> Mark,
>
> if you do not explicitly do
>
> SET AUTOCOMMIT=0
>
> then MySQL automatically calls COMMIT after every SQL statement.
Make that:
SET AUTOCOMMIT=1
Heikki is probably low on coffee. :-)
Jeremy
--
Jeremy D. Zawodny, <
snapshot of the database in each consistent read.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
- Original Message -
From: "Mark Hazen&quo
maxim,
Wednesday, April 10, 2002, 1:27:30 PM, you wrote:
m> i've just started work with MySQL. Does anybody know how can i
m> use transaction with MySQL? Is this capability supported?
m> I write web-shop... Sory my eng is bed...
Yes, MySQL supports transactions on the transacti
Hello Dicky,
Wednesday, April 10, 2002, 1:42:00 PM, you wrote:
DWP> On Wed, 10 Apr 2002 13:27:30 +0300
DWP> maxim <[EMAIL PROTECTED]> wrote:
>> Hello ,
>>
>>
>>
>> i've just started work with MySQL. Does anybody know how can i
>> use transaction with MySQL? Is this capability supported?
>> I
m (BDB and InnoDB)
support transactions. Others (like MyISAM) do not.
Being new to MySQL is a good reason to study the manual. It's all there.
Cheers,
Thomas
-
Before posting, please check:
http://www.mysql.com/manual.php
On Wed, 10 Apr 2002 13:27:30 +0300
maxim <[EMAIL PROTECTED]> wrote:
> Hello ,
>
>
>
> i've just started work with MySQL. Does anybody know how can i
> use transaction with MySQL? Is this capability supported?
> I write web-shop... Sory my eng is bed...
>
what term do you mean with "transactio
Hello ,
i've just started work with MySQL. Does anybody know how can i
use transaction with MySQL? Is this capability supported?
I write web-shop... Sory my eng is bed...
--
Best regards,
maxim mailto:[EMAIL PROTECTED]
--
Rajeev,
please upgrade to 3.23.49a.
.37 is a very old version, and the current documents do not accurately
describe it.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from
ng the record i have used transaction for
SM> the connection object as follows:
SM> ..
SM> gcnMMLS.BeginTrans
SM> ..
SM> But the problem lies here...my application shows error
SM> as follows:(in my application i am trapping the error)
SM> ..
SM&
eremy Zawodny" <[EMAIL PROTECTED]>
To: "Rajeev Rumale" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 1:43 PM
Subject: Re: Supporting Transactions and Binary Logs
> On Wed, Apr 03, 2002 at 01:27:41PM +0800, Rajeev Rumale wrote:
&g
m trapping the error)
..
Error Number -2147467259
[TCX][MyODBC]Transactions are not enabled
..
What could be the problem???
Thanks.
Shankar
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
ht
no stored procedures yet. maybe vers 4.1
-Original Message-
From: Kevin D [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: transactions, referntial integrity
I've been reading the docs but I just want to verify. It seems lik
On Wed, Apr 03, 2002 at 01:58:55PM -0500, Kevin D wrote:
> I've been reading the docs but I just want to verify. It seems like
> the latest version of MySQL support transactions and referential
> integrity. Is this correct? Does MySQL now also support stored
> procedures?
BDB
I've been reading the docs but I just want to verify. It seems like the
latest version of MySQL support transactions and referential integrity. Is
this correct? Does MySQL now also support stored procedures?
Thanks,
I would like to know how work transactions!! are there is mysql 3.23.49??
If there is, how can I use transaction with rollback and commit? I read
about transaction, and exist other way to use. How can I use?
Regards
Alexander
Curitiba/Pr/Brazil
Has anyone had the following problem or anything related to this ?
I've had some problems where my data gets "deleted" after I add or drop a
column.
The scenario is as follows.
1)mysql daemon is running.
2)make a structure change to table/add or drop column
3)stop and restart mysql daemon
4)look
e_bdb| NO
> |
> | have_gemini | NO
> |
> | have_innodb | NO
> |
> | have_isam | YES
Looks like the only table types enabled are non-transactional. You
need to enable InnoDB or BDB (or Gemini, bu
ginal Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2002 00:17
> To: Greg Conway
> Cc: [EMAIL PROTECTED]
> Subject: Re: mysql lost it's ability to perform transactions?
>
>
> On Thu, Jan 31, 2002 at 12:06:52AM -, Greg Conway wrote:
w this as I use Zope to connect to MySQL, and it's now giving
> me the following error:
>
> Error Type: NotSupportedError
> Error Value: transactions not supported by this server
>
> If I change my connection string from +server.com to -server.com, it then
> kicks into l
or:
Error Type: NotSupportedError
Error Value: transactions not supported by this server
If I change my connection string from +server.com to -server.com, it then
kicks into life... but without transaction support!
I've located my new mysql_config, and checked it against the old one, but I
don
I am writing an application which requires FULLTEXT indexing capability,
and ACID transaction support would also be a plus. I am currently
developing on MySQL 4.0.1.
As I understand it, MyISAM tables support FULLTEXT indexing but do not
support ACID transactions. Also, InnoDB tables support ACID
(using $sth->{mysql_insert_id})
> > >now perform other inserts that need that key
> > >commit;};
> > >if($@){
> > >rollback;and other logic}
> > >the only problem is the {mysql_insert_id} doesn't give me an
> >now perform other inserts that need that key
> >commit;};
> >if($@){
> > rollback;and other logic}
> >the only problem is the {mysql_insert_id} doesn't give me anything back.
> >NADA...
> >Is this a bug
get the insert_id
>(using $sth->{mysql_insert_id})
>now perform other inserts that need that key
>commit;};
>if($@){
>rollback;and other logic}
>the only problem is the {mysql_insert_id} doesn't give me anything back.
>NADA...
perform other inserts that need that key
commit;
};
if($@)
{
rollback;
and other logic
}
the only problem is the {mysql_insert_id} doesn't give me anything back.
NADA...
Is this a bug only in transactions or innodb? since I know the function is
working in autocommit / M
nvironment and rethink my future database logics.
Some of those features will help a lot.
> Please allow me to clarify a few items here, since we don't want
> misunderstandings to linger around forever
>
> 1) MySQL supports transactions since 3.23.34a, with the InnoDB and BDB
s much worst than
those
> features above, which cannot be as easily worked around?
Please allow me to clarify a few items here, since we don't want
misunderstandings to linger around forever
1) MySQL supports transactions since 3.23.34a, with the InnoDB and BDB
table types.
Using the th
Can anyone help? I'm trying to implement a transaction (using InnoDB
tables ) in which
everything done in it can be rolled back at any stage. There are several
operations
involved and I need to be able to undo all the work done so far at any
point.
In my code below, I've deliberately set the vari
setting the transaction isolation to
>TRANSACTION_READ_UNCOMMITTED. This didn't help with MySQL/JDBC, though. I
>tried all isolation levels to no avail.
That suggests it produced deadlocks also on MS SQL
Server. Setting to 'read uncommitted' reduces locking
and prevents some deadlocks. But t
I lead three systems over the past two years using
VB/COM/ADO and Oracle and SQL Server without a single deadlock, even though
they all use a lot of transactions, this is not encouraging. I need to be
able to deliver quickly, yet I'm stuck on my first EJB because I insist on
using open sourc
Hi,
I'm working on a payment system that uses an e-wallet. I intend for the
system to provide payment services to other merchants on their sites as well
and I'm worried about scalability and correctly tracking transactions.
Incidentally, I'm very familiar with SQL Server gett
rds,
Heikki
http://www.innodb.com/ibman.html
>Has anyone encountered locking problems using JDBC with InnoDB tables and
>transactions? I am wondering if the MySQL JDBC was designed to handle
>transactions properly since InnoDB is a relatively recent addition to MySQL.
>The problem I am runn
Has anyone encountered locking problems using JDBC with InnoDB tables and
transactions? I am wondering if the MySQL JDBC was designed to handle
transactions properly since InnoDB is a relatively recent addition to MySQL.
The problem I am running into is the 100 locking error, as if the
Hi!
>Hi,I'm a beginner with MySql. Could anyone give me an example how transaction
>isolation works on InnoDB tables under Win2000? (If you have any examples
>I'll be happy). Thanks in advance.
>Adi
Below is pasted an example from the InnoDB
manual at http://www.innodb.com/ibman.html
When y
201 - 300 of 383 matches
Mail list logo