billmccord
commented
13 years ago The issues run deeper than this. Apparently, h2 doesn't support the same syntax as SQLite for CREATE TABLE, so you are going to have problems if you try to use your tests in their current form for a real SQLite database.
Also, the SQLite Java implementation I'm using also doesn't support in-memory writing, so all of the tests fail now because it tries to CREATE TABLE table_name in the setup of each test, but doesn't DROP TABLE table_name anywhere and therefore fails because it is trying to create the same table over and over...
I am trying to use your code with SQLite, but the tests are failing because in the CREATE TABLE statement on line 32 of SQLiteDatabaseTest you are using AUTO_INCREMENT instead of AUTOINCREMENT. Also, SQLite doesn't like INT instead of INTEGER.
Since you said you planned to support configuring between different databases, I thought you might want to know.
i.e. statement.execute("CREATE TABLE table_name (id INT PRIMARY KEY AUTO_INCREMENT, first_column VARCHAR(255), second_column BINARY, name VARCHAR(255));");
should be: statement.execute("CREATE TABLE table_name (id INTEGER PRIMARY KEY AUTOINCREMENT, first_column VARCHAR(255), second_column BINARY, name VARCHAR(255));");