2016-05-26 12:02 GMT+02:00 Philipp Middendorf <[email protected]>:
> Hi Lukas, > > thanks for the incredibly fast reply! Since we're using H2 only for > testing purposes, I tried the latest git version and indeed, there's > "timestamp with time zone" available. However, the javadoc for the time > parsing function in h2 states: > > >> Parse a time string. The format is: [-]hour:minute:second[.nanos] ... >> > > And jooq tries to pass, for instance, '1987-08-21T00:00Z', so I get the > error: > I have to say here that JSR 310 support and TIMESTAMP WITH TIME ZONE support is still experimental in jOOQ as well. Unfortunately, the JDBC spec isn't exactly encouraging in this area, and the drivers have hardly yet implemented these features, so we're a bit lost right now. In the case of H2, we'll wait until the feature is no longer experimental before settling for an official out of the box data type binding. For instance, I'm surprised that the time format allows the minus sign, given that TIME is a strictly "positive" value (as opposed to, e.g., INTERVAL) > org.jooq.exception.DataAccessException: SQL [null]; Cannot parse >> "TIMESTAMP WITH TIMEZONE" constant "1987-08-21T00:00Z"; > > > Could this be a bug in jooq, then? > Or... a missing / incomplete feature :) -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
