This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "IDE for Sql Server" Watch "IDE for Sql Server" New topic

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?

Paul Sturrock

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
Similar Threads
Compilation error
compareing two values
import statement - Difference
How to enter 2 parameters of the same type in a class constructor
why is the column data not displaying?