From: jeffreylyon at mac.com (Jeffrey Lyon) Date: Wed, 23 Jan 2008 08:18:55 -0500 Subject: [Pljava-dev] R: select CURRENT_TIMESTAMP is wrong In-Reply-To: <014901c85dbf$c92040d0$16b0a8c0@ASUSSTEFANO> References: <014401c85dbc$477601d0$16b0a8c0@ASUSSTEFANO> <09DA7761-B2E9-4036-B2B1-84F97418F3D4@mac.com> <014901c85dbf$c92040d0$16b0a8c0@ASUSSTEFANO> Message-ID: <227D74A0-C160-4036-ABBD-75D08B65C44A@mac.com> 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: