The general state of mySQL from when I last tried it was that transactions
are supported in the database if its compiled with the Berkeley DB
libraries, but somewhere in there it doesn't handle transactions in a
java-esque manner.
I'm guessing that its the JDBC driver (mm.mysql) since theres that driver
doesn't use anything from javax.transaction or javax.transaction.xa
packages.
The general guist of which is that mysql quite well works as long as you are
writing SQL yourself, but as soon as you try to do CMP EJBs you'll hit a
brick wall.
-----Original Message-----
From: Chris Callaghan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 2:55 PM
To: Orion-Interest
Subject: Re: Support for MySQL
The latest releases (as of 3.23.34a) of MySQL support transactions by
using Berkley DB.
I'm using MySQL at the moment. The main anoyance I've got is that it
doesn't have sub-selects, apart from that, works great.
I haven't tried using transactions though as my data is read only.
Ray Harrison wrote:
>Mysql doesn't support transactions (or the last time I checked it didn't) -
so it can be limited -
>but yes, orion interacts with the database just fine. I would suggest
another database to try
>would be SAP DB (www.sapdb.org) which is an open source database delivered
by SAP AG - I love it.
>There is a sap database schema in the orion download.
>
>
>
>--- Nicolai P Guba <[EMAIL PROTECTED]> wrote:
>
>>Hmmm, I've found that PostgreSQL is supported. Has anybody got any
>>success stories with mySQL? (still evaluating).
>>
>>--
>> Nicolai P Guba http://www.gnu.org http://www.frontwire.com
>> mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
>> GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
>>
>
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
>
>
