Database Engine built in Java.

learn more… | top users | synonyms

0
votes
1answer
984 views

H2 ALTER TABLE ADD COLUMN BEFORE/AFTER

According to H2 syntax documentation available here I should be able to execute a query like: ALTER TABLE EMPLOYEE ADD COLUMN SECOND_NAME VARCHAR (124) AFTER FIRST_NAME; However apparently only ...
1
vote
0answers
79 views

Is there a way to detect if there is an uncommitted transaction in H2?

I am using an H2 database with JDBC to create a connection with setAutoCommit(false). I am currently programatically checking whether or not there is an uncommitted transaction, but I was wondering ...
1
vote
0answers
38 views

parenthetic grouping of join clauses

What is the difference between these joins? a left join b left join c (a left join b) left join c a left join (b left join c) Does the grouping only affect the order of the joins? Will the query ...
0
votes
0answers
8 views

How to load Adabas DB CSV file in to H2 database in bulk

I have got Adabas CSV file , i can load one by one using CSVREAD functionality in to H2 database, but if it is N number of CSV files with N number of Tables in that case how load in to H2 Database ...
0
votes
0answers
32 views

Connecting remote H2 embedded database

Is there a way to connect to an H2 database, which is running in automatic mixed mode (AUTO_SERVER=TRUE) inside a web application, from another machine over SSH tunnel?
0
votes
0answers
42 views

DIRECT and SORTED in H2 and How to insert data with SORTED technique in H2

I was working on H2 Database and read Insert Statement Grammar and found that there are 2 types of insertion DIRECT and SORTED @ http://www.h2database.com/html/grammar.html#insert. As I know that ...
0
votes
0answers
132 views

H2 database binary file full of @^@^@^@^

I am investigating H2 database performance and was curious to why the database file was several megabytes long when only storing hundreds kilos of text, I therefore opened the database file with vim ...