Обсуждение: Regression in 42.2.0? "The server''s DateStyle parameter was changedto ISO. The JDBC driver requires DateStyle to begin with ISO for correctoperation. "

Поиск
Список
Период
Сортировка
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
forcorrect 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


42.1.1 will address this. The release is imminent.


On 22 January 2018 at 10:29, Stefan Tzeggai <tzeggai@empirica-systeme.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