Tutorial: Learn how to access H2 Database console from a browser. 🤔

				
					package com.thospfuller

/**
 * Tutorial regarding how to configure the H2 Database web server programmatically.
 *
 * Note that if we don't use the systemClassLoader we'll get the following exception:
 *
 *   java.sql.SQLException: No suitable driver found for jdbc:h2:mem:example-db
 */
@GrabConfig(systemClassLoader=true)

@Grapes(
  @Grab(group='com.h2database', module='h2', version='2.3.232')
)
import java.sql.DriverManager
import org.h2.tools.Server

def connection = DriverManager.getConnection("jdbc:h2:mem:example-db", "sa", "sa")

/* webPort        : H2 console port, set to 19999 for this example.
 *
 * webSSL         : HTTPS connections.
 */
def server = Server.createWebServer("-webPort", "19999", "-webSSL").start()

def url = server.getURL ()

def minutes = 60L

println "Server URL: ${url}, will sleep for $minutes minutes."

Server.openBrowser (url)

try {
  Thread.currentThread ().sleep (1000 * 60 * minutes)
} catch (InterruptedException interruptedException) {
  interruptedException.printStackTrace (System.err)
} finally {
  connection.close ()
  server.stop ()
}

println "...done!"

return