Actually MySQL does support transactions. You just need to use a database
file format that supports transactions (e.g. Berkeley DB, et al). The
mm.mysql driver also supports transactions, and its easy to setup to work
with transactions. The real problem is that the driver doesn't handle
transactions the way the specification wants them to.
-----Original Message-----
From: Kiss Tibor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:31 AM
To: Orion-Interest
Subject: RE: orion with mysql?
The cause for that could be that MySQL does not support transactions...
> -----Original Message-----
> From: Aaron Tavistock [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 3:28 AM
> To: Orion-Interest
> Subject: RE: orion with mysql?
>
>
> You only need a schema if you intend to do CMP EJBs. If
> you're not using
> EJB at all then theres no reason you couldn't use MySQL.
>
> But, while its not to hard to make a schema that complies with MySQL
> somewhere in between MySQL and the mm.mysql driver the EJB transaction
> support falls apart. My inclination is that its the mm.mysql
> driver itself,
> and the real problem is just that transaction support is not
> implimented in
> a way that complies with the EJB spec (e.g. javax.transaction
> doesn't occur
> anywhere in the source).
>
> So, while you can use MySQL with Orion you can't do EJB
> unless you switch
> over to SAPdb, PostgresSQL, or db.
>
> -----Original Message-----
> From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 3:52 PM
> To: Orion-Interest
> Subject: Re: orion with mysql?
>
>
> Am using MySQL with Orion without it's own db-schema. No
> problems, yet.
>
> Be sure to get the MM.MySQL driver...
> --
>
> -Geoff Marshall, Director of Development
>
> .......................................................
> t e r r a s c o p e (415) 951-4944
> 54 Mint Street, Suite 110 direct (415) 625-0349
> San Francisco, CA 94103 fax (415) 625-0306
> .......................................................
>
> > From: Peter Peltonen <[EMAIL PROTECTED]>
> > Organization: Fivetec Solutions Oy
> > Reply-To: Orion-Interest <[EMAIL PROTECTED]>
> > Date: Wed, 04 Apr 2001 19:42:44 +0300
> > To: Orion-Interest <[EMAIL PROTECTED]>
> > Subject: orion with mysql?
> >
> >
> > Is it possible to use MySQL with Orion? Does it need a
> db-schema of it's
> own?
> >
> > We tried to use PostgreSQL but JBuilder4 didn't cope with
> it very well
> > (JBuilder isn't able to show Postgre's tables). We also
> tried Hypersonic,
> but
> > it seems that when both Orion and JBuilder communicate with
> the db the db
> gets
> > confused. At least the changes we make in JBuilder don't
> get updated.
> >
> > Any ideas about a good open-source db that would work with
> both Orion and
> > JBuilder would be appreciated!
> >
> > Regards,
> > Peter
> >
> >
>
>
>
