Cheap/free query tool for multi-database Java/hibernate developer

Question

I'm very interesting in inexpensive (better free) SQL query tool for working with multiple databases.

Generally speaking it should works with all databases which Hibernate supports, but it must work with Microsoft SQL Server (2000/2005/2008), Oracle (9i/10g/11g), Postgres 8.x, Sybase, Firebird, MySQL and HSQLDB.

Must have features:

• SQL code completion
• Syntax highlighting

Nice to have features:

• Hibernate integration
• Database specific options (like query execution plan)

Not sure if it worth to mentioned, but it will be used together with Eclipse (multiple workspaces).

Answer 1

I'm really surprised nobody mentioned any Eclipse plugins which will fit neatly into your requirements. See my answer to this question. Also, MyEclipse recently released a cool visual query builder which you might want to check out.

Answer 2

i think everyone will give you same solution, squirrel sql ,we are all using same tool =)

Answer 3

I really liked SQUrrel until I discovered DBClient THere's also DbVisualizer but it's not free anymore

Answer 4

My favorite is Squirrel SQL. Works well, simple to set up, nice GUI, works with all JDBC databases.

http://squirrel-sql.sourceforge.net/