Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)
Дата
Msg-id BLU437-SMTP917E9D621FBC7BDE62E3AACFC90@phx.gbl
обсуждение исходный текст
Ответ на Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Ответы Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Список pgsql-jdbc
Actually, I don't know.

I'm using EclipseLink as layer before the database.
Since my Java classes are annotated with @Temporal(TIMESTAMP), I do
understand EclipseLink will be using getTimeStamp - but I can't tell for
sure.
Also, when looking data using "pgAdmin" timestamp data appears normal.
But if querying data using NetBeans SQL explorer or ART (reporting
tool), I get exactly same issue as with EclipseLink.
I suppose NetBeans and ART use getObject, but it is mere speculation
from my side.

As said before, since prepareThreshold=0 solved my problem, and I have a
time shortage last few months, I'll try to investigate further in near
future.
Sorry not being of great help right now.

Regards,

Atenciosamente,

Edson Carlos Ericksson Richter

Em 11/01/2016 17:50, Vladimir Sitnikov escreveu:
> Can you put more details on the APIs you use to retrieve the data?
> .getTimestamp(int)?
> .getTimestamp(int, Calendar)?
> .getString(int)?
> .getObject(int)?
> Vladimir
>
>



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

Предыдущее
От: Vladimir Sitnikov
Дата:
Сообщение: Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)
Следующее
От: Vladimir Sitnikov
Дата:
Сообщение: Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)