管理H2数据库的前端工具 [英] Frontend tool to manage H2 database

问题描述

如何使用H2数据库的集成管理前端?

用于创建表、更改表、添加列等操作.

解决方案

我喜欢 SQuirreL SQL Client，并且NetBeans 是 非常有用；但更多时候，我只是启动内置的 org.h2.tools.Server 并浏览8082端口:

<前>$ java -cp/opt/h2/bin/h2.jar org.h2.tools.Server -help启动 H2 Console (web-) 服务器、TCP 和 PG 服务器.用法:java org.h2.tools.Server在不带选项的情况下运行时，会启动 -tcp、-web、-browser 和 -pg.选项区分大小写.支持的选项有:[-help] 或 [-?] 打印选项列表[-web] 使用 H2 Console 启动 web 服务器[-webAllowOthers] 允许其他计算机连接 - 见下文[-webPort] 端口(默认:8082)[-webSSL] 使用加密 (HTTPS) 连接[-browser] 启动浏览器并打开一个页面连接到网络服务器[-tcp​​] 启动 TCP 服务器[-tcp​​AllowOthers] 允许其他计算机连接 - 见下文[-tcp​​Port] 端口(默认:9092)[-tcp​​SSL] 使用加密 (SSL) 连接[-tcp​​Password ] 关闭 TCP 服务器的密码[-tcp​​Shutdown ""] 停止 TCP 服务器；示例:tcp://localhost:9094[-tcp​​ShutdownForce] 不要等到所有连接都关闭[-pg] 启动PG服务器[-pgAllowOthers] 允许其他计算机连接 - 见下文[-pgPort ] 端口(默认:5435)[-baseDir ] H2 数据库的基目录；对于所有服务器[-ifExists] 只能打开现有的数据库；对于所有服务器[-trace] 打印附加跟踪信息；对于所有服务器

How to use H2 database's integrated managment frontend?

For operations such as create table, alter table, add column, and so on.

解决方案

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

这篇关于管理H2数据库的前端工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！