Michael J. Segel [EMAIL PROTECTED] writes:
NetBeans: This is an OpenSource IDE that I believe is bundled and
downloadable from the Sun Java site. Has a hook to PointBase, didn't see
anything to allow Derby or any other database.
Comming in the next release...
Positives: Nice look and
MM == Mike Matrigali [EMAIL PROTECTED] writes:
MM Would need to see the exact documentation reference, but this is not
MM the case. The storage system keeps an estimate of the number of
MM rows in a table. For performance reasons this estimate is not exact
MM (ie. we don't
IBM RAD 6 is probably more on par with eclipse 3.1 than wsad 5.1.2 since
rad and eclipse run off similar codebases.
If given a choice, I'd prefer RAD 6 to WSAD 5.1.2 for eclipse 3.1
compatability, better ant support, etc. I'm not sure the derby plugin
will work with wsad, but I haven't
Choosing an IDE is nearly as personal as choosing a religion.
I've used Eclipse and it isn't too bad, but for my money JetBrains IDEA is
still better. The user interface is just so well thought out by comparison.
Admittedly, it's a commercial product, but then, in this case, you definitely
get
I believe I've figured out what's going on with this bug. It involves
an optimization to materialize subquery results in some cases. This
optimization works by creating a nested union of in-memory rows.
What's happening in this case is that the unions are nested so deep
that it gets a stack
Check out Derby site at: http://db.apache.org/derby/integrate/misc.html
This also lists a few other GUI tools, like Cloudscape Workbench,
iSQL-Viewer, SQuirreL_SQL.
Satheesh
Michael J. Segel wrote:
Sorry if this is slightly off topic, but since the individuals on this list
are doing actual
Here's a potential workaround for your problem. I suspect it will
work, but I'm not sure:
SELECT path from filesystemfiles where not exists
(select * from existingfiles where existingfiles.path =
filesystemfiles.path)
The query does the same thing as your original one with not in,