agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] select CURRENT_TIMESTAMP is wrong
Date: Wed, 23 Jan 2008 13:34:18 +0100
Message-ID: <014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO> (raw)

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

view thread (2+ messages)  latest in thread

Message-ID: <014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO>
Permalink:  ../014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO/
Also on:    postgresql.org/message-id/014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] select CURRENT_TIMESTAMP is wrong
  In-Reply-To: <014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox