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 по дате отправления: