-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Loïc QUERAN wrote:
Hi,
What I want to do is to update a table in a database and at the same time post a message in a message queue. "At the same time" means in the same transaction : I must be able to commit both operations or rollback both operations.
As far as I know, what I need is a transaction manager that communicates with a message queue resource manager and a database resource manager, the communication protocol being XA (?).
My database is MySQL 3.23.x. I use InnoDB tables.
My message queue is SunOne Message Queue 3.0 platform edition, which supports XA.
The OS is Redhat 7.3. The development language is Java.
Does MySQL support XA ? The Connector/J driver has a package for this, but a few googled news indicate it does not really work. I also read articles about TYREX and JBOSS, but nothing is really convincing.
More generally speaking, how can I cope with my problem ?
Thanks in advance for any help.
MySQL does not support XA. Connector/J's XA support was a wrapper to provide XA semantics, but not functionality. Tyrex and JBOSS have similar wrappers as well, but any of them can leave you with heuristic failures because MySQL doesn't support XA.
XA is on the list of things that need to be done in the future, but it is not at the head of the list, because of other things like stored procedures, views and triggers must be done first due to market demand.
-Mark
- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.orgiD8DBQE+bI3+tvXNTca6JD8RAlNMAKCHvMMw6LIGcAnAJXRMDVHdRahw4ACgr/HD bKoHO0kyfasjFYW/tO23a8g= =NvGt -----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
