h2 – Page 5 – Tarik Billa

H2 database error: Database may be already in use: “Locked by another process”

March 28, 2023 by Tarik

H2 is still running (I can guarantee it). You need to use a TCP connection for multiple users such as -> <property name=”javax.persistence.jdbc.url” value=”jdbc:h2:tcp://localhost/C:\Database\Data\production;”/> OR DriverManager.getConnection(“jdbc:h2:tcp://localhost/server~/dbname”,”username”,”password”); It also means you need to start the server in TCP mode. Honesetly, it is pretty straight forward in the documentation. Force kill the process (javaw.exe for Windows), and … Read more

H2-Console is not showing in browser

March 27, 2023 by Tarik

add this two lines in your spring security file and you are good to go. http.csrf().disable(); http.headers().frameOptions().disable();

Executing script file in h2 database

February 23, 2023 by Tarik

You can use the RUNSCRIPT SQL statement: RUNSCRIPT FROM ‘test.sql’ or you can use the RunScript standalone / command line tool: java -cp h2*.jar org.h2.tools.RunScript -url jdbc:h2:~/test -script test.sql You can also use the RunScript tool within an application: RunScript.execute(conn, new FileReader(“test.sql”));

How in H2DB get sql dump like in MySql?

February 19, 2023 by Tarik

Yes, there are multiple solutions. One is to run the SCRIPT SQL statement: SCRIPT TO ‘fileName’ Another is to use the Script tool: java org.h2.tools.Script -url <url> -user <user> -password <password> Then, there are also the RUNSCRIPT statement and RunScript tool. By the way, you should consider upgrading to a more recent version of H2. … Read more

How to find rows in one table that have no corresponding row in another table

February 15, 2023 by Tarik

select tableA.id from tableA left outer join tableB on (tableA.id = tableB.id) where tableB.id is null order by tableA.id desc If your db knows how to do index intersections, this will only touch the primary key index

How to configure spring-boot to use file based H2 database

February 8, 2023 by Tarik

I am adding this answer to avoid confusion and further research. Actually I have the same problem and none of the answer worked for me completely rather than the mix for some answers worked. Here is the minimal configuration which is required to persist H2 db in spring boot. application.properties # H2 spring.h2.console.enabled=true spring.h2.console.path=/h2 # … Read more

Connect to H2 database using IntelliJ database client

January 31, 2023 by Tarik

Your configuration is for an h2:mem database. Memory Databases have no tables upon connecting to them, and any & all tables are lost when all the connections are closed. Furthermore, a (named) in memory database is unique to the JVM process that opens it. From the H2 documentation: Sometimes multiple connections to the same in-memory … Read more

Which is better H2 or HSQLDB? [closed]

January 19, 2023 by Tarik

Please note I had provided this answer in 2011. It may be outdated My company develops a database abstraction library (jOOQ), which supports both databases. Our integration tests cover a lot of functionality, including the calling of stored procedures and functions, arrays, nested selects, etc. I experience HSQLDB 2.1 to be slightly faster than H2 … Read more

View content of H2 or HSQLDB in-memory database

January 17, 2023 by Tarik

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 … Read more

Frontend tool to manage H2 database [closed]

January 6, 2023 by Tarik

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 … Read more