orion + jbuilder4 -- sapdb?
Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
Re: orion + jbuilder4 -- sapdb?
I always like to pitch SapDB, because like Interbase, SAP DB, from the folks who brought us SAP R/3 etc has been around the block. Has a lot of good stuff: Referential Integrity, Triggers, Stored Procs, updateable views, subselects and outer joins, scrollable cursors, plus maintenance-wise it has online backup, online expansion of the db, a solid set of commandline and gui-based maintenance tools (some are available on Windows platforms only, for now) an active user community, an active and helpful news group, and active support from a reasonable-sized team of developers at SAP Labs in Berlin. The programming interfaces include ODBC, C/C++ precompiler, JDBC (the one I use - it has a type4 jdbc driver that is pretty solid), Perl DBI, Python, and PHP. Backup tools that can be used are: ADSM + adint2 Networker Netvault, HiBack (soon) Backint for Oracle Tools supporting this interface are: ARCserve, Backup Express, dbBRZ for R/3, DBVAULT, DoroStore, EASY_BASE, EMC, EPOCH, FDR/UPSTREAM, HIBACK, HSMS-CL Backint, NetBackup, NetVault, NetWorker, Omniback, Seagate Backup, SESAM, Solstice Backup, Sys-Save, TIME NAVIGATOR for R/3, Tivoli I believe they have something like 800 clients using it with an implementation of SAP R/3. It has its quirks, here and there, which you'll notice if you try and get the Petstore to work with it. But I think it is a great product, works well with Orion, handles CMP in a dandy fashion. Etc. I would encourage at least evaluating the product. However, I am forgetting about your question, and that is does it work with JBuilder4 and how does it compare to MySQL and postresql? I haven't worked with postgresql, perhaps another person can speak to that, but I have use MySQL. MySQL is unbelievably quick, and while there is now transaction support that is coming out of the mysql camp - we decided to look at databases that already had it and stumbled on this one (SAP DB). It is quick as well and does what we want. It has a larger footprint than MySQL, but that would be expected. It's a quick db as well and has a lot of configurable options to help out in that arena. Does it work with JBuilder4? Don't know! I don't see why it wouldn't, but I'm a UltraEdit/Vi-Ant guy so I can't speak for it - again perhaps someone else on the list can shed some light. There was another posting that suggested using Interbase with JBuilder4 - that is certainly a good idea since Borland and JBuilder have been so closely linked. I have used Interbase and JBuilder before but that was several years ago (They worked then!) Good luck Ray Harrison --- Peter Peltonen [EMAIL PROTECTED] wrote: Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
Re: orion + jbuilder4 -- sapdb?
Randahl Fink Isaksen wrote: Thanks for your recommendation. We've thought about Interbase. I browsed through Borland's web pages which were really not that informative and I got an impression that *development* use with Interbase is free but *production* use would be under commercial license... That was why we didn't consider it at this time. Or was I totally wrong and Interbase is free for all uses? I am just exploring SapDB. Got the RPMs installed and I'm now browsing through the PDF documentation, which is a bit confusing (is there an HTML version somewhere of these docs? Acroread under Linux doesn't behave well with my Netscape). I cannot find a "beginner's tutorial" anywhere, I mean information like how to start / stop the service, how to start the gui and so on. Any help appreciated :) Cheers, Peter Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
The only product that can beat it is Oracle, but that's not an option for everyone, because of the cost. Since there are so many good, free database products, such as Interbase, Postgresql, Mysql, SapDB, etc., you really can pick and choose. For the record, all of these databases have been around in some form or another for approximately fifteen years. Even mysql, which was formed as a company only five years ago, had the database product around ten years before that. Randy -Original Message- From: Randahl Fink Isaksen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:12 AM To: Orion-Interest Subject: RE: orion + jbuilder4 -- sapdb? Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
No. AFAIK: Adabas belongs to Software AG, not to SAP. However, if you would say SapDB == Adabas D that would be correct. you can read more about it on www.sapdb.org -Original Message- From: Klaus Thiele [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:46 PM To: Orion-Interest Subject: Re: orion + jbuilder4 -- sapdb? Hello, perhaps a little bit misplaced here... SAB DB == Adabas is this right? thanks klaus Am Donnerstag, 5. April 2001 14:01 schrieben Sie: I always like to pitch SapDB, because like Interbase, SAP DB, from [...] -- Klaus Thiele - Personal Informatik AG mailto:[EMAIL PROTECTED] "Your mouse has moved. Windows must be restarted for the change to take effect."
RE: orion + jbuilder4 -- sapdb?
I believe Interbase is totally free. For some reason Borland does not emphasize this very much - maybe to make sure people don't think it is a discount product. Interbase is released under a licence which besides the usual juristical mumbo jumbo says the following three important things: "grants You a world-wide, royalty-free, non-exclusive license" (...) "to use, reproduce, modify, display, perform, sublicense and distribute the Original Code (or portions thereof) with or without Modifications, and/or as part of a Larger Work;" (...) "under Patents Claims infringed by the making, using or selling of Original Code, to make, have made, use, practice, sell, and offer for sale, and/or otherwise dispose of the Original Code (or portions thereof)." And I feel sure that if it was not for these sentences there would not be an open source project based on Interbase called "Firebird" at http://firebird.sourceforge.net. - That's interesting by the way... when Interbase went open source Borland was slow on getting up to speed with the open source web community stuff, so the open source developers took the project elsewhere and renamed it "Firebird", which means that Borland has no control over what happens with the Firebird project. - Probably not what Borland expected at all. Now the developers at "Firebird" claim they have made a bunch of bug fixes which should be the reason to choose their product. Still, we are definately going to stick with Borland for now; after all they have many years of experience with developing the product, so having them control the open source effort somewhat might be a good thing. Hope this clarifies what Borland did not make obvious at their web site. Yours Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 15:05 To: Orion-Interest Subject: Re: orion + jbuilder4 -- sapdb? Randahl Fink Isaksen wrote: Thanks for your recommendation. We've thought about Interbase. I browsed through Borland's web pages which were really not that informative and I got an impression that *development* use with Interbase is free but *production* use would be under commercial license... That was why we didn't consider it at this time. Or was I totally wrong and Interbase is free for all uses? I am just exploring SapDB. Got the RPMs installed and I'm now browsing through the PDF documentation, which is a bit confusing (is there an HTML version somewhere of these docs? Acroread under Linux doesn't behave well with my Netscape). I cannot find a "beginner's tutorial" anywhere, I mean information like how to start / stop the service, how to start the gui and so on. Any help appreciated :) Cheers, Peter Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
I just checked out the sourceforge site for interbase...there doesn't seem to be anything there. There are not files to download, nor is the cvs available. Firebird seems to be available, but is not the Borland distribution. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Randahl Fink Isaksen Sent: Thursday, April 05, 2001 8:28 AM To: Orion-Interest Subject: RE: orion + jbuilder4 -- sapdb? I believe Interbase is totally free. For some reason Borland does not emphasize this very much - maybe to make sure people don't think it is a discount product. Interbase is released under a licence which besides the usual juristical mumbo jumbo says the following three important things: "grants You a world-wide, royalty-free, non-exclusive license" (...) "to use, reproduce, modify, display, perform, sublicense and distribute the Original Code (or portions thereof) with or without Modifications, and/or as part of a Larger Work;" (...) "under Patents Claims infringed by the making, using or selling of Original Code, to make, have made, use, practice, sell, and offer for sale, and/or otherwise dispose of the Original Code (or portions thereof)." And I feel sure that if it was not for these sentences there would not be an open source project based on Interbase called "Firebird" at http://firebird.sourceforge.net. - That's interesting by the way... when Interbase went open source Borland was slow on getting up to speed with the open source web community stuff, so the open source developers took the project elsewhere and renamed it "Firebird", which means that Borland has no control over what happens with the Firebird project. - Probably not what Borland expected at all. Now the developers at "Firebird" claim they have made a bunch of bug fixes which should be the reason to choose their product. Still, we are definately going to stick with Borland for now; after all they have many years of experience with developing the product, so having them control the open source effort somewhat might be a good thing. Hope this clarifies what Borland did not make obvious at their web site. Yours Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 15:05 To: Orion-Interest Subject: Re: orion + jbuilder4 -- sapdb? Randahl Fink Isaksen wrote: Thanks for your recommendation. We've thought about Interbase. I browsed through Borland's web pages which were really not that informative and I got an impression that *development* use with Interbase is free but *production* use would be under commercial license... That was why we didn't consider it at this time. Or was I totally wrong and Interbase is free for all uses? I am just exploring SapDB. Got the RPMs installed and I'm now browsing through the PDF documentation, which is a bit confusing (is there an HTML version somewhere of these docs? Acroread under Linux doesn't behave well with my Netscape). I cannot find a "beginner's tutorial" anywhere, I mean information like how to start / stop the service, how to start the gui and so on. Any help appreciated :) Cheers, Peter Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter