Re: Transactions in MySQL.

2006-09-28 Thread Visolve DB Team
ViSolve DB Team - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, September 25, 2006 11:42 AM Subject: Transactions in MySQL. Hi All, How transactions and locking are handled in MYSQL? Is it a part of configuration? Or a query (lock tables, Unlock table

Re: Transactions in MySQL.

2006-09-25 Thread Carlos Proal
It only works with engines that support transactions like innodb and solid, i strongly sugget to read these links from the manual. http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html Carlos On 9/25/06, [EMAIL

Transactions in MySQL.

2006-09-24 Thread ravi.karatagi
Hi All, How transactions and locking are handled in MYSQL? Is it a part of configuration? Or a query (lock tables, Unlock tables) for each set of queries? Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended

RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?

2002-07-01 Thread Bert VdB
2 23:14 To: [EMAIL PROTECTED] Subject: Re: high level: enabling transactions in mysql-max with WebLogic TX datasource? >>>>> "Bert" == Bert VdB <[EMAIL PROTECTED]> writes: Bert> Hi, Bert> all you have to do use a transaction enabled data-source and use

Re: high level: enabling transactions in mysql-max with WebLogic TX datasource?

2002-07-01 Thread David M. Karr
> "Bert" == Bert VdB <[EMAIL PROTECTED]> writes: Bert> Hi, Bert> all you have to do use a transaction enabled data-source and use the Bert> Mm-MysqlDriver Bert> for your JDBC connections. (http://mmmysql.sourceforge.net/) Bert> Best is to read the InnoDB documentation car

RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?

2002-07-01 Thread Bert VdB
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 22:33 To: [EMAIL PROTECTED] Subject: high level: enabling transactions in mysql-max with WebLogic TX datasource? One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that

high level: enabling transactions in mysql-max with WebLogic TX datasource?

2002-06-30 Thread David M. Karr
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

Re: Transactions in MySql

2001-04-10 Thread Gerald Clark
IL PROTECTED]] > Sent: Monday, April 09, 2001 6:19 AM > To: Marco Baldacchini > Cc: [EMAIL PROTECTED] > Subject: Re: Transactions in MySql > > Marco Baldacchini wrote: > > > > MySql support transactions? > > The OLE-DB provider support transactions? > > Call

RE: Transactions in MySql

2001-04-09 Thread Shankar Unni
ni Cc: [EMAIL PROTECTED] Subject: Re: Transactions in MySql Marco Baldacchini wrote: > > MySql support transactions? > The OLE-DB provider support transactions? > Call the method Begintrans on a connection object (ADO) return an error!!! And you read the manual, right? Transactio

Re: Transactions in MySql

2001-04-09 Thread Rodney J. Woodruff
Look at the following pages in the manual: http://www.mysql.com/doc/M/i/Missing_Transactions.html http://www.mysql.com/doc/T/a/Table_types.html -- Rodney Gerald Clark wrote: > Marco Baldacchini wrote: > > > > MySql support transactions? > > The OLE-DB provider support transactions? > > Call th

Re: Transactions in MySql

2001-04-09 Thread Gerald Clark
Marco Baldacchini wrote: > > MySql support transactions? > The OLE-DB provider support transactions? > Call the method Begintrans on a connection object (ADO) return an error!!! And you read the manual, right? Transaction support depends on the version of MySQL you are running, and the table ty

Transactions in MySql

2001-04-07 Thread Marco Baldacchini
MySql support transactions? The OLE-DB provider support transactions? Call the method Begintrans on a connection object (ADO) return an error!!!