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.JdbcSQLNonTransientConnectionException: Unsupported
connection setting "NON_KEYWORDS" [90113-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:622)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.engine.ConnectionInfo.readSettingsFromURL(ConnectionInfo.java:269)
at org.h2.engine.ConnectionInfo.<init>(ConnectionInfo.java:78)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:152)
at org.h2.Driver.connect(Driver.java:69)
You need to use some modern version of H2 on client side too.
Indeed, it was the IDE which held onto H2 1.4.200, after a clean rebuild
the correct version is picked up.
I start H2 over TCP with this:
java -cp /opt/h2-2.1.214/bin/h2-2.1.214.jar org.h2.tools.Server
-baseDir $HOME/my_db -ifNotExists -tcp -tcpAllowOthers -tcpPort 9092
1>my_db.log 2>&1
Documentation of H2 has clear warning about combination of -ifNotExists
with -tcpAllowOthers, this combination of settings effectively creates a
remote security hole on you system unless your ports are guarded somehow.
https://h2database.com/html/tutorial.html#creating_new_databases
Thanks again, I skimmed the documentation, was not aware of it; corrected
it now.
Regards,
--
Carlo
--
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/656fb392-1ff6-425d-b072-41c6dea2a6e3n%40googlegroups.com.
