[hibernate-dev] 6.0 - HQL literals

[Dave Cramer]

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 <steve at 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 <davecramer at 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 at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>
>>