From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Vitaliy Avdeev <vavdeev(at)sistyma(dot)net> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Two versions of jdbc driver returns different results |
Date: | 2013-05-14 01:36:28 |
Message-ID: | CADK3HHKB0QDGgJNVa7PjsSMeyOm0GEC5pB5wnLRPnJh_FsXi4A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Well I would need a complete test case to be able to diagnose why.
Can you provide this ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, May 13, 2013 at 9:24 AM, Vitaliy Avdeev <vavdeev(at)sistyma(dot)net> wrote:
> Hello, I have such problem.
>
> postgresql-9.1-901 jdbc driver and postgresql-9.2-1002 returns different
> values for the same query.
> The result of the postgresql-9.1-901 is the same as returns psql.
> I am using PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc
> (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
>
> Here is the code
>
> PreparedStatement prepareStatement = conn.prepareStatement("select
> rejected From "
>
> + "
> \"CountReport7\"(237505,1367776800000,1368986400000,'millennium','Europe/Kiev');
> ");
>
> System.out.println(prepareStatement);
>
> prepareStatement.execute();
>
> ResultSet rs = prepareStatement.getResultSet();
>
> while (rs.next()) {
>
> System.out.println(rs.getLong(1));
>
>
>
> }
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2013-05-16 17:45:51 | Support for materialized views |
Previous Message | Vitaliy Avdeev | 2013-05-13 13:24:20 | Two versions of jdbc driver returns different results |