Best SQL browser for HSQLDB?

java sql browser hsqldb sqlbrowser
hawkeye picture hawkeye · Feb 14, 2011 · Viewed 66.6k times · Source

Whats the best browser tool for HSQLDB databases?

Answer

hawkeye picture hawkeye · Mar 1, 2011

HSQL has built-in GUI query tool called Database manager. In the directory of the database files run:

java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManager

and then setting the config to:

jdbc:hsqldb:file:databaseName

Allowed me to edit what I needed in a really convenient way.

Related questions

How to convert java.util.Date to java.sql.Date?

I am trying to use a java.util.Date as input and then creating a query with it - so I need a java.sql.Date. I was surprised to find that it couldn't do the conversion implicitly or explicitly …

Read More
could not extract ResultSet in hibernate

I have a problem with Hibernate. I try to parse to List but It throws an exception: HTTP Status 500 - could not extract ResultSet. When I debug, It fault at line query.list()... My sample code here @Entity @Table(name = "…

Read More
Hibernate show real SQL

if I set <property name="show_sql">true</property> in my hibernate.cfg.xml configuration file in the console I can see the SQL. But it's not real SQL... Can I see the SQL code that …

Read More