Re: Regression in 42.2.0? "The server''s DateStyle parameter was changed to ISO. The JDBC driver requires DateStyle to begin with ISO for correct operation. "

42.1.1 will address this. The release is imminent.

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 22 January 2018 at 10:29, Stefan Tzeggai <tzeggai(at)empirica-systeme(dot)de>
wrote:

> I upgraded the JDBC driver today from 42.1.4 to 42.2.0
>
> and I get the following error:
>
> "The server''s DateStyle parameter was changed to ISO. The JDBC driver
> requires DateStyle to begin with ISO for correct operation. "
>
> It connects to a pgbouncer that has been running with JDBC 42.1.4
> without problems.
>
> I debugged into QueryExecutorImpl
>
> > if (name.equals("DateStyle") && !value.startsWith("ISO,")) {
> > close(); // we're screwed now; we can't trust any subsequent date.
> > throw new PSQLException(GT.tr(
> > "The server''s DateStyle parameter was changed to {0}. The
> JDBC driver requires DateStyle to begin with ISO for correct operation.",
> > value), PSQLState.CONNECTION_FAILURE);
> > }
>
> When it throws the exception value is "ISO" but it is checked for
> startsWith("ISO,")
>
> Might that be a bug? Maybe you want a regex here to check for a
> word-break instead of a comma?!
>
> Steve
>
>