Reading Timestamp values from a ResultSet

From: Whitney Hunter <Whitney(dot)Hunter(at)watchguard(dot)com>
To: "'Postgresql JDBC'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Reading Timestamp values from a ResultSet
Date: 2001-09-18 21:16:50
Message-ID: f7e5da46a73fc161ff381a163810ea013ba7d3ae@watchguard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(ResultSet.java:447)
at
com.watchguard.arch.sql.JdbcHelper.getSQLElement(JdbcHelper.java:187)
at
com.watchguard.arch.dao.RdbDAO.createValueFromResultSet(RdbDAO.java:742)
at com.watchguard.arch.dao.RdbDAO.loadOne(RdbDAO.java:141)
at
com.watchguard.arch.dao.test.RdbDAOTest.testInsert(RdbDAOTest.java:62)
at com.watchguard.arch.dao.test.TestMain.main(TestMain.java:12)

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2001-09-19 02:22:38 Re: Reading Timestamp values from a ResultSet
Previous Message Denis Bucher 2001-09-18 19:55:37 Re: URGENT ! Nouveau virus