Skip to content

Instantly share code, notes, and snippets.

@stephankoelle

stephankoelle/H2ServerStarter.java

Created June 17, 2025 09:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save stephankoelle/84b6fc216b53eeda222d62eb37937c24 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save stephankoelle/84b6fc216b53eeda222d62eb37937c24 to your computer and use it in GitHub Desktop.
Download ZIP
Start h2 server in a quarkus app, to connect also from a SQL tool (for example intellij) to the dev database
Raw
H2ServerStarter.java
import io.quarkus.runtime.ShutdownEvent;
import io.quarkus.runtime.StartupEvent;
import jakarta.inject.Inject;
import org.h2.tools.Server;
import jakarta.enterprise.context.ApplicationScoped;
import jakarta.enterprise.event.Observes;
import org.jboss.logging.Logger;
import java.sql.SQLException;
@ApplicationScoped
public class H2ServerStarter {
private Server server;
@Inject
Logger log;
void onStart(@Observes StartupEvent ev) {
try {
if (server == null || !server.isRunning(false)) {
server = Server.createTcpServer("-tcpAllowOthers", "-tcpPort", "9092").start();
log.info("H2 server started on port 9092.");
} else {
log.info("H2 server is already running on port 9092.");
}
} catch (SQLException e) {
throw new RuntimeException("Failed to start H2 server.", e);
}
}
void onStop(@Observes ShutdownEvent ev) {
if (server != null && server.isRunning(false)) {
server.stop();
log.info("H2 server stopped.");
}
}
}
Raw
info
connect to:
jdbc:h2:tcp://localhost:9092/file:/ ... FULL path ..../data/flow-deploy-app
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment