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
> >
> >
>
>
>