Re: VMS x86-64 database server

On 7/6/2025 3:45 PM, Arne Vajhøj wrote:

I am using a little trick. H2 can emulate both PostgreSQL
SQL dialect and PostgreSQL network protocol.

To avoid some future frustration: it is necessary to
create the database and tables in PostgreSQL mode.
If created normal then trying to access in PostgreSQL mode
fails due to some differences in handling of case sensitivity.
So not:
$ pipe java -cp /javalib/h2-2_2_220.jar "org.h2.tools.Shell" -url "jdbc:h2:./test;FILE_LOCK=FS;" -user sa -password hemmeligt < ddl.sql
but:
$ pipe java -cp /javalib/h2-2_2_220.jar "org.h2.tools.Shell" -url "jdbc:h2:./test;FILE_LOCK=FS;MODE=PostgreSQL;DATABASE_TO_LOWER=true" -user sa -password hemmeligt < ddl.sql
Arne