Skip to content

Instantly share code, notes, and snippets.

@ufuk

ufuk/hsqldb-with-postgresql-syntax.properties

Last active December 29, 2022 11:55
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ufuk/1e37fe3dfc5293704a9f9170e10a934e to your computer and use it in GitHub Desktop.
Save ufuk/1e37fe3dfc5293704a9f9170e10a934e to your computer and use it in GitHub Desktop.
Download ZIP
To use HSQLDB with PostgreSQL syntax add ";sql.syntax_pgs=true" to end of the JDBC URL. Alternatively use ";sql.syntax_ora=true" for Oracle.
Raw
hsqldb-with-postgresql-syntax.properties
spring.datasource.url=jdbc:hsqldb:mem:testdb;sql.syntax_pgs=true
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment