Timestamp out of range Exception with jdbc-driver from 7.4-beta1 - Mailing list pgsql-jdbc

From Andreas Joseph Krogh
Subject Timestamp out of range Exception with jdbc-driver from 7.4-beta1
Date
Msg-id 200308121433.08645.andreak@officenet.no
Whole thread Raw
Responses Re: Timestamp out of range Exception with jdbc-driver from
List pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I get the following when trying to getTimestamp():

java.sql.SQLException: SERRORC22008Mtimestamp out of range: "292278994-08-17
07:12:55.807000+01"Ftimestamp.cL328Rtimestamptz_in

nbeweb=# select COALESCE(a.valid_from, a.created) from on_article a where a.id
= 510;
         coalesce
- ---------------------------
 2002-05-03 10:13:21.16+02

nbeweb=# select valid_from , created from on_article where id = 510;
 valid_from |          created
- ------------+---------------------------
            | 2002-05-03 10:13:21.16+02

both fields are timestamp with time zone.

btw: What's up with the funny formatting of the error in the Exception?

JDK: 1.4.2
OS: Linux(mdk-9.0)
Postgresql: 7.4beta1

- --
Andreas Joseph Krogh <andreak@officenet.no>
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc

- - When there is no content, there is no crap.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/ON6EUopImDh2gfQRAgOnAJwKWuyckdEXHfbbNXCt8smVWb2gkwCdFUT4
Lb4iZxJhB0+cbfWb3bZXdUM=
=H8K9
-----END PGP SIGNATURE-----

pgsql-jdbc by date:

Previous
From: Evan Tsue
Date:
Subject: Character Decoding Problems
Next
From:
Date:
Subject: Re: Character Decoding Problems