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)
>
>
>
>
>
