Berkeley tables (transactions) works for me. I am using RedHat 6.2. I
downloaded the sources and just unzipped/tar the Berkeley directly inside
the MySQL source directly. I then did .configure and I watched configure
tell me that it found the Berkeley directly and would use it.
I am still testing the transaction support in my code, but the limited tests
have shown that a transaction: BEGIN ... COMMIT, or BEGIN ... ROLLBACK
works.
Rick
-----------------------------------------
/ Rick Mehalick Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone: 281-544-5092(WCK)
/ Fax: 281-544-2646(WCK)
/ email: [EMAIL PROTECTED]
-----------------------------------------
-----Original Message-----
From: Marc Soda [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 2:30 PM
To: [EMAIL PROTECTED]
Subject: Transaction issues
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello all,
I am new to the list and need assistance. I noticed this thread in the
archives, but I didn't see an answer. So, I'll ask it again.
I have tried several times to use BerkeleyDB with MySQL to provide
transaction support. It has failed each time, both in my own tests and
through the mysql-test-run utility. It fails when attempting a rollback.
The actual rollback command returns with no error, but it doesn't 'undo'
anything. Thus, the test suite fails when attempting to insert the same
value that should have been undone. My company wishes to use MySQL for a
major web based application, unfortunately this hinges on transaction
support. I have fought hard to use MySQL for this, but if I can't get
this working it was all for nothing. I am using MySQL 3.23.33 (I have
tried this with 3.23.32 also) and BerkeleyDB 3.2.3h. Both of which I
downloaded from mysql.com. Also, I tried installing BDB compiled in with
MySQL and compiling separately, both failed. Anyone???
Thanks
- --
Marc Soda
ASPRE, Inc.
[EMAIL PROTECTED]
http://www.aspre.net/
Managed e-Business Application Services
- ---------------------------------
t. 215.957.2266 Ext. 2144
f. 215.957.2277
c.215.840.1633
113 Rock Road
Horsham, PA 19044
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE6iZlX8/oGPCGMSEgRAl02AJ9oQ94mAqtwb89ECqejtLYxL/HOGwCg3mNL
YVffTgj8c96KRZWQRfPyols=
=0eMJ
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
