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/
