File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes IDE for Sql Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
I agree. Here's the link:
subject: IDE for Sql Server