[Fwd: Re: Patch for JDBC timestamp problems]

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(at)yahoo(dot)com>
To: barry(at)xythos(dot)com, pgman(at)candle(dot)pha(dot)pa(dot)us
CC: aahirrao(at)yahoo(dot)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>