wood burning stoves 2.0*
The moose likes JDBC and the fly likes IDE for Sql Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "IDE for Sql Server" Watch "IDE for Sql Server" New topic
Author

IDE for Sql Server

Alana Sparx
Ranch Hand

Joined: Feb 14, 2006
Posts: 121
Any recommendations?

Query Analyser I have found to be a primitive piece of rubbish.

I've tried Squirrel-Sql, and although it supports nifty functions (like code complete, returning metadata and rowcounts) it has the annoying habit of endlessly writing to its heapdump logfile until I kill the process if it encounters errors / sql statements that generate large result sets. These errors can be as simple as the connection to the DB no longer existing. Latterly I tried an outer join on two table with 1 million+ rows apiece. THis should be manageable, yes?

Help!
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

SQuirrel SQL doesn't give me this problem. Could you not just set the log level to fatal and the problem would go away?

That aside, I can't think of an editor that wouldn't struggle if you are trying to return records sets containing millions of results.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: IDE for Sql Server