[Fwd: Re: Patch for JDBC timestamp problems] - Mailing list pgsql-jdbc

From Barry Lind
Subject [Fwd: Re: Patch for JDBC timestamp problems]
Date
Msg-id 3DFE0486.3050400@xythos.com
Whole thread Raw
List pgsql-jdbc
Forwarding to mail list.

-------- Original Message --------
Subject: Re: Patch for JDBC timestamp problems
Date: Fri, 13 Dec 2002 22:44:21 -0800 (PST)
From: a aparna <aahirrao@yahoo.com>
To: barry@xythos.com, pgman@candle.pha.pa.us
CC: aahirrao@yahoo.com



Hi,

   we are experiencing a wiered problem in production environment. We
have a situation where the date display is rendered incorrectly for the
hour part( displayed as '00' for all cases) on production site  *when
the traffic increases beyond a certain threshold.*This problem is seen
to occur sporadically and no obvious pattern has been detected. The
display normalises on restarting the servers (IBM Websphere). We are
using following code snippet to get date value in java object from SQL date:

private Date makeDateFromTimestamp(Timestamp ts) {

       Date value = null;

       if (ts != null) {

             value = new Date(ts.getTime() + (ts.getNanos() / 1000000));

       }

      return value;

}

Have found similar problem reported on java forum:
http://forum.java.sun.com/thread.jsp?forum=31&thread=280442
<http://forum.java.sun.com/thread.jsp?forum=31&thread=280442> but no
resolution.



Was wondering if you have ever experienced such kinda problem and why is
the behaviour so/any resolution?



Thanks & Regards,

-Aparna


------------------------------------------------------------------------
Do you Yahoo!?
Yahoo! Mail Plus
<http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com> -
Powerful. Affordable. Sign up now
<http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com>




pgsql-jdbc by date:

Previous
From: Steve Wampler
Date:
Subject: Re: JDBC - Open Office
Next
From: Barry Lind
Date:
Subject: Re: failing using unicode