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

Re: TIMESTAMP

From: Barry Lind <barry(at)xythos(dot)com>
To: David Siebert <glwatcdr(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: TIMESTAMP
Date: 2001-10-02 20:48:31
Message-ID: 3BBA281F.8080706@xythos.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
OK, this is a known bug.  It should be fixed in current sources.  Try 
using the 7.2 driver from the jdbc.postgresql.org website and see if 
that works correctly for you.  If you search the email archives you can 
find a discussion on this bug.

thanks,
--Barry

David Siebert wrote:

> It looks as if I blew it when I cut and pasted it.
> Lets try again.
> This is the error message.
> 
> Phone Call PhoneCall(Rs) en:0 Bad Timestamp Format at
> 19 in 2001-10-01 15:20:06.66-05
> 
> and this is the method that generates it.
> 
> 
> public PhoneCall(ResultSet rs) {
>     int errori=0;    
>     try {
>            m_sCaller=rs.getString("scaller");
>            m_sPhone=rs.getString("sphone");
>            m_sPhone2=rs.getString("sphone2");
>            m_sQuedBy=rs.getString("squedby");
>            m_iPri=rs.getInt("ipri");
>            m_iStatus=rs.getInt("istatus");
>            m_sFor=rs.getString("sfor");
>            m_sNotes= rs.getString("snotes");
>            m_objPlacedDate =
> rs.getTimestamp("dplaceddate");
>            errori++;
>            m_objTakenDate =
> rs.getTimestamp("dtakendate");
>            errori++;
>            m_objResDate = 
> rs.getTimestamp("dresdate");
>            errori++;
>            m_iResolution = rs.getInt("iresolution");
>            m_iReQues = rs.getInt("ireques");
>         } catch (Exception ex){
>             System.err.println("Phone Call
> PhoneCall(Rs) en:"+errori+" "+ex.toString());
>         }
>     }
> 
> __________________________________________________
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com
> 
> 



In response to

Responses

pgsql-jdbc by date

Next:From: Barry LindDate: 2001-10-02 20:52:52
Subject: Re: are long strings (500 char?) working?
Previous:From: Barry LindDate: 2001-10-02 20:45:53
Subject: Re: LOCK TABLE oddness in PLpgSQL function called via JDBC

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