Skip site navigation (1) Skip section navigation (2)

BUG #2288: bad value for type timestamp using JDBC Type2 Driver version 8.1-405

From: "Jonathan Albert C(dot) Vallar" <jonathan(dot)vallar(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2288: bad value for type timestamp using JDBC Type2 Driver version 8.1-405
Date: 2006-02-28 03:51:20
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2288
Logged by:          Jonathan Albert C. Vallar
Email address:      jonathan(dot)vallar(at)gmail(dot)com
PostgreSQL version: 8.1.3
Operating system:   Centronix Linux
Description:        bad value for type timestamp using JDBC Type2 Driver
version  8.1-405

My program reports "bad value for type timestamp" when I am accessing a
table with a field that is defined of type "Timestamp" through a java
program that uses the JDBC of postgres. The JDBC Driver is a type2 driver
with version, 8.1-405.

Below is the stack trace 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
at org.postgresql.jdbc2.TimestampUtils.toTimestamp( 
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2Result   at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2Result   at
com.crossworlds.connectors.JDBC.JDBCBOhandler.doContainerRetrieve(JDBCBOhand   at
com.crossworlds.connectors.JDBC.JDBCBOhandler.doRecursiveRetrieve(JDBCBOhand   at
3265)   at
346)   at
com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConnectorBOH   at
CxCommon.BusinessObject.doVerbFor(   at
.java:126)   at
com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(JDBCConnect   at
at AppSide_Connector.AppCalls.poll(   at
.java:719)   at AppSide_Connector.AppPolling.poll(   at
at   at  End of Stack Trace   SQLException

The Schema of the table is:

(1 row)

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           |

I have one record:

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 |            0 | Test
(1 row)

Is there a problem with the JDBC Driver? Specifically in the method

Thanks in advance :)

Best Regards,


pgsql-bugs by date

Next:From: Abhilash KrishnanDate: 2006-02-28 09:24:35
Subject: BUG #2289: insert into tables not working
Previous:From: Tom LaneDate: 2006-02-27 21:58:38
Subject: Re: has_table/schema_privilige() returns incorrect info on temp tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group