Helllu there,
Ok, I dit download the the latest jdbc driver source and compiled it. I
still had te same error and changed the getTimestamp function, such that it
works.
The problem occurs with Postgres Date field (I have version 7.0), not with
Postgres DateTime fields. The problem is as followes:
The driver checks the date from postgres and looks for a + or - sign at the
end of the string for the GMT offset. It also does that when it concerns a
postgres Date field, which is the problem, as it shouldn't. It then
encounters the - between the month and day and inserts the string GMT
there -> rubbish -> Exception!!!
Am I missing something here, or is this really a bug ? If it is, please
change it in the following release.
Goodluck,
Eddie
----- Original Message -----
From: Jeff Schnitzer <[EMAIL PROTECTED]>
To: Orion-Interest <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 8:08 PM
Subject: RE: bad timestamp confusion
> Take a look at this message I posted in January:
>
> http://www.mail-archive.com/orion-interest@orionserver.com/msg08677.html
>
> If you patch the JDBC driver to read whatever format your dates are
> coming back as (you should see the actual formatted date string in the
> exception message), you should be ok.
>
> You might first check the CVS copy of the JDBC driver to see if it
> works; with any luck patches have already been made.
>
> Storing dates as strings just seems like a bad idea. It's nice to be
> able to do date math in SQL queries when you want to analyze your data.
>
> Jeff
>
> >-----Original Message-----
> >From: Eddie [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, March 21, 2001 4:55 AM
> >To: Orion-Interest
> >Subject: bad timestamp confusion
> >
> >
> >Just like other people in the newsgroup, I am receiving a bad timestamp
> >error once in a while with Postgres 7.0.
> >
> >I looked in the newsgroup and saw some possible solutions, but
> >I am a bit
> >confused.
> >How can I solve this problem for ever in case of a DateTime field ???
> >Someone talked about using java.sql.Date instead of java.util.Date, the
> >other about getting the last postgres jdbc driver....
> >I got the last postgres driver from the postgres site, so what
> >should I do
> >??
> >
> >I was thinking about just using Strings to store Date format info. What
> >about this ?
> >
> >And what should I do when I get such an error. Filling the
> >database all over
> >again helps. But what, when I have everyting ready online ??
> >
> >Regards,
> >Eddie
> >
> >
>
>
