Frontend tool to manage H2 database

Question

How to use H2 database s integrated managment frontend   For operations such as create table  alter table  add column  and so on

User · Answer

I use DbVisualizer a lot for H2-db administration    There exists a free version   https   www dbvis com download

User · Answer

If you are running it as an embedded database in spring I use the following configuration to enable the built in web client when the main app is running    lt  -- Run H2 web server within application that will access the same in-memory database -- gt   lt bean id  h2Server  class  org h2 tools Server  factory-method  createTcpServer  init-method  start  destroy-method  stop  depends-on  h2WebServer  gt       lt constructor-arg value  -tcp -tcpAllowOthers -tcpPort 9092   gt   lt  bean gt   lt bean id  h2WebServer  class  org h2 tools Server  factory-method  createWebServer  init-method  start  destroy-method  stop  gt       lt constructor-arg value  -web -webAllowOthers -webPort 8082   gt   lt  bean gt

User · Answer

I use sql-workbench for working with H2 and any other DBMS I have to deal with and it makes me smile  -

User · Answer

I would like to suggest DBEAVER  it is based on eclipse and supports better data handling

User · Answer

I would suggest Jetbrain s IDE  DataGrip https   www jetbrains com datagrip

User · Answer

I haven t used it  but RazorSQL looks pretty good

User · Answer

one discuss found here  quote from Thomas Mueller      http   www dbsolo com      http   www minq se products dbvis      http   executequery org index jsp     http   sqldeveloper solyp com index html     http   sql-workbench net index html     http   www squirrelsql org

User · Answer

There s a shell client built in too which is handy   java -cp h2  jar org h2 tools Shell   http   opensource-soa blogspot com au 2009 03 how-to-use-h2-shell html    java -cp h2 jar org h2 tools Shell -help Interactive command line tool to access a database using JDBC  Usage  java org h2 tools Shell  lt options gt  Options are case sensitive  Supported options are   -help  or  -          Print the list of options  -url   lt url gt            The database URL  jdbc h2       -user  lt user gt           The user name  -password  lt pwd gt        The password  -driver  lt class gt        The JDBC driver class to use  not required in most cases   -sql   lt statements gt     Execute the SQL statements and exit  -properties   lt dir gt     Load the server properties from this directory If special characters don t work as expected  you may need to use  -Dfile encoding UTF-8  Mac OS X  or CP850  Windows   See also http   h2database com javadoc org h2 tools Shell html

User · Answer

I like SQuirreL SQL Client  and NetBeans is very useful  but more often  I just fire up the built-in org h2 tools Server and browse port 8082      java -cp  opt h2 bin h2 jar org h2 tools Server -help Starts the H2 Console  web-  server  TCP  and PG server  Usage  java org h2 tools Server  When running without options  -tcp  -web  -browser and -pg are started  Options are case sensitive  Supported options are   -help  or  -           Print the list of options  -web                   Start the web server with the H2 Console  -webAllowOthers        Allow other computers to connect - see below  -webPort         The port  default  8082   -webSSL                Use encrypted  HTTPS  connections  -browser               Start a browser and open a page to connect to the web server  -tcp                   Start the TCP server  -tcpAllowOthers        Allow other computers to connect - see below  -tcpPort         The port  default  9092   -tcpSSL                Use encrypted  SSL  connections  -tcpPassword      The password for shutting down a TCP server  -tcpShutdown      Stop the TCP server  example  tcp   localhost 9094  -tcpShutdownForce      Do not wait until all connections are closed  -pg                    Start the PG server  -pgAllowOthers         Allow other computers to connect - see below  -pgPort          The port  default  5435   -baseDir          The base directory for H2 databases  for all servers  -ifExists              Only existing databases may be opened  for all servers  -trace                 Print additional trace information  for all servers

User · Answer

How about the H2 console application

[database] Frontend tool to manage H2 database

Examples related to database

Examples related to h2

Examples related to database-administration