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

From: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Timestamp out of range Exception with jdbc-driver from 7.4-beta1
Date: 2003-08-12 12:33:08
Message-ID: 200308121433.08645.andreak@officenet.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)officenet(dot)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-----

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message zy7111 2003-08-12 12:34:39 Re: Character Decoding Problems
Previous Message Evan Tsue 2003-08-12 05:38:11 Character Decoding Problems