[Pljava-dev] R: select CURRENT_TIMESTAMP is wrong

[Jeffrey Lyon]

That is strange - I did this on Java 5/OS X 10.5.1/Pgsql 8.1.3:

	ResultSet time = connection.executeQuery("SELECT now();");
	time.next();
	System.err.println(time.getString(1));
	System.err.println(time.getTimestamp(1).toString());


... and got this result:

2008-01-23 08:14:30.740862-05
2008-01-23 08:14:30.740862

What if you don't close the Connection until you retrieve the results  
of the ResultSet?

J

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

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pljava-dev/attachments/20080123/ce839f4d/attachment.html