JDBC DateTime broken in postgresql-7.02?

From: David C Mudie <mudie(at)digitaldeck(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC DateTime broken in postgresql-7.02?
Date: 2000-07-25 00:20:35
Message-ID: 200007250020.RAA70410@digitaldeck.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


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(at)digitaldeck(dot)com
San Mateo CA 94402 http://www.digitaldeck.com

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jim Caley 2000-07-25 01:28:28 Re: JDBC DateTime broken in postgresql-7.02?
Previous Message phil 2000-07-24 22:13:54 Re: Foreing Key in Postgres ????