Bad Value for Data Type Timestamp

Hi!

Good day!

I encountered an error in getting data from a timestamp field datatype. I
am using a the JDBC type Driver for Postgres , version 8.1-405
(8.1-405JDBC 2). The database run on a Cent Linux OS and the postgres
database
version is 8.1.3.

Basically the java application gets data from the "xworlds_events" table.
The application returns an error in retrieving data from the event_time
field.

Below is the stacktrace of the java program:

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 (
AbstractJdbc2ResultSet.java:419) at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(
AbstractJdbc2ResultSet.java:2088) at
com.crossworlds.connectors.JDBC.JDBCBOhandler.doContainerRetrieve(
JDBCBOhandler.java:3697) at
com.crossworlds.connectors.JDBC.JDBCBOhandler.doRecursiveRetrieve(
JDBCBOhandler.java:3316) at
com.crossworlds.connectors.JDBC.JDBCBOhandler.doRetrieve(JDBCBOhandler.java:3265)
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor (
JDBCBOhandler.java:1346) at
com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(
CWConnectorBOHandler.java:127) at CxCommon.BusinessObject.doVerbFor(
BusinessObject.java:2128) at
com.crossworlds.cwconnectorapi.CWConnectorBusObj.doVerbFor (
CWConnectorBusObj.java:126) at
com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(
JDBCConnectorAgent.java:1137) at
AppSide_Connector.BusObjJavaInterface.poll(BusObjJavaInterface.java:355)
at AppSide_Connector.AppCalls.poll( AppCalls.java:191) at
AppSide_Connector.AgentBusinessObjectManager.poll(
AgentBusinessObjectManager.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}]

Below is the schema of the table:

wbi_db=> \d xworlds_events;
Table "public.xworlds_events"
Column | Type | Modifiers
----------------+-----------------------------+-----------
event_id | bigint | not null
connector_id | character varying(40) |
object_key | character varying(80) | not null
object_name | character varying(40) | not null
object_verb | character varying(40) | not null
event_priority | real | not null
event_time | timestamp without time zone |
event_status | integer |
event_comment | character varying |

Here is a sample data from the table:

wbi_db=> select * from xworlds_events;
event_id | connector_id | object_key | object_name | object_verb |
event_priority | event_time | event_status | event_comment
----------+--------------+------------+----------------------+-------------+----------------+---------------------------+--------------+---------------
1 | PostgreSQL | 8100000000 | POS_to_SAP_1_WRAPPER | Create
| 1 | 2006-02-27 19:51: 22.58118 | -1 | Test
(1 row)

wbi_db=>

How can I go about the problem? Is this a bug?

Thanks!

Regards,

Jonathan