Mike
Which Sybase JDBC version are you using? I think their latest stable version
is 5.2 (a type 4 JDBC 2.0 compliant driver).
Regards,
Michael Mok
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mike
Cannon-Brookes
Sent: Sunday, 21 January 2001 17:57
To: Orion-Interest
Subject: RE: Sybase experience anyone?
I can say that we're in the process of switching our app from Sybase 11.0.3
(on Linux) to PostgreSQL.
The Sybase JDBC driver was fugged for us, it locks up at about 50 concurrent
connections, sending the database spiralling and grabbing more and more CPU,
until Orion just gives errors with every page and Sybase sits at 100% CPU.
We rectified this buy buying a commercial Sybase driver (Inet I think).
For the site revamp have decided to move to PostgreSQL, seems to be
performing brilliantly so far. It also has a much more active developer
community, a JDBC driver that I can fix myself, and plenty of places to get
support.
Never tried Interbase or SapDB.
My $0.02.
-mike
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Krueger
> Sent: Sunday, January 21, 2001 8:12 PM
> To: Orion-Interest
> Subject: Re: Sybase experience anyone?
>
>
> 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
>
>
>
