Hi, Yes, their v2 broke several things like the alias support is only enabled in mode (PG, mysql, ...) and not with the old system props, some new keywords were added (value for ex) etc...so I assume we need to do a H22Dictionary (i don't like this name but hope you got it ;)).
What is highly probable is that we don't generate a statement which is compatible with this new version so table are actually not created and the error is lazily reported instead of early. Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book <https://www.packtpub.com/application-development/java-ee-8-high-performance> Le jeu. 9 déc. 2021 à 18:51, Maxim Solodovnik <solomax...@gmail.com> a écrit : > 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 >
