Stack Overflow
Stack Overflow

Questions tagged [h2db]

H2 is an open source SQL database engine written in Java. It can be embedded in Java applications or run in the client-server mode. H2 supports regular disk-based as well as in-memory databases. The disk footprint (size of the jar file) is about 1 MB.

H2 is an open source SQL database engine written in Java. It can be embedded in Java applications or run in the client-server mode. H2 supports regular disk-based as well as in-memory databases. The disk footprint (size of the jar file) is about 1 MB.

The main author of H2 is Thomas Mueller, who also developed the Java database engine Hypersonic SQL. The name H2 stands for Hypersonic 2, however H2 does not share code with Hypersonic SQL or HSQLDB.

This tag is synonym for H2 tag

Wiki

Issues

93 questions
1
vote
0 answers

Saving array in h2db through Cayenne error

I'm trying to save persistent object through Cayenne interface: ServerRuntime runtime = new ServerRuntime("cayenne.xml"); ... DataContext context = (DataContext)runtime.getContext(); ObjectWithArray owa =…
DrDecay
  • 59
  • 1
  • 10
1
vote
1 answer

H2 user-defined function is called many times

I'm using the h2 v1.3.176. I have user-defined function which execute RECURSIVE query. public static ResultSet getChildCategories(Connection connection, long categoryId) throws SQLException { String sql = "WITH RECURSIVE…
user1428896
  • 43
  • 7
1
vote
0 answers

h2 database not started using windows service

I am creating windows service using below command for H2 database :- sc create mySer_H2DB binpath= "C:\Program Files\H2\bin\h2w.bat" ( tried h2.bat also) but when i start the service from services.msc , error 1053 pops up showing message " Windows…
ammu
  • 864
  • 2
  • 13
  • 27
1
vote
1 answer

Perl modules for connecting H2db

I have an perl code where we are reading .txt files but now inspite of .txt we want to read data from H2DB database. I tried to searching out and seems that no modules are available for that . Can some one of you please help on this.
Syed
  • 19
  • 1
  • 6
0
votes
1 answer

Getting column "B" not found, while running the SQL query to create the table in the h2 db in the Springboot application

I am working on a spring-boot application. Where I have to run a set of SQL queries ("written for the MySQL DB") to create the tables when the application starts. These queries are working fine while connecting the spring-boot application with MySQL…
Ajit Kumar Singh
  • 378
  • 1
  • 8
0
votes
2 answers

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 records from the database. I have tried all the…
Madesh
  • 55
  • 7
0
votes
0 answers

org.h2.jdbc.JdbcSQLNonTransientException: IO Exception: null [90028-200]

My h2db version is h2-1.4.200. the database started few times ago,reboot the database but cannot connected! The problem is: IO Exception: null [90028-200] 90028/90028 (Help) org.h2.jdbc.JdbcSQLNonTransientException: IO Exception: null…
chunchungege1
  • 1
0
votes
1 answer

h2db - Can´t connect with different Computer

This class connects to Database via h2db. public class DatabaseServer { private final String user; private final String password; private final String database; private Connection conn = null; private Server webServer =…
JavaGuest2000
  • 1
  • 1
0
votes
0 answers

Update username & password of h2 database and restore earlier backups

The current credentials of my H2 database is very weak and I have been asked to change it to a complex one. There are so many backups (*.db files) which are already created with my old credentials. When I try to retrieve the backups with new…
learner
  • 39
  • 3
0
votes
1 answer

JdbcSQLSyntaxErrorException: Sequence "SYSTEM_SEQUENCE_*" not found

I am trying to recover an H2 database that seems corrupted by using H2 recovery script (H2 v.1.4.199, and also .197 and .200), like this: java -cp h2-1.4.200.jar org.h2.tools.RunScript -url "jdbc:h2:file:./testdb_recovered" -user test -password test…
borgmater
  • 658
  • 3
  • 11
  • 35
0
votes
1 answer

How to access H2 in memory Database during Junit Testing

Not able to access H2 database console during JUnit testing. Since the database will be up and running only when the test is running, I am trying to have a breakpoint or a sleep command to hold the test execution to access…
spatel
  • 11
  • 2
0
votes
0 answers

H2 JDBC Syntax error when executing persistent SQL commands into h2db

My appication uses Java + jOOQ + H2DB. I have created two Threads to continue execution. Thread 1: Insert records continuously into table A Thread 2: Select limit of 10000 consecutive records from table A When I run my application, sometimes the…
ThanLee
  • 1
  • 2
0
votes
1 answer

H2DB mixed mode, client gets empty query

I'm trying to build some kind of Unit test for DB connection. First I'm creating a new connection and new table , populate it and then check if the data exists, all good at this point. than a client create a new connection and tries to get the same…
user3102144
  • 35
  • 4
0
votes
0 answers

Importing data to h2db

I have .sql files that have only insert statements. While importing those to the already exists h2db.mv.db(Version 1.4.192) file I am getting the below error Exception in thread "main" org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique…
Shubham kapoor
  • 394
  • 3
  • 18
0
votes
1 answer

@Cacheable with in memory database?

Is it relevant to use @Cacheable with in memory database ? I am using h2 in memory database and just wondering that use of @Cacheable can improve the performance of application. My application will have frequent get calls for the static data from…
Datta Diware
  • 602
  • 1
  • 5
  • 16
1 2 3
4
5 6 7