From: stefano.bianchi at iskranet.net (Stefano Bianchi)
Date: Wed, 23 Jan 2008 13:59:25 +0100
Subject: [Pljava-dev] R:  select CURRENT_TIMESTAMP is wrong
In-Reply-To: <09DA7761-B2E9-4036-B2B1-84F97418F3D4@mac.com>
References: <014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO>
	<09DA7761-B2E9-4036-B2B1-84F97418F3D4@mac.com>
Message-ID: <014901c85dbf$c92040d0$16b0a8c0@ASUSSTEFANO>

Thanks for replay.

But notings change.

INFO:  23 Jan 08 13:57:39 xxx.HelloWorld Time is Wed Jan 23 13:57:39 CET
2008
INFO:  23 Jan 08 13:57:39 xxx.HelloWorld Sql Time is :1978-02-13
07:44:13.000318

Logger.getAnonymousLogger().info( "Sql Time is
:"+rs.getTimestamp(1).toString()+"\n");




-----Messaggio originale-----
Da: pljava-dev-bounces at pgfoundry.org
[mailto:pljava-dev-bounces at pgfoundry.org] Per conto di Jeffrey Lyon
Inviato: mercoled? 23 gennaio 2008 13.47
A: pljava-dev at pgfoundry.org
Oggetto: Re: [Pljava-dev] select CURRENT_TIMESTAMP is wrong

What happens if, instead of rs.getString(1), you retrieve the  
Timestamp via an rs.getTimestamp(1).toString()?

J

On Jan 23, 2008, at 7:34 AM, Stefano Bianchi wrote:

> 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
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev