[h2] Re: Is there a way to quote columns ?

Dear Evgenij On Sunday, July 2, 2023 at 6:10:28 PM UTC+2 Evgenij Ryazanov wrote: With H2 version *2.1.214* and the JDBC URL *jdbc:h2:tcp://localhost/MY_DB;AUTO_SERVER=TRUE;IGNORECASE=TRUE;NON_KEYWORDS=INTERVAL,VALUES* I get this Exception: Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionE

[h2] Re: Is there a way to quote columns ?

With H2 version *2.1.214* and the JDBC URL *jdbc:h2:tcp://localhost/MY_DB;AUTO_SERVER=TRUE;IGNORECASE=TRUE;NON_KEYWORDS=INTERVAL,VALUES* I get this Exception: Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported connection setting "NON_KEYWORDS" [90113-200] at org.h2.mess

[h2] Re: Is there a way to quote columns ?

Thanks, Evgenij With H2 version *2.1.214* and the JDBC URL *jdbc:h2:tcp://localhost/MY_DB;AUTO_SERVER=TRUE;IGNORECASE=TRUE;NON_KEYWORDS=INTERVAL,VALUES* I get this Exception: Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported connection setting "NON_KEYWORDS" [90113-200

[h2] Re: Is there a way to quote columns ?

Hello! You need to quote column names in your application, there is nothing to do on H2 side. If you use Hibernate ORM, you can force quotation of all identifiers with hibernate.globally_quoted_identifiers setting. In the worst case you can add ;NON_KEYWORDS=INTERVAL to JDBC URL, but this sett