Re: Two versions of jdbc driver returns different results
| От | Dave Cramer |
|---|---|
| Тема | Re: Two versions of jdbc driver returns different results |
| Дата | |
| Msg-id | CADK3HHKB0QDGgJNVa7PjsSMeyOm0GEC5pB5wnLRPnJh_FsXi4A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Two versions of jdbc driver returns different results (Vitaliy Avdeev <vavdeev@sistyma.net>) |
| Список | pgsql-jdbc |
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 codePreparedStatement 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));
}
В списке pgsql-jdbc по дате отправления: