Thank you Evgenij, Adding the following properties definitely helped:
properties.setProperty("MODE",
"PostgreSQL");properties.setProperty("DATABASE_TO_LOWER", "TRUE");
properties.setProperty("NON_KEYWORDS", "KEY,VALUE");
properties.setProperty("DEFAULT_NULL_ORDERING", "HIGH");
I am able to create a new database and load my schema :-)
I have a new issue in my code related to connection pooling but I'll save that
for a new thread if I can't figure it out.
Thanks Again,Peter
On Wednesday, August 30, 2023 at 08:25:25 PM EDT, Evgenij Ryazanov
wrote:
Hello.
In modern versions of the SQL Standard KEY is really a non-reserved word, but
it was a mistake to exclude it from the list of reserved words, because in some
contexts you still cannot use it as identifier, even the SQL Standard itself
has at least one such documented exclusion appeared in ISO/IEC 9075-2:2016
TECHNICAL CORRIGENDUM 2.
Definition of your table also has a VALUE column, but VALUE is a reserved word
in the SQL Standard and it is a keyword in H2.
If you cannot rename these columns, you can add `;NON_KEYWORDS=KEY,VALUE` to
JDBC URL. It also should have
`;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE;DEFAULT_NULL_ORDERING=HIGH` if you
want a better compatibility with PostgreSQL. Alternatively you can pass these
settings in the map with properties.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/7756da35-d074-439e-af77-33adc7a4bbd6n%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/391768309.2471969.1693488629604%40mail.yahoo.com.