Hello All,
today I've noticed new version of h2: 2.0.202
After upgrading to this version all tests are broken :(((
First issue is caused by the URL "jdbc:h2:./omdb;create=true"
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL
statement "*SET CREATE[*] TRUE*"; expected "@, AUTOCOMMIT, EXCLUSIVE,
IGNORECASE, PASSWORD, SALT, MODE, DATABASE, COLLATION, CLUSTER,
DATABASE_EVENT_LISTENER, ALLOW_LITERALS, DEFAULT_TABLE_TYPE, SCHEMA,
CATALOG, SCHEMA_SEARCH_PATH, JAVA_OBJECT_SERIALIZER, IGNORE_CATALOGS,
SESSION, TRANSACTION, TIME, NON_KEYWORDS, DEFAULT_NULL_ORDERING, LOG"; SQL
statement:
SET CREATE true [42001-202]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.getSyntaxError(DbException.java:261)
After URL modification:
"jdbc:h2:./omdb;create=true" -> "jdbc:h2:./omdb"
AND fixing the list of H2 reserved words
I'm getting errors like "TABLE XXXX doesn't exist"
so ";create=true" seems to be necessary :)))
Can you please point me out where to dig? :)))
--
Best regards,
Maxim
