> Date: Sun, 12 May 2002 17:00:01 +0500
> Message-Id: <[EMAIL PROTECTED]>
>From: "" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Entity Beans(CMP) in mysql
>Mime-Version: 1.0
>Content-type: text/plain; charset=us-ascii
>hi,
> Can any body tell me that EJBs specially Entity beans(CMP) can be
> implemented by MySQL with the constraint that >MySQL does not
> support distributed transaction or not.
Is there really a reason that you need distributed transactions, or do you
just need CMP? If your issue is the latter, then there is no worry as CMP is
in no way related to distributed transactions.
CMP and MySQL work fine, as long as you have a non-ancient version of the
MM.MySQL JDBC driver. I would suggest version 2.0.13, as it is known to work
with JBoss, WebLogic, Borland AppServer, etc. (it doesn't do CMP for
WebSphere, but you can only use Oracle, SQLServer, DB2 or Sybase for
WebSphere).
If you want true transactional semantics, then you want to be using a
version of MySQL that has InnoDB table types, and you want your tables to be
the InnoDB type.
I have yet to be on a project engagement where someone was using XA
(distributed transactions) and EJBs. If you really, truly need that
functionality, then you will either need to wait for MySQL to have XA,
sponsor XA in MySQL, or spends 10's of thousands of dollars on a database
that already supports XA natively.
-Mark
---------------------------------------------------------------------
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
