python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - h2db

Using xml-functions in h2 database for university project

For my university-project I installed an h2database locally on my computer. I have a little data in it and now I am trying to export parts of this data via the included xml-functions that h2 offers. H...
test-img

Yannick251

java

sql

xml

h2

h2db

Votes: 0

Answers: 1

Latest Answer

I fixed it! Here is a good example of how to use it: https://github.com/h2database/h2database/blob/master/h2/src/test/org/h2/samples/newsfeed.sql CREATE TABLE VERSION(ID INT PRIMARY KEY, VERSION VARCH...
test-img

Yannick251

Why the H2 database file size growing more than the data size

I have a h2 database file and the file size has grown to 5GB. I have deleted some of data to reduced the size of the file. But the file size still remains the same even after deleting the half of the ...
test-img

Madesh

java

hibernate

h2

filesize

h2db

Votes: 0

Answers: 2

Latest Answer

Because data file is not reduced when you eg delete some records from the database. This is due to performance reasons. So h2 will either replace byte block in a file or append new one, but will not r...
test-img

Antoniossss

Saving large files in h2 database

I recently updated the h2 database in my springboot project to 2.1.210. This induced some problems, most of them I was able to fix myself. The one that I can't fix is about saving large files in the d...
test-img

Bjonic

h2db

Votes: 0

Answers: 1

Latest Answer

It looks like, since H2 version 2, the org.h2.value.Value.getBytes() method has changed significantly so as to limit the amount that can be held in memory in a byte array. The H2 manual (data types an...
test-img

ATG

H2 DB multipole connections in AWS EFS using AWS Lambda

I have been struggling to find a solution for below use case for H2 database I have an H2 db file This file has been kept in AWS EFS This is because two lambda functions can access this DB file con...
test-img

Atul

aws-lambda

amazon-efs

h2db

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs