Hi, JT.
Thanks for your tip.
That was right. There was a problem with the cvs version of jdbc driver.
I looked into the driver source and found out the problem and fixed it.
Now it is working fine.
FYI, PostgreSQL now supports `outer join' even though it's not officially
released yet.
Once again, thanks JT.
"J.T. Wenting" wrote:
> Different database engines use different formats for dates and times (and
> thus for timestamps). I had a similar problem converting a servlet from
> Interbase (which we used during development) to Oracle (used by our client
> in production).
> Possibly Postgress does not understand the difference to GMT you include.
> This could be either a design-feature or a bug (as you say you have a CVS
> version I would guess the latter if you were using an older version of
> Postgress before).
> I would take this up with the Postgress development team (if there is
> nothing about it in the documentation).
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Seung R. Bang
> > Sent: Monday, December 25, 2000 10:18
> > To: Orion-Interest
> > Subject: Bad Timestamp Format
> >
> >
> > Hello,
> > It's Christmas day.... 1:00 AM..
> > What am I doing?
> > Working, trying to catch a bug...
> > I changed some BMP beans to CMP beans.
> > I upgraded the database server to PostgreSQL 7.1 which is a CVS version.
> > My beans auto-created some tables when I started orion, which is good.
> > Everything works fine. But if I rebuild the beans and redeploy
> > them on site,
> > the existing data wouldn't be read in. More specifically, timestamp field
> > is not working correctly. Strangely enough, if I delete all the db table
> > entries and retry, then it works fine again. I tried to fix the database
> > schemas to switch java.sql.Timestamp and java.util.Date back and forth.
> > But it was in vain. Any tip will be very much appreicated.
> > Merry Christmas!!!!
> >
> >
> > The error message follows:
> >
> >
> > Nested exception is:
> > Bad Timestamp Format at 19 in 2000-12-25 00:22:22.97GMT-08:00
> > at org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:500)
> > at
> > MessageHome_EntityHomeWrapper5.findAllMessages(MessageHome_EntityHome
> > Wrapper5.java:601)
> > at
> > com.freightstream.ejb.BoardManagerBean.getMessageList(BoardManagerBea
> > n.java:81)
> > at
> > BoardManager_StatefulSessionBeanWrapper2.getMessageList(BoardManager_
> > StatefulSessionBeanWrapper2.java:304)
> > at
> > com.freightstream.tag.MessageIterator.doStartTag(MessageIterator.java
> > :22)
> > at
> > __jspPage2_message_list_jsp._jspService(__jspPage2_message_list_jsp.j
> > ava:50)
> > at com.orionserver.http.OrionHttpJspPage.service(JAX)
> > at com.evermind.server.http.HttpApplication.w5(JAX)
> > at com.evermind.server.http.JSPServlet.service(JAX)
> > at com.evermind.server.http.d1.si(JAX)
> > at com.evermind.server.http.d1.forward(JAX)
> > at com.freightstream.servlet.Login.service(Login.java:44)
> >
> >
> >
> >
> >
