h2 « hsqldb « Java Database Q&A

1. Which is better H2 or HSQLDB?    stackoverflow.com

HSQLDB 2.0 is soon to be released. I wonder if it will outperform H2 since, as far as I know, most users prefer H2 than HSQLDB. I am interested in the ...

2. How to integrate HSQL DB with java application    stackoverflow.com

I would like to integrate HSQL in my Java application for testing purposes. Is there any tutorial that describes in a simple way how to integrate it-I want to distribute it ...

3. SequenceGenerator problem with unit testing in Hsqldb/H2    stackoverflow.com

I have tried using both Hsqldb and H2 for unit testing but facing problem with sequence generators. Field declaration looks like this.

@Id @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="keyword_seq")
@SequenceGenerator(name="keyword_seq",sequenceName="KEYWORD_ID_SEQ", allocationSize=1)
@Column(name="IM_KEYWORD_ID")
private Long keywordId;