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.
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
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/d44ce858-8fb4-4f5d-bdb3-948a638c93d6n%40googlegroups.com.
