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)
