RE: JDBC DateTime broken in postgresql-7.02?

If it's calling getTimestamp() then there is a problem with the format
string passed to SimpleDateFormat. One quick fix is to remove the zzz part.
Others include changing zzz to other formats.

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council


-----Original Message-----
From: David C Mudie [mailto:mudie@digitaldeck.com]
Sent: Tuesday, July 25, 2000 1:21 AM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] JDBC DateTime broken in postgresql-7.02?



Hello postgresql-interfaces!  I recently upgraded from postgresql-6.5.3
to 7.0.2 on FreeBSD 3.4-STABLE.  I built and installed postgresql.jar
with JDK 1.1.8 as described in the installation notes.

After the upgrade, a basic query ("SELECT * FROM table") no longer
works as before.  The result set provides text fields just fine, but
datetime fields produce a runtime error.

Unfortunately, I am not calling JDBC directly, but through Halycon
Instant ASP and a Visual Basic ADO class.  I cannot get any
coherent JDBC error messages out of the ASP interpreter and do not know
exactly where things are going wrong.  

Does this sound like any known problems with datetime structures in the 
v7.02 JDBC classes?  Is there anything easy I can do to fix it?

I have been able to work around the problem by selecting datetime
fields as text, but I would like to know if any better solutions
are available.  Thanks!

David

----------------------------------------------------------------------------
-
David C Mudie   DigitalDeck Inc        mudie@digitaldeck.com               San Mateo CA 94402
http://www.digitaldeck.com