database - encrypt - Herramienta frontend para gestionar la base de datos H2

h2 database viewer

Question

¿Cómo usar la interfaz de gestión integrada de la base de datos H2 ?

Para operaciones como crear tabla, modificar tabla, agregar columna, etc.

Answer 1

¿Qué hay de la aplicación de la consola H2 ?

Answer 2

Me gustaría sugerir DBEAVER .it se basa en eclipse y admite un mejor manejo de datos

Answer 3

No lo he usado, pero RazorSQL looks bastante bien.

Answer 4

Si lo está ejecutando como una base de datos incrustada en la primavera, utilizo la siguiente configuración para habilitar el cliente web incorporado cuando se está ejecutando la aplicación principal:

<!-- Run H2 web server within application that will access the same in-memory database -->
<bean id="h2Server" class="org.h2.tools.Server" factory-method="createTcpServer" init-method="start" destroy-method="stop" depends-on="h2WebServer">
    <constructor-arg value="-tcp,-tcpAllowOthers,-tcpPort,9092"/>
</bean>
<bean id="h2WebServer" class="org.h2.tools.Server" factory-method="createWebServer" init-method="start" destroy-method="stop">
    <constructor-arg value="-web,-webAllowOthers,-webPort,8082"/>
</bean>

Answer 5

Sugeriría el IDE de Jetbrain: DataGrip https://www.jetbrains.com/datagrip/

Answer 6

También hay un cliente shell incorporado que es útil.

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 <options>
Options are case sensitive. Supported options are:
[-help] or [-?]        Print the list of options
[-url "<url>"]         The database URL (jdbc:h2:...)
[-user <user>]         The user name
[-password <pwd>]      The password
[-driver <class>]      The JDBC driver class to use (not required in most cases)
[-sql "<statements>"]  Execute the SQL statements and exit
[-properties "<dir>"]  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

Answer 7

Uso sql-workbench para trabajar con H2 y cualquier otro DBMS con el que tenga que lidiar y me hace sonreír :-)

Answer 8

Utilizo mucho DbVisualizer para la administración de H2-db.

Existe una versión gratuita:

https://www.dbvis.com/download/

Answer 9

una discusión encontrada here

cita de 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/

Answer 10

Me gusta SQuirreL SQL Client , y NetBeans es útil incluso sin el buen plugin , discutido here ; pero más a menudo, simplemente org.h2.tools.Server y org.h2.tools.Server puerto 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