assuming you are setting up mysql version 3.23.33 in a linux box. need to
download both mysql and the berkeley engine.can be found in www.mysql.com
---------------------------------------------------
first time installing mysql. log in as root
assume mysql install dir = /mysql and berkeley install dir = /db-3.2.9a
>cd /mysql
>./configure --with-berkeley-db=/db-3.2.9a (to enable transaction tables.
3.2.9a is the patch version for mysql 3.23.xx versions)
this will then start the server for the first time. must set pwd for root
>bin/mysqladmin -u root password 'xxxxxx'
after that you'll have to option to create transactional tables which can be
used with EJBs
----- Original Message -----
From: "Kemp Randy-W18971" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 9:09 PM
Subject: RE: orion with mysql?
> I believe the latest release of Mysql supports transactions, but I am not
sure the binaries are set with the Berkeley transaction engine. You may
have to compile both, and this is a question for Mysql.
>
> -----Original Message-----
> From: Kiss Tibor [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 3: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
> > >
> > >
> >
> >
> >
