I can confirm that it is the driver, Sybase support confirmed that and said
"a fix is in the works" (that was months ago now).
Nonetheless I suspect it was a very specific bug to our situation, the rest
of the driver seemed to work great ;)
(We installed all the JDBC procedures as needed, otherwise nothing works)
My $2 ;)
-mike
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Monday, January 22, 2001 8:06 PM
> To: Orion-Interest
> Subject: SV: Sybase experience anyone?
>
>
> Well i do not think its the driver... Weve been using this one for a long
> time, and it works perfectly for us.
>
> Were allso serving lots of users through Orion though, so Orion drives the
> connection pool against the database.
>
> But it will not work any good without the procedures following the JDBC
> driver, then it fails and use lots of processor power.
>
> My $0.2
>
> Klaus
>
> -----Opprinnelig melding-----
> Fra: Mike Cannon-Brookes [mailto:[EMAIL PROTECTED]]
> Sendt: 21. januar 2001 10:57
> Til: Orion-Interest
> Emne: 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
> >
> >
> >
>
>
>
