Re: Literal vs parameterized 'timestamp with time zone' value

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Literal vs parameterized 'timestamp with time zone' value
Дата
Msg-id 1427B806-A828-403C-957B-FCF991BB016B@fastcrypt.com
обсуждение исходный текст
Ответ на Re: Literal vs parameterized 'timestamp with time zone' value  (Christopher Hunt <huntc@internode.on.net>)
Ответы Re: Literal vs parameterized 'timestamp with time zone' value  (Christopher Hunt <huntc@internode.on.net>)
Список pgsql-jdbc
Christopher,

Use a  more recent jar. There is a problem with the spec, and
postgresql. The spec does not have two different timestamps. In
previous versions we bound the type to timestamp without timezone. In
more recent versions we bind it to 'unknown' which allows the server
to decide.

If this fails then appending ?protocolVersion=2 will work, however
you won't be server side prepared statements.

Dave
On 18-Jun-07, at 8:59 AM, Christopher Hunt wrote:

> Thanks for responding.
>
> Alas, I have tried setTimestamp - in fact I started with that and
> ended up with a similar problem i.e. no rows returned with
> setTimestamp. I think that my problem is something else.
>
> The client and server processes are on the same machine.
>
> Any more ideas?
>
> Cheers,
> -C
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org


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

Предыдущее
От: Christopher Hunt
Дата:
Сообщение: Re: Literal vs parameterized 'timestamp with time zone' value
Следующее
От: Christopher Hunt
Дата:
Сообщение: Re: Literal vs parameterized 'timestamp with time zone' value