SET LOG_SIZE new_size

Class.forName("org.hsqldb.jdbcDriver").newInstance();

Connection connexion = DriverManager.getConnection("jdbc:hsqldb:file:database", "sa",  "");

Connection connexion = DriverManager.getConnection("jdbc:hsqldb:mem:database", "sa",  "");

Statement statement = connexion.createStatement();
statement.executeQuery("SHUTDOWN");
statement.close();

connexion.close() ;

Statement statement = connexion.createStatement() ;
statement.executeUpdate("CREATE TABLE test (" + 
	"colonne1 INT , colonne2 INT"
)");

CREATE TABLE test(
	Colonne1 INT,
	Colonne2 INT,
	CONSTRAINT Colonne3 PRIMARY KEY(Colonne1, Colonne2)
)

CREATE TABLE test(
	Colonne1 INT,
	Colonne2 INT,
	INDEX(Colonne1)
)

CREATE TABLE test(
	Colonne1 INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) PRIMARY KEY,
	Colonne2 INT,
)

CREATE TABLE tests(
	test_id INT PRIMARY KEY,
	test_nom VARCHAR(100)
)

CREATE TABLE others(
	test_id INT PRIMARY KEY,
	other_nom VARCHAR(100),
	FOREIGN KEY(test_id) REFERENCES tests (test_id)
)

Statement  statement = connexion.createStatement();
ResultSet resultat = statement.executeQuery("SELECT * FROM table WHERE condition");

while(resultat.next()){
	System.out.println(resultat.getXXX("colonne")) ;
}

Statement statement = connexion.createStatement() ;
statement.executeUpdate("INSERT INTO note (nom) VALUES ('Nul')");