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
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 |