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
>
