Обсуждение: Two versions of jdbc driver returns different results

Поиск
Список
Период
Сортировка

Two versions of jdbc driver returns different results

От
Vitaliy Avdeev
Дата:
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));

              

            }

Re: Two versions of jdbc driver returns different results

От
Dave Cramer
Дата:
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@sistyma.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));

              

            }