Re: timestamp exception in driver

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: Jan Blok <jblok(at)profdata(dot)nl>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: timestamp exception in driver
Date: 2002-05-21 00:31:17
Message-ID: 1021941078.16917.117.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Is that a real time? I'm not sure that java supports times BC?

Does anyone know?

Dave

On Mon, 2002-05-20 at 15:35, Jan Blok wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-05-21 01:10:43 Re: feature request
Previous Message Thomas O'Dowd 2002-05-21 00:23:15 Re: timestamp exception in driver