JDBC Timestamp Problem - Mailing list pgsql-interfaces

From yves@asua.vlaanderen.net
Subject JDBC Timestamp Problem
Date
Msg-id 20001209144347.A19300@asua.vlaanderen.net
Whole thread Raw
Responses Re: JDBC Timestamp Problem  (Michael Stephenson <mstephenson@tirin.openworld.co.uk>)
List pgsql-interfaces
Hello,

I have a problem with timestamps and JDBC-Postgresql

It seems that the JDBC-driver doesn't parse all representations of timestamps.
I calculate my own Timestamp and insert it into a table.
The field seems to contain (with psql SELECT):

2000-12-06 00:05:39.57+01

When i try to use a res.getTimestamp(i) i get an unparseable Timestamp exception at position 19

When i use a now() value the field contains (with psql SELECT):

2000-12-07 11:42:36+01

I get the impression that either there is a representation issue with postgresql or there is a small problem with the
JDBCdriver or i'm doing something wrong :-)
 

Greetz,

Yves De Muyter


pgsql-interfaces by date:

Previous
From: Joachim Achtzehnter
Date:
Subject: RE: JDBC Drop/Create problem?
Next
From: "Michael Miyabara-McCaskey"
Date:
Subject: Plperl make fails with Error1 at plperl.o (7.0.3)