Kevin Wooten

@YikSanChan Those use H2 database with some Spring Boot magic to autowire that db. I tinkered for 5 minutes but don't know how to replace the H2 magic. Get me...

@YikSanChan I created a PR for to your repository that switches to this driver. `./mvnw spring-boot:run` completes successfuly.

http://impossibl.github.io/pgjdbc-ng/docs/current/user-guide/#extensions-notifications

@mickaeltr Can you look at @YikSanChan's repository and my PR against it to see if that solves your problems with Spring Boot? (they are very simple). If that is the...

**A1)** The default "SCHEMA" in PostgreSQL is "not a thing"... it has something called `search_path`, a list of schemas to search (like a unix shell's `PATH` variable). It defaults to...

@mickaeltr It seems I responded having completely missed your error regarding timestamps... need my coffee before responding next time. That's an error raised by Hibernate. With the provided information this...

FYI, `Instant` ***is not supported*** by JDBC at all. The types to use are `OffsetDateTime` for `TIMESTAMP_WITH_TIMEZONE` and `LocalDateTime` for `TIMESTAMP`. If Hibernate supports `Instant` they seem to have fallen...

@mickaeltr @davecramer As demonstrated [here](https://github.com/kdubb/gs-accessing-data-jpa) using Java 8's time/date classes Hibernate naturally supports `TIMESTAMP_WITH_TIMEZONE` as long as your field is an `OffsetDateTime`; no configuration necessary.

@YikSanChan I simplified the changes to the `application.properties` even further (the PR against your repository is updated). Essentially we just need to set the following properties: ```properties spring.datasource.driver-class-name=com.impossibl.postgres.jdbc.PGDriver spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true ```...

@mickaeltr Do you have a small project you can publish that demonstrates the issue related to the schema. The basic project [here](/kdubb/gs-accessing-data-jpa) doesn't have any issues with the schema so...