Home > mailing lists

Re: "could not determine data type of parameter" with timestamp - Mailing list pgsql-jdbc

From	Vladimir Sitnikov
Subject	Re: "could not determine data type of parameter" with timestamp
Date	March 29, 2018 19:42:17
Msg-id	CAB=Je-HnDSWsmHLy6U5dsaajv8JBWDDX7mz40vvDBkfE5ToN-w@mail.gmail.com Whole thread Raw
In response to	Re: "could not determine data type of parameter" with timestamp (Rémi Aubel <remi.aubel@gmail.com>)
List	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

From: Rémi Aubel
Date: 29 March 2018, 19:41:23
Subject: Re: "could not determine data type of parameter" with timestamp

From: Pavel Raiskup
Date: 15 April 2018, 00:27:31
Subject: [pgjdbc/pgjdbc] 6bb72e: packaging: fix RPM build requirements