From: Dallas Hockley <hockleyd@cybersurf.net>
To: pgsql-interfaces@postgresql.org
Subject: jdbc, Dates, and JBuilder
Date: Wed, 24 Jun 1998 21:42:57 -0600
Message-ID: <3591C741.93633F87@cybersurf.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hockleyd@cybersurf.net
Subject: Re: jdbc, Dates, and JBuilder
In-Reply-To: <3591C741.93633F87@cybersurf.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox