[Pljava-dev] select CURRENT_TIMESTAMP is wrong

From: stefano(dot)bianchi at iskranet(dot)net (Stefano Bianchi)
To:
Subject: [Pljava-dev] select CURRENT_TIMESTAMP is wrong
Date: 2008-01-23 12:34:18
Message-ID: 014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Hi,

I have a PostgreSQL 8.1.10 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
4.2.1 (Debian 4.2.1-5), with pljava-i686-pc-linux-gnu-pg8.1-1.3.0.tar.gz
installed.

I try to use CURRENT_TIMESTAMP (now()) from database with this simple
function:

package net.iskranet.java.pljava.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Logger;
import java.util.Date;

public class HelloWorld {
private static java.lang.String m_url = "jdbc:default:connection";

public static String helloWorld() throws SQLException {
String query="select current_timestamp";

Logger.getAnonymousLogger().info( "Time is " + new
Date(System.currentTimeMillis())+"\n");

Connection conn = DriverManager.getConnection(m_url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
conn.close();

rs.next();
Logger.getAnonymousLogger().info( "Sql Time is
:"+rs.getString(1)+"\n");
return "Hello World";
}
}

BUT my result are:
INFO: xxx HelloWorld Time is Wed Jan 23 12:32:31 CET 2008
INFO: xxx HelloWorld Sql Time is :1978-02-13 06:19:06.000088

I read on news pljava should adapt itself on different postgresql
installation, but may I have do somethings wrong, because it don't work

Can anyone help me ?
Thanks in advance

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Jeffrey Lyon 2008-01-23 12:47:26 [Pljava-dev] select CURRENT_TIMESTAMP is wrong
Previous Message kids 2008-01-22 03:46:16 Re: Pl/Java broken since Postgresql 8.3-rc1