Re: Derby Development and IDEs?

2005-10-20 Thread Dyre . Tjeldvoll
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

Re: How to update cardinality statistics

2005-10-20 Thread Øystein Grøvlen
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

Re: Derby Development and IDEs?

2005-10-20 Thread Brian Bonner
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

Re: Derby Development and IDEs?

2005-10-20 Thread acemccloudxx
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

RE: Error 38000 with a stack overflow on recordset.next()?

2005-10-20 Thread Jeffrey Lichtman
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

Re: Derby Development and IDEs?

2005-10-20 Thread Satheesh Bandaram
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

RE: Error 38000 with a stack overflow on recordset.next()?

2005-10-20 Thread Jeffrey Lichtman
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,