Re: orion with mysql?
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 'xx' 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 > > > > > > > > > > > >
Re: orion with mysql?
Sounds like you need to turn off exclusive-write-access in orion-ejb-jar.xml while you're putzing with the database outside of the application. We're running with SQL Server 7 (*gasp*) and Orion will try to "fix" any manual changes we make to the database through the admin console. Otherwise, we have to shutdown Orion, make the changes, and restart. The performance hit is huge, so you wouldn't want to leave it turned off, but Orion will basically go talk to the database at every accessor to make sure that it's got the latest data and not assume that Orion knows best. Rian - Original Message - From: Armin Michel <[EMAIL PROTECTED]> To: Orion-Interest <[EMAIL PROTECTED]> Sent: Thursday, April 05, 2001 12:25 AM Subject: Re: orion with mysql? > > [...] 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. > > That's propably because Orion caches data of the DB. If you stop Orion, then > update the DB and then restart Orion, you shouldn't perceive any update > problems. > > Greetings > > Armin >
RE: orion with mysql?
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 > > > > > > >
Re: orion with mysql?
You have some control over the caching. Read up on exclusive-write-access and validity-timeout at http://www.orionserver.com/docs/orion-ejb-jar.xml.html , and search the archives ( http://www.mail-archive.com/orion-interest%40orionserver.com/ ) for max-instances, which hasn't been added to the documentation. Kirk Yarina At 09:25 AM 4/5/01 +0200, you wrote: > > [...] 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. > >That's propably because Orion caches data of the DB. If you stop Orion, then >update the DB and then restart Orion, you shouldn't perceive any update >problems. > >Greetings > >Armin
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 > > > > > > >
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 > > > > > > >
Re: orion with mysql?
> [...] 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. That's propably because Orion caches data of the DB. If you stop Orion, then update the DB and then restart Orion, you shouldn't perceive any update problems. Greetings Armin
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 > >
RE: orion with mysql?
I am also using Orion with mySql without the Schema no problems here :D jsut have the jar driver in the lib directory -Original Message- From: Geoff Marshall [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:52 AM 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 > > The contents of this email are confidential. If you are not the intended recipient, you must not disclose, copy or use the contents in any way. If you have received this email in error, please delete it and notify us immediately by return email. It is the recipient's responsibility to screen this message and any attachments for computer viruses. Any views expressed in this email are not to be taken as the views of the company or any related business entity unless expressly stated to the contrary.
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 > >
Re: orion with mysql?
Try SapDB (www.sapdb.org)as one of your evaluations. I don't use JBuilder, but other tools I have used have been able to see SapDB tables no problem. Although it doesn't really make sense that JBuilder can't see PostgreSQL tables using the jdbc driver. --- Peter Peltonen <[EMAIL PROTECTED]> wrote: > > 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 > __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text