Re: "could not determine data type of parameter" with timestamp

Поиск

Список

Период

Сортировка

От	Vladimir Sitnikov
Тема	Re: "could not determine data type of parameter" with timestamp
Дата	29 марта 2018 г. 16:42:17
Msg-id	CAB=Je-HnDSWsmHLy6U5dsaajv8JBWDDX7mz40vvDBkfE5ToN-w@mail.gmail.com обсуждение исходный текст
Ответ на	Re: "could not determine data type of parameter" with timestamp (Rémi Aubel <remi.aubel@gmail.com>)
Список	pgsql-jdbc

Vladimir> pgjdbc just passes "unknown type" formatted as full timestamp

Vladimir>That backfires for the case "select ?" when backend has no way to tell what was the "expected bind type"

It might be the case the proper solution is something around

setObject(int parameterIndex, Object x, SQLType targetSqlType)

and

setObject(int parameterIndex, Object x, SQLType targetSqlType,
         int scaleOrLength)

Of course, those methods just throw "not implemented", however setObject(..., SQLType.TIMESTAMP) might be the way.

Vladimir

В списке pgsql-jdbc по дате отправления: