At 18:58 20.01.2001 , you wrote:
>Hello,
>
>We are about to decide about the database platform on which we will deploy
>our first J2EE application. Preferrably, it should be a cost-free solution.
>First I would like to ask if anyone has experience to share about using
>Sybase 11.0.3 (the one that is free to deploy under Linux). I especially
>wonder about the JDBC driver (does it come with one?).
>
>I have read about people using Interbase and PostgreSQL successfuly. I would
>still like to conduct a shootout between the following databases:
>
>Interbase
>PostgreSQL
>Sybase 11.0.3
>SapDB
We've had (/have?) the same problem and we settled for sapdb if nothing
unexpected happens.
Reasoning:
- We don't trust Postgresql to be as mature in areas like backup, mirroring
as one of the commercial products (anyone comment on that?)
- Worked with Adabas for the past three years in production and never had a
significant problem (one year in combination with orion). We were only
pissed at how unprofessionally Software AG handled development and support
for Adabas Tools and drivers (JDBC and Perl). Now that that seems to be a
lot better with SAPDB (basically being the same as Adabas, I think you told
me that Christian, thank you again for that hint :-) we only have minor
things that make SAPDB less fun to work with than Oracle (by far the best
RDBMS I've worked with but you know ...$$$).
- Sybase worked well in our tests here too but we thought what could happen
when at some point Sybase decided not to support this (very old) free
version with new versions of JDBC drivers. Probably not relevant for the
next year or so but you never know. SAPDB feels a safer choice in that regard.
- A very individual reason. We have Adabas know-how and experience here and
the basic concepts are exactly the same, so we don't have to make all the
beginners' mistakes again with a new RDBMS.
- Interbase (on linux) initially worked very well (also with orion) but
proved to be VERY unstable (especially the JDBC driver)
The only thing we haven't decided on is a low-cost failover solution for
the database. But we're experimenting.
Anyone else got a comment on that?
Robert
>anyone?
>thanks,
>Christian Sell
>
(-) Robert Krüger
(-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
(-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de