"Duffey, Kevin" wrote:
>
> So of all the databases that are "free" to use, which one is best for load?
> I know of PostgreSQL, mySQL, Interbase, and Sybase 11.x. Can anyone maybe
> fill in the URLs where we can get these databases, as well as JDBC 2.0
> compliant drivers for them?
http://www.mysql.com
http://www.inprise.com/downloads/ for interbase
http://www.sybase.com/detail/1,3693,1010215,00.html for sybase ase
11.0.3.3 jdbc drivers you'll have to look for. They're called
JConnect5.2
and I guess postress is http://www.postgresql.org
sven
>
> Thanks.
>
> > -----Original Message-----
> > From: Colin Jacobs [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, October 27, 2000 1:56 PM
> > To: Orion-Interest
> > Subject: RE: Anyone using Interbase in production?
> >
> >
> > We built our prototype on InterBase. Mostly on NT but some
> > linux also.
> >
> > I had pretty mixed experiences with it. As a developer doing
> > JDBC stuff, I
> > didn't have many complaints. On paper, at least, IB6 looks
> > like a pretty
> > full-featured open-source DB. But our DB guy complained about
> > IB a lot (the
> > tools and features) - although, I think a lot of it was him
> > having been
> > "spoilt" by Oracle.
> >
> > One caveat: The IB JDBC drivers ("InterClient") connect to a
> > process called
> > interserver, then then connects to ibserver. I don't think
> > interserver is
> > very robust. I know that on NT, the interserver.exe processes
> > gradually
> > accumulate, until you start getting problems connecting. We
> > have to reboot
> > pretty regularly.
> >
> > Be advised the JDBC drivers don't support SQL dialect 3 yet. Also, the
> > relationship between the IB open source community and Inprise
> > isn't a great
> > one. I think this is slowing down the development of the JDBC
> > 2.0 drivers.
> > Plus, I believe there was a major fork in the IB source
> > within the last
> > couple of months.
> >
> > Luckily our real product is built on Oracle. I'd be a bit
> > hesitant to use IB
> > in production under any significant load. With hindsight I
> > would have looked
> > into PostgreSQL a bit more thoroughly.
> >
> > Colin
> >
> > -----Original Message-----
> > From: Jim Archer [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, October 27, 2000 10:26 AM
> > To: Orion-Interest
> > Cc: Jonas Larsson
> > Subject: Anyone using Interbase in production?
> >
> >
> > Does anyone here have any experience with Interbase in a production
> > environment? We are trying to decide which database to deploy in
> > production. Since we are a very low budget operation, we are
> > looking at
> > Open Source, but somehow missed this one.
> >
> > Our most important requirements are stability, transaction
> > support, a solid
> > JDBC driver (for use with an EJB server) and online backup capability.
> >
> > Any experiences people can offer would be appreciated,
> > especially in a
> > Linux environment.
> >
> > Thanks!
> >
> > Jim
> >
> >
> >
> >
> >
> > --On Friday, October 27, 2000 11:46 AM +0200 Jonas Larsson
> > <[EMAIL PROTECTED]> wrote:
> >
> > >
> > > You could always use Interbase which now is opensource..
> > > http://www.interbase.com
> > >
> > >
> > > ----- Original Message -----
> > > From: Laufer, Michael
> > > To: Orion-Interest
> > > Sent: Friday, October 27, 2000 10:41 AM
> > > Subject: MYSQL, Orion, EJB and transactions ??
> > >
> > >
> > > Hi there,
> > >
> > > I know that the question has been discussed here before,
> > but I'm still a
> > > little confused about using MYSQL together with Orion.
> > > I've just downloaded mysql (version 3.23.22 beta) and the manual
> > > announces that mysql is now supporting transactions. If I
> > understood it
> > > correctly, that would mean, that it should be possible to
> > use mysql with
> > > entity beans. Am I right ?? What's confusing to me is the
> > fact, that I
> > > only find news in mailing-list, that mysql is not supporting
> > > transactions.
> > >
> > > So I don't really now, if I can use mysql for entity beans.
> > > If not, which database would you suggest ??
> > > It should work on NT and not be the most expensive one as I
> > use it 'only'
> > > for writing my Master's Thesis.
> > >
> > > Thanks in advance,
> > >
> > > Michel
> > >
> >
> >
> >
> >
--
======================================================================================
Sven E. van 't Veer
http://www.cachoeiro.net
Java Developer [EMAIL PROTECTED]
======================================================================================
