Re: Timestamp out of range Exception with jdbc-driver from

Andreas,

Can you send a test case that demonstrates the problem?

thanks,
--Barry

PS.  The exception message formating for the V3 protocol has not yet
been completed, and that is why you see what you do in the exception.



Andreas Joseph Krogh wrote:
> -----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-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>