Infinity and beyond

From: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
To: "[pgsql-jdbc]" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Infinity and beyond
Date: 2005-05-05 09:07:01
Message-ID: 008001c55151$ccc99150$0264a8c0@demolish1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

A while back I noted in this thread that some people were having issues with timestamps and infinity.
I have been using a modified version of the 7.4 driver for some time now and have had no real issues with these modifications. The modifications that I made involve adding two additional classes to the driver package. They are simple classes that extend java.sql.Date and java.sql.Timestamp. In my opinion this solution is much more elegant than relying on some magic number used in the underlying java.util.Date class.
The main beauty of these modification are that you do not need to rely any PostgreSQL driver specifics to detect values of infinity, and on a similar note the driver doesn't have to rely on its own implementations of infinity, it can handle third party implementations.
If anyone is interested in these modification I will post them on this thread, just ask.
Cheers
Donald Fraser.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-05-05 09:21:09 Re: Infinity and beyond
Previous Message Nahum Castro 2005-05-05 04:34:25 Re: Connectivity of postgreSQL database to a JSP page