RE: Interbase Details [Was HARDWARE FOR J2EE apps]
At 16:43 12.10.00 , you wrote: I'm not sure why noone has mentioned Sybase yet? Sybase 11.0.3.3 on Linux is free for all uses, and supports replication, backup servers etc etc etc. Replication using 11.0.3.3? Do you mean with the additional Replication Server (commercial) or is there another way? Are you using replication with that version of sybase? We are deciding between sybase 11.0.3.3 and Interbase 6 and are currently leaning towards Interbase because we don't know how Sybase will support this product in the future. What if they decide not to support JDBC X.X for the free versions at some point. then you'll be forced to buy the commercial version. that's why we felt we'd go for Interbase if it works well with orion. We have installed it here and have migrated one large orion application (ejb and direct sql) that was running on adabas to interbase. that took two days and seems to work very well. it's a shame Software AG failed so miserably making Adabas D a well-supported product. they were the first commercial database vendor to port to linux and the software has all the features you need (including clustering support) at an unbeatable price. somehow nobody outside germany seems to use it, which is why we'll eventually be dropping it (no community support). robert Very full featured and quite fast from my experience, a true enterprise RDBMS. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Rimov Sent: Thursday, October 12, 2000 3:06 PM To: Orion-Interest Subject: Interbase Details [Was HARDWARE FOR J2EE apps] At 06:24 PM 10/11/2000 -0400, you wrote: Why would you use mySQL over Postgresl? They're both free, but Postgresql has a JDBC driver that's XA-compliant. Also, mySQL is known to blow away your whole database if it has a bad crash, whereas Postgresql is better at persisting data through a bad crash. How does Interbase 6 compare to Postgresql? Is it free? Interbase is now free. It used to be a commercial Database sold by Inprise/Borland. Because this is the first opensource release, not all the new features for IB6 are fully available for ODBC and JDBC yet. I've worked with the JDBC drivers, and I have no complaints. Drivers that support all the new features are in the works (ODBC drivers are in beta, JDBC drivers are still in development). Interbase does support transactions and blobs. Most current users of Interbase are from Borland Delphi and C++ Builder camps. There's a company out of South Africa that's offering a replication engine that might be useful for people trying to set up a failover-capable system. (Don't have any details on hand... sorry) As far as speed goes, I don't know how it compares to postgresql. Mers, inc. has an online full-text search setup of all the Inprise newsgroups made from their own commercial extensions to interbase. Its pretty snappy. It exists on http://www.mers.com/ And finally, for windows users, there's a very nice management console that you can use to locally or remotely administer your database. (The database itself doesn't have to reside on windows) I think that's about all I can say about it. The biggest problem it has right now is that the multi-threaded server version doesn't scale well with multiple processors. Of course, since its open source, we don't have to wait until Borland releases a new version a year down the road to get that feature fully going. :-) Hope this clarifies information on it! -Mike (-) 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
RE: Interbase Details [Was HARDWARE FOR J2EE apps]
Sybase JDBC drivers are called "JConnect". Current version is 5.2 (for JDBC2) and 4.2 (JDBC1) I had a few problems with them ages ago and bought a commercial driver - never tried again, but they have evolved I think. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Kinnvall Sent: Thursday, October 12, 2000 5:29 PM To: Orion-Interest Subject: RE: Interbase Details [Was HARDWARE FOR J2EE apps] Hi! On Thu, 12 Oct 2000, Mike Cannon-Brookes wrote: I'm not sure why noone has mentioned Sybase yet? Sybase 11.0.3.3 on Linux is free for all uses, and supports replication, backup servers etc etc etc. Very full featured and quite fast from my experience, a true enterprise RDBMS. And JDBC drivers for Sybase? Last time I tried to get them from Sybase I failed miserably. Couldn't find them, not to mention download them. I seem to remember a very awkward system with registration and icky navigation to get to the drivers at all...is that easier now? Maybe I gave up to late. :-) Enough rambling: - Where can the JDBC drivers for Sybase be downloaded? - Which version should be used? - Any special things worth knowing about Sybase and its JDBC drivers that could cause problems otherwise? Mike Thanx for any help, David. Reach me by - Email: [EMAIL PROTECTED], WWW: http://www.dtek.chalmers.se/~d0dak/ - --/David-- -
Re: Interbase Details [Was HARDWARE FOR J2EE apps]
it's a shame Software AG failed so miserably making Adabas D a well-supported product. they were the first commercial database vendor to port to linux and the software has all the features you need (including clustering support) at an unbeatable price. somehow nobody outside germany seems to use it, which is why we'll eventually be dropping it (no community support). Robert, dont you think that this is going to improve now that SAP DB (same as ADABAS D?!) is on the way to open source??
Re: Interbase Details [Was HARDWARE FOR J2EE apps]
Mike Cannon-Brookes wrote: Sybase JDBC drivers are called "JConnect". Current version is 5.2 (for JDBC2) and 4.2 (JDBC1) I had a few problems with them ages ago and bought a commercial driver - never tried again, but they have evolved I think. And JDBC drivers for Sybase? Last time I tried to get them from Sybase I failed miserably. Couldn't find them, not to mention download them. I seem to remember a very awkward system with registration and icky navigation to get to the drivers at all...is that easier now? Maybe I gave up to late. :-) - Where can the JDBC drivers for Sybase be downloaded? - Which version should be used? - Any special things worth knowing about Sybase and its JDBC drivers that could cause problems otherwise? The drivers can actially be found at sybase ;-) It took me a couple of hours to find them their site really sucks in relation to navigation. I'm using JConnect 5.2 and it's a pretty good driver (much better imho than for example DB2 Oracle drivers. I've heard of one bug, but haven't seen it myself, it's simmilar to the bug in the older MySql (mm) drivers, and does not allow images of more than 32k to be inserted into or obtained from the database. But I agree with the above mentioned. IMHO the free linux version is the best i've seen so far. Highly scalable, quite fast (select * from where pk='x' on a table with more than 7 million records is almost instantanious and several joins on tables with more than 7 million records goes in less than a second), it's slow (imho) in populating the db (700 records took about 14 hrs (4 on mysql!)). The docs are great (about seven books(ps) with 500+ pages) sven -- == Sven E. van 't Veer http://www.cachoeiro.net Java Developer [EMAIL PROTECTED] ==
Re: Interbase Details [Was HARDWARE FOR J2EE apps]
At 13:58 12.10.00 , you wrote: it's a shame Software AG failed so miserably making Adabas D a well-supported product. they were the first commercial database vendor to port to linux and the software has all the features you need (including clustering support) at an unbeatable price. somehow nobody outside germany seems to use it, which is why we'll eventually be dropping it (no community support). Robert, dont you think that this is going to improve now that SAP DB (same as ADABAS D?!) is on the way to open source?? I was not aware of that. I just checked the docs and didn't find anything on clustering. Does it support that? I know Adabas D does (or used to?). Definitely worth a look, though. Thanks for the info. Robert (-) 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
Re: Interbase Details [Was HARDWARE FOR J2EE apps]
At 13:58 12.10.00 , you wrote: it's a shame Software AG failed so miserably making Adabas D a well-supported product. they were the first commercial database vendor to port to linux and the software has all the features you need (including clustering support) at an unbeatable price. somehow nobody outside germany seems to use it, which is why we'll eventually be dropping it (no community support). Robert, dont you think that this is going to improve now that SAP DB (same as ADABAS D?!) is on the way to open source?? one more thing. have you used sap db with orion? if you have or will please keep the list posted how well everything works. robert (-) 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
Interbase Details [Was HARDWARE FOR J2EE apps]
At 06:24 PM 10/11/2000 -0400, you wrote: Why would you use mySQL over Postgresl? They're both free, but Postgresql has a JDBC driver that's XA-compliant. Also, mySQL is known to blow away your whole database if it has a bad crash, whereas Postgresql is better at persisting data through a bad crash. How does Interbase 6 compare to Postgresql? Is it free? Interbase is now free. It used to be a commercial Database sold by Inprise/Borland. Because this is the first opensource release, not all the new features for IB6 are fully available for ODBC and JDBC yet. I've worked with the JDBC drivers, and I have no complaints. Drivers that support all the new features are in the works (ODBC drivers are in beta, JDBC drivers are still in development). Interbase does support transactions and blobs. Most current users of Interbase are from Borland Delphi and C++ Builder camps. There's a company out of South Africa that's offering a replication engine that might be useful for people trying to set up a failover-capable system. (Don't have any details on hand... sorry) As far as speed goes, I don't know how it compares to postgresql. Mers, inc. has an online full-text search setup of all the Inprise newsgroups made from their own commercial extensions to interbase. Its pretty snappy. It exists on http://www.mers.com/ And finally, for windows users, there's a very nice management console that you can use to locally or remotely administer your database. (The database itself doesn't have to reside on windows) I think that's about all I can say about it. The biggest problem it has right now is that the multi-threaded server version doesn't scale well with multiple processors. Of course, since its open source, we don't have to wait until Borland releases a new version a year down the road to get that feature fully going. :-) Hope this clarifies information on it! -Mike
RE: Interbase Details [Was HARDWARE FOR J2EE apps]
I'm not sure why noone has mentioned Sybase yet? Sybase 11.0.3.3 on Linux is free for all uses, and supports replication, backup servers etc etc etc. Very full featured and quite fast from my experience, a true enterprise RDBMS. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Rimov Sent: Thursday, October 12, 2000 3:06 PM To: Orion-Interest Subject: Interbase Details [Was HARDWARE FOR J2EE apps] At 06:24 PM 10/11/2000 -0400, you wrote: Why would you use mySQL over Postgresl? They're both free, but Postgresql has a JDBC driver that's XA-compliant. Also, mySQL is known to blow away your whole database if it has a bad crash, whereas Postgresql is better at persisting data through a bad crash. How does Interbase 6 compare to Postgresql? Is it free? Interbase is now free. It used to be a commercial Database sold by Inprise/Borland. Because this is the first opensource release, not all the new features for IB6 are fully available for ODBC and JDBC yet. I've worked with the JDBC drivers, and I have no complaints. Drivers that support all the new features are in the works (ODBC drivers are in beta, JDBC drivers are still in development). Interbase does support transactions and blobs. Most current users of Interbase are from Borland Delphi and C++ Builder camps. There's a company out of South Africa that's offering a replication engine that might be useful for people trying to set up a failover-capable system. (Don't have any details on hand... sorry) As far as speed goes, I don't know how it compares to postgresql. Mers, inc. has an online full-text search setup of all the Inprise newsgroups made from their own commercial extensions to interbase. Its pretty snappy. It exists on http://www.mers.com/ And finally, for windows users, there's a very nice management console that you can use to locally or remotely administer your database. (The database itself doesn't have to reside on windows) I think that's about all I can say about it. The biggest problem it has right now is that the multi-threaded server version doesn't scale well with multiple processors. Of course, since its open source, we don't have to wait until Borland releases a new version a year down the road to get that feature fully going. :-) Hope this clarifies information on it! -Mike