SV: Sybase experience anyone?
There is one thing you have to remember conserning sybases JDBC driver. You have to install the procedures (a script file coming with the driver) before it works correctly. Other then that i have been using 11.5.2 and 11.9.2 + 12.0 without any problems, actualy I am impressed by how well the JDBC driver works :) Klaus -Opprinnelig melding- Fra: Chris Bartling [mailto:[EMAIL PROTECTED]] Sendt: 20. januar 2001 23:52 Til: Orion-Interest Emne: RE: Sybase experience anyone? JConnect for JDBC is their JDBC driver offering. Works well. 4.2 is JDBC 1.0 compliant and 5.2 is JDBC 2.0 compliant. http://www.sybase.com/detail/1,3693,1009796,00.html -- chris -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christian Sell Sent: Saturday, January 20, 2001 11:59 AM To: Orion-Interest Subject: Sybase experience anyone? 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 anyone? thanks, Christian Sell
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 Krger (-) SIGNAL 7 Gesellschaft fr Informationstechnologie mbH (-) Brder-Knau-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
RE: Sybase experience anyone?
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 Krger (-) SIGNAL 7 Gesellschaft fr Informationstechnologie mbH (-) Brder-Knau-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
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 Krger (-) SIGNAL 7 Gesellschaft fr Informationstechnologie mbH (-) Brder-Knau-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
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 Krger (-) SIGNAL 7 Gesellschaft fr Informationstechnologie mbH (-) Brder-Knau-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
RE: Sybase experience anyone?
We were using 5.2. -mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Mok Sent: Monday, January 22, 2001 1:41 PM To: Orion-Interest Subject: RE: Sybase experience anyone? 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 Krger (-) SIGNAL 7 Gesellschaft fr Informationstechnologie mbH (-) Brder-Knau-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
Sybase experience anyone?
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 anyone? thanks, Christian Sell
RE: Sybase experience anyone?
I've used Sybase 11.0.9 running in both W2K and Tru64 Unix(former Digital Unix) it has a jdbc driver called jconnect, you can download it from mysybase; there's a script you must run prior to use the driver (check the manual) Sybase has outperformed Oracle in every test I've done with OrionServer HTH JP -Original Message- From: Christian Sell [mailto:[EMAIL PROTECTED]] Sent: Sbado, 20 de Enero de 2001 14:59 To: Orion-Interest Subject: Sybase experience anyone? 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 anyone? thanks, Christian Sell
RE: Sybase experience anyone?
JConnect for JDBC is their JDBC driver offering. Works well. 4.2 is JDBC 1.0 compliant and 5.2 is JDBC 2.0 compliant. http://www.sybase.com/detail/1,3693,1009796,00.html -- chris -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christian Sell Sent: Saturday, January 20, 2001 11:59 AM To: Orion-Interest Subject: Sybase experience anyone? 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 anyone? thanks, Christian Sell