Skip site navigation (1) Skip section navigation (2)

Re: Reading Timestamp values from a ResultSet

From: Barry Lind <barry(at)xythos(dot)com>
To: Whitney Hunter <Whitney(dot)Hunter(at)watchguard(dot)com>
Cc: "'Postgresql JDBC'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Reading Timestamp values from a ResultSet
Date: 2001-09-19 02:22:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Yes this is a known bug.  It is fixed in the 7.1 JDBC driver.  The 7.1 
driver should work fine against a 7.0 database.


Whitney Hunter wrote:

> Hi,
> I am trying to read a Timestamp value from a ResultSet and am getting the
> following exception:
> Bad Timestamp Format at 19 in 2001-09-18 14:01:16.26-07 
> 	at org.postgresql.jdbc2.ResultSet.getTimestamp(
> 	at
> com.watchguard.arch.sql.JdbcHelper.getSQLElement(
> 	at
> com.watchguard.arch.dao.RdbDAO.createValueFromResultSet(
> 	at com.watchguard.arch.dao.RdbDAO.loadOne(
> 	at
> com.watchguard.arch.dao.test.RdbDAOTest.testInsert(
> 	at com.watchguard.arch.dao.test.TestMain.main(
> I am using jdbc7.0-1.2.jar. Is anyone aware of a bug in this version of the
> driver that would cause this? Unfortunately, I can not get to the postgresql
> or jdbc driver sites today for some reason, so I can't check for myself.
> Any help would be appreciated!
> Thanks,
> Whitney Hunter
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

pgsql-jdbc by date

Next:From: Liam StewartDate: 2001-09-20 20:24:45
Subject: JDBC test suite patch
Previous:From: Whitney HunterDate: 2001-09-18 21:16:50
Subject: Reading Timestamp values from a ResultSet

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group