Re: TIMESTAMP - Mailing list pgsql-jdbc

From David Siebert
Subject Re: TIMESTAMP
Date
Msg-id 20011002190906.22166.qmail@web11706.mail.yahoo.com
Whole thread Raw
In response to Re: TIMESTAMP  (Barry Lind <barry@xythos.com>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: why would an update only work if done twice?
Next
From: "Dave Cramer"
Date:
Subject: Re: driver fails to handle strings in query statements properly