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