View content of H2 or HSQLDB in-memory database

by

You can run H2 web server within your application that will access the same in-memory database. You can also access the H2 running in server mode using any generic JDBC client like SquirrelSQL.

UPDATE:

Server webServer = Server.createWebServer("-web,-webAllowOthers,true,-webPort,8082").start();
Server server = Server.createTcpServer("-tcp,-tcpAllowOthers,true,-tcpPort,9092").start();

Now you can connect to your database via jdbc:h2:mem:foo_db URL within the same process or browse the foo_db database using localhost:8082. Remember to close both servers. See also: H2 database in memory mode cannot be accessed by Console.

You can also use Spring:

<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,true,-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,true,-webPort,8082"/>
</bean>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" depends-on="h2Server">
    <property name="driverClass" value="org.h2.Driver"/>
    <property name="jdbcUrl" value="jdbc:h2:mem:foo_db"/>
</bean>

BTW you should only depend on assertions and not on manual peeking the database contents. Use this only for troubleshooting.

N.B. if you use Spring test framework you won’t see changes made by a running transaction and this transaction will be rolled back immediately after the test.

More Related Contents:

  1. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  2. H2 in-memory database. Table not found
  3. How to access in memory h2 database of one spring boot application from another spring boot application
  4. Spring Boot default H2 jdbc connection (and H2 console)
  5. Frontend tool to manage H2 database [closed]
  6. How to find rows in one table that have no corresponding row in another table
  7. is there a standard way to define a JDBC Datasource for Java EE containers?
  8. How to see all the tables in an HSQLDB database?
  9. SQL query that gives distinct results that match multiple columns
  10. Huge performance difference when using GROUP BY vs DISTINCT
  11. Populate JFreechart TimeSeriesCollection from Mysql DB?
  12. Can I have H2 autocreate a schema in an in-memory database?
  13. Connect to H2 database using IntelliJ database client
  14. Embedding the Java h2 database programmatically
  15. How to map a JSON column with H2, JPA, and Hibernate
  16. How in H2DB get sql dump like in MySql?
  17. Executing script file in h2 database
  18. H2 database error: Database may be already in use: “Locked by another process”
  19. Timeout error trying to lock table in h2
  20. Unsuccessful: alter table XXX drop constraint YYY in Hibernate/JPA/HSQLDB standalone
  21. H2 Database vs SQLite on Android [closed]

Leave a Comment