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
>
>
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 |