timestamp exception in driver

From: "Jan Blok" <jblok(at)profdata(dot)nl>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: timestamp exception in driver
Date: 2002-05-20 19:35:09
Message-ID: 000001c1b492$0734f2e0$0201000a@BLOKS3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I encounter the following bug in the postgresql driver...(it seems that
the driver 7.3dev not supports a timestamp which is inside the database)

Bad Timestamp Format at 16 in 0001-01-01 09:00 BC
at
org.postgresql.jdbc2.ResultSet.toTimestamp(ResultSet.java:1705)
at
org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:398)
at nl.profdata.syne.ContentList.makeRows(ContentList.java:438)
at nl.profdata.syne.ContentList.<init>(ContentList.java:68)
at
nl.profdata.syne.ContentManager.getContentByQuery(ContentManager.java
:260)
at Planner.getAvailebleTimes(Planner.java:141)
at Planner.main(Planner.java:41)
SQL from the exception select ea.start_time,ea.end_time, -1 as
product_id,e.empl oyee_id,0 as customer_id,pe.priority from employees
e,employee_avail ea,product_ employee pe where e.employee_id =
pe.employee_id and pe.product_id = 1003 and e. employee_id =
ea.employee_id and ea.weekday = 4 and e.supplier_id = 1001 order b y
e.employee_id,ea.start_time

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jan Blok 2002-05-20 19:35:36 feature request
Previous Message Michael Adler 2002-05-20 19:03:51 SocketException: "catch me if you can"