jdbc, Dates, and JBuilder - Mailing list pgsql-interfaces

From Dallas Hockley
Subject jdbc, Dates, and JBuilder
Date
Msg-id 3591C741.93633F87@cybersurf.net
Whole thread Raw
Responses Re: [INTERFACES] jdbc, Dates, and JBuilder  (Peter Mount <peter@taer.maidstone.gov.uk>)
List pgsql-interfaces
Got a wee problem here, and I'm having a devil of a time locking it
down....

Using 6.3.1 Postgresql, with the accompanying jdbc driver, and using
Jbuilder 1.01 and 2.0, I am reading in a string, converting it to
a valid and correct sql.date, putting that into a DataRow instance
(Borland class) and committing the row to the database.  The data is
correct in the data row as it prepares for the commit.

After insert, when the row is retrieved, the day is consistently 1 too
large.  e.g. 04-14-1998 becomes 04-15-1998 after it's been committed via
the jdbc driver.  What I'm not sure of is if it's the driver, the
database, the datarow class or some interface between two of them.

Has anyone experienced similar behaviour, or has anyone got a definitive
"it can't be ..... because.... "

I'd appreciate any assistance on this.

Thanks in advance,

Dallas Hockley
hockleyd@cybersoft.ab.ca

pgsql-interfaces by date:

Previous
From: John Horncastle
Date:
Subject: [INTERFACES] Escape Characters
Next
From: Peter Mount
Date:
Subject: Re: [INTERFACES] jdbc, Dates, and JBuilder