>> As far as I know there wasn't any specific time-related problem with the org.postgresql:postrgresql driver. I'm not sure we run tests against pgjdbc, that might be something to consider. > Please do run your tests against that.
My bad, we do run our tests against that. I confused it with pgjdbc-ng. So, yeah, pgjdbc works just fine. Yoann Rodière Hibernate Team yo...@hibernate.org On Mon, 13 Jan 2020 at 17:14, Dave Cramer <davecra...@gmail.com> wrote: > > Dave Cramer > > > On Mon, 13 Jan 2020 at 11:10, Yoann Rodiere <yo...@hibernate.org> wrote: > >> Hi, >> >> As far as I know there wasn't any specific time-related problem with the >> org.postgresql:postrgresql driver. I'm not sure we run tests against >> pgjdbc, that might be something to consider. >> > > Please do run your tests against that. > > One thing I noted was that you were not using the native interval type for > intervals. > > >> The problems were mainly with MariaDB/MySQL/Sybase drivers, and we >> upgraded our dependencies since then, so they may behave better now. >> >> In any case, most of the problems come from the conversion to javax.sql >> types and the rendering of these types by the JDBC drivers. If we can pass >> the java.time types to the drivers directly, that would indeed solve lots >> of problems. That would mean losing support for older versions of those >> drivers when it comes to java.time, but maybe it's not a big deal? >> >> Always a tough call, In my experience guaranteed to annoy at least half > of the users. > > Dave > >> >> On Mon, 13 Jan 2020 at 14:30, Dave Cramer <davecra...@gmail.com> wrote: >> >>> Hi Steve, >>> >>> I'm not sure there is a better way to store the data in the database. >>> Doing >>> any kind of date/time math in anything else but UTC seems fraught with >>> danger. >>> >>> >>> See below as to how we handle Java 8 types. >>> >>> https://github.com/pgjdbc/pgjdbc/blob/db228a4ffd8b356a9028363b35b0eb9055ea53f0/pgjdbc/src/main/java/org/postgresql/jdbc/PgPreparedStatement.java#L961-L968 >>> >>> Also tells you which driver I maintain. >>> >>> As far as my interest in this discussion goes. What is the pgjdbc driver >>> doing that is not consistent with what hibernate is doing/wants ? >>> >>> I'd certainly be up for a hibernate compatibility mode. >>> >>> Thanks, >>> >>> Dave Cramer >>> >>> >>> On Sun, 12 Jan 2020 at 23:36, Steve Ebersole <st...@hibernate.org> >>> wrote: >>> >>> > Hi Dave. >>> > >>> > Same - I was swamped with stuff at the end of last week. >>> > >>> > Yes, from what I was reading postgres is a bit strange in storing >>> temporal >>> > values. Not unique to postgres - many databases do interesting things. >>> > >>> > I'm curious how the driver handles binding Java 8 types directly. The >>> > JDBC spec was updated to support these types through the generic >>> > `#setObject` methods (`#getObject` as well?). Does the driver handle >>> this. >>> > >>> > Out of curiosity, which jdbc driver are you helping with? >>> > >>> > >>> > >>> > On Thu, Jan 9, 2020 at 10:23 AM Dave Cramer <davecra...@gmail.com> >>> wrote: >>> > >>> >> Hi, >>> >> >>> >> As one of the maintainers of the postgres jdbc driver I am interested >>> in >>> >> this discussion. >>> >> Postgres only stores date/times in UTC. Everything else is a >>> translation. >>> >> The driver uses the client's timezone for all dates/times (for better >>> or >>> >> worse) If there is anything I can do to help make things easier, let >>> me >>> >> know. >>> >> >>> >> >>> >> >>> >> -- >>> >> Sent from: http://hibernate-development.74578.x6.nabble.com/ >>> >> _______________________________________________ >>> >> hibernate-dev mailing list >>> >> hibernate-dev@lists.jboss.org >>> >> https://lists.jboss.org/mailman/listinfo/hibernate-dev >>> >> >>> >> >>> _______________________________________________ >>> hibernate-dev mailing list >>> hibernate-dev@lists.jboss.org >>> https://lists.jboss.org/mailman/listinfo/hibernate-dev >>> >>> _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev