https://github.com/apache/openjpa/pull/91 :)
On Fri, 10 Dec 2021 at 01:34, Romain Manni-Bucau <rmannibu...@gmail.com> wrote: > 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 > > > -- Best regards, Maxim
