From: | Bear Giles <bgiles(at)coyotesong(dot)com> |
---|---|
To: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | TimeZone issue with 42.2.1 |
Date: | 2018-03-05 18:24:06 |
Message-ID: | CALBNtw696ObydO1uxHAPhH-41OK1tvkB2OJ5oYDhcaRbrUC1Sg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi, we're seeing an issue retrieving a field with a timezone in 42.2.1. The
same software and table works with 42.2.0.
The schema is:
snapteam=# \d snapteam1.table3
Table "snapteam1.table3"
Column | Type | Modifiers
--------+------------------------+-----------
col1 | time(6) with time zone |
col2 | time with time zone[] |
col3 | time without time zone |
The data is:
snapteam=# select * from snapteam1.table3;
col1 | col2 | col3
----------------+------------------+------
12:00:00-08 | |
13:00:00-08 | |
24:00:00-14:59 | |
24:00:00-14:59 | {24:00:00-14:59} |
(4 rows)
The error is:
Can not resolve type id for sun.util.calendar.ZoneInfo (using
com.snaplogic.document.parser.plugin.DocumentTypeResolverBuilder$DataTypeIdResolver)
(through reference chain: java.util.LinkedHashMap["col2"]
->org.postgresql.jdbc.PgArray["resultSet"]
->org.postgresql.jdbc.PgResultSet["statement"]
->org.postgresql.jdbc.PgStatement["connection"]
->org.postgresql.jdbc.PgConnection["queryExecutor"]
->org.postgresql.core.v3.QueryExecutorImpl["timeZone"])
This is occurring on a 9.2 server. I haven't tracked down to the individual
line that's causing the problem - I wanted to zero in on when it broke
first since a problem that started 6 months ago is more likely to be in our
code than in a problem that started in the last few weeks.
Any ideas?
Thanks,
Bear
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Sitnikov | 2018-03-05 22:23:41 | Re: TimeZone issue with 42.2.1 |
Previous Message | Dave Cramer | 2018-03-04 17:49:14 | Re: MyBatis Batch Update Leads to PSQLException "Too many update results were returned" |