From: | Alexandre Gattiker <agattiker(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | JDBC driver 9.2 sending arbitrary timezone |
Date: | 2013-08-05 04:18:59 |
Message-ID: | CAOfQWyEZwiqBhLhB=QOh8v154n5_c_k59Peai7tDqk1srW8JRw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello,
PostgreSQL jdbc jar 9.2-1003-jdbc4 is failing for me, while version
9.1-901-1.jdbc4 works fine. I was able to reproduce the issue by running
the jdbc driver's unit tests.
It appears the client is sending to the server the
timezone Europe/Busingen, although my timezone is set to Europe/Zurich.
runtest:
[junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
[junit] Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 0 sec
[junit]
[junit] Null Test: Caused an ERROR
[junit] null
[junit] java.lang.reflect.InvocationTargetException
[junit] Caused by: org.postgresql.util.PSQLException: FATAL: invalid
value for parameter "TimeZone": "Europe/Busingen"
[junit] at
org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:572)
[junit] at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:177)
[junit] at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
[junit] at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
[junit] at
org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
[junit] at
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
[junit] at
org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
[junit] at org.postgresql.Driver.makeConnection(Driver.java:406)
[junit] at org.postgresql.Driver.connect(Driver.java:280)
[junit] at java.sql.DriverManager.getConnection(DriverManager.java:571)
[junit] at java.sql.DriverManager.getConnection(DriverManager.java:187)
[junit] at org.postgresql.test.TestUtil.openDB(TestUtil.java:187)
[junit] at org.postgresql.test.TestUtil.openDB(TestUtil.java:173)
[junit] at
org.postgresql.test.jdbc2.Jdbc2TestSuite.suite(Jdbc2TestSuite.java:94)
[junit] ... 25 more
Server: Postgres Plus; PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu,
compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
CentOS release 6.4 (Final) Linux 2.6.32-358.11.1.el6.x86_64 #1 SMP Wed Jun
12 03:34:52 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
cat /etc/sysconfig/clock
ZONE="Europe/Zurich"
Regards,
Alexandre
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-08-05 06:16:14 | Re: JDBC driver 9.2 sending arbitrary timezone |
Previous Message | dmp | 2013-08-03 23:07:28 | Updated Website Layout Completed |