Re: Bad Value for Data Type Timestamp

:) Thanks :)

How can I go about this error? It seems that the data on the table is
correct.

Below is the stacktrace of the error:

Retrieve Operation failed on the BusinessObject Bad value for type =
timestamp : [C(at)56c55d28 Exception: java.lang.NumberFormatException: =
Expected time to be colon-separated, got ' Stack Trace: =
java.lang.NumberFormatException: Expected time to be colon-separated, =
got ' at =
org.postgresql.jdbc2.TimestampUtils.loadCalendar(TimestampUtils.java:151)=
at =
org.postgresql.jdbc2.TimestampUtils.toTimestamp(TimestampUtils.java:307) =
at =
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2Res=
ultSet.java:419) at =
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2Res=
ultSet.java:2088) at =
com.crossworlds.connectors.JDBC.JDBCBOhandler.doContainerRetrieve(JDBCBOh=
andler.java:3697) at =
com.crossworlds.connectors.JDBC.JDBCBOhandler.doRecursiveRetrieve(JDBCBOh=
andler.java:3316) at =
com.crossworlds.connectors.JDBC.JDBCBOhandler.doRetrieve(JDBCBOhandler.ja=
va:3265) at =
com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler.jav=
a:1346) at =
com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConnector=
BOHandler.java:127) at =
CxCommon.BusinessObject.doVerbFor(BusinessObject.java:2128) at =
com.crossworlds.cwconnectorapi.CWConnectorBusObj.doVerbFor(CWConnectorBus=
Obj.java:126) at =
com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(JDBCConn=
ectorAgent.java:1137) at =
AppSide_Connector.BusObjJavaInterface.poll(BusObjJavaInterface.java:355) =
at AppSide_Connector.AppCalls.poll(AppCalls.java:191) at =
AppSide_Connector.AgentBusinessObjectManager.poll(AgentBusinessObjectMana=
ger.java:719) at =
AppSide_Connector.AppPolling.poll(AppPolling.java:294) at =
AppSide_Connector.AppPolling.doPollingContinuousWait(AppPolling.java:556)=
at AppSide_Connector.AppPolling.run(AppPolling.java:121) at =
java.lang.Thread.run(Thread.java:513) End of Stack Trace SQLException =
{2}]

Many thanks!

Jonathan

On 3/1/06, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
>
> Jonathan Vallar wrote:
> > Hmmm.. I do not know how to display the actual value because the java
> > program is an IBM product (IBM Websphere WBI).
>
> My comment was not aimed at you, it was aimed at the other driver
> maintainers. Pretend I didn't send the original email :)
>
> -O
>