Re: java8 time API support

2019-01-23 Thread Romain Manni-Bucau
Le mer. 23 janv. 2019 à 10:29, Mark Struberg a écrit : > Txs Romain! > > Found a bit more info. > > There is a new Type in Java8 java.sql.Types.TIME_WITH_TIMEZONE even. > > Seems like a few databases do support timezones in the date, others don't > > Oracle: TIMESTAMP WITH TIME ZONE -> stores the

Re: java8 time API support

2019-01-23 Thread Mark Struberg
Txs Romain! Found a bit more info. There is a new Type in Java8 java.sql.Types.TIME_WITH_TIMEZONE even. Seems like a few databases do support timezones in the date, others don't Oracle: TIMESTAMP WITH TIME ZONE -> stores the tst + the timezone in the DB in a bijective way PostgreSQL: TIME WITH

Re: java8 time API support

2019-01-22 Thread Romain Manni-Bucau
pg has "with time zone" option like "time with time zone" now I wonder if the dictionnary shouldn't get the config of the default timezone and if we dont have a type with tz then we convert in the default timezone so if i want to store a CEST time and default is UTC then the next select will get it

Re: java8 time API support

2019-01-22 Thread Mark Struberg
The OpenJPA internal 'infrastructure' is now ready. The problem arises about how to store OffsetTime and OffsetDateTime in the DB though. My first implementation now converts it to the default TZ and uses java.sql.Date to store it. This results in the correct time being stored to the db, but of

Re: java8 time API support

2019-01-21 Thread Maxim Solodovnik
Thanks for that, will try to test LocalDate support in our project later this week :) On Tue, 22 Jan 2019 at 00:00, Francesco Chicchiriccò wrote: > On 21/01/19 16:07, Romain Manni-Bucau wrote: > > +1000 to make it part of the dictionary, makes way more sense IMHO > > +1001 then, I also think it'

Re: java8 time API support

2019-01-21 Thread Francesco Chicchiriccò
On 21/01/19 16:07, Romain Manni-Bucau wrote: +1000 to make it part of the dictionary, makes way more sense IMHO +1001 then, I also think it's better :-) Thanks Mark! Regards. Le lun. 21 janv. 2019 à 15:53, Mark Struberg a écrit : hi folks! Over the last few days I started to implement the

Re: java8 time API support

2019-01-21 Thread Romain Manni-Bucau
+1000 to make it part of the dictionary, makes way more sense IMHO Romain Manni-Bucau @rmannibucau | Blog | Old Blog | Github | LinkedIn