timestamp exception in driver
| От | Jan Blok |
|---|---|
| Тема | timestamp exception in driver |
| Дата | |
| Msg-id | 000001c1b492$0734f2e0$0201000a@BLOKS3 обсуждение исходный текст |
| Ответы |
Re: timestamp exception in driver
Re: timestamp exception in driver |
| Список | 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
В списке pgsql-jdbc по дате отправления: