Re: JDBC date problem
От | Bruce Momjian |
---|---|
Тема | Re: JDBC date problem |
Дата | |
Msg-id | 200101120431.XAA25477@candle.pha.pa.us обсуждение исходный текст |
Ответ на | RE: JDBC date problem ("Mike Cannon-Brookes" <mcannon@internet.com>) |
Список | pgsql-interfaces |
Would you please send me a context diff (diff -c) comparing the two versions? Thanks. > Actually I've been playing around more and there's some cases left out of > the driver. I hacked it to put them in and it works much better now. (Was > giving Bad Timestamp exceptions). > > I've attached the hacked / fixed ResultSet.java file as I have no CVS > access, would some kind soul with access patch it? I've marked my changes > clearly with comments in the getTimestamp() method. > > Hope this helps! > > Mike > > > -----Original Message----- > > From: pgsql-interfaces-owner@postgresql.org > > [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of Mike > > Cannon-Brookes > > Sent: Thursday, January 11, 2001 12:20 AM > > To: Pgsql-Interfaces@Postgresql. Org > > Subject: RE: [INTERFACES] JDBC date problem > > > > > > For reference, I just updated my CVS tree and recompiled using Ant and the > > new jar works much better. It must be a bug in the old jar (ResultSet.java > > was indeed updated with your patch Michael). > > > > Thanks for the tip! > > Mike > > > > PS For anyone interested, org.postgresql.xa.Test has a serious bug in it, > > tries to instantiate an interface (XADataSource) - someone might want to > > hack at it. (just comment out the method and recompile if you > > care not about > > testing ;)) > > > > > -----Original Message----- > > > From: pgsql-interfaces-owner@postgresql.org > > > [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of Michael > > > Stephenson > > > Sent: Wednesday, January 10, 2001 8:42 PM > > > To: Pgsql-Interfaces@Postgresql. Org > > > Subject: Re: [INTERFACES] JDBC date problem > > > > > > > > > > Any ideas? This is a real stumper and I need to find a solution > > > asap! I'm > > > > using a JDBC driver I built from CVS no more than a month ago. > > > > > > The results look to me like that in org.postgresql.jdbc2.ResultSet > > > 'mm' and 'MM' have been confused (I know that this was the case > > in a patch > > > I submitted), try replacing getTimeStamp() with: > > > > > > public Timestamp getTimestamp(int columnIndex) throws SQLException > > > { > > > String s = getString(columnIndex); > > > if(s==null) > > > return null; > > > > > > SimpleDateFormat df = null; > > > if (s.length()>21 && s.indexOf('.') != -1) { > > > df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSzzz"); > > > } else if (s.length()>19 && s.indexOf('.') == -1) { > > > df = new SimpleDateFormat("yyyy-MM-dd HH:mm:sszzz"); > > > } else if (s.length()>19 && s.indexOf('.') != -1) { > > > df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SS"); > > > } else if (s.length()>10 && s.length()<=18) { > > > df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); > > > } else { > > > df = new SimpleDateFormat("yyyy-MM-dd"); > > > } > > > > > > try { > > > return new Timestamp(df.parse(s).getTime()); > > > } catch(ParseException e) { > > > throw new PSQLException("postgresql.res.badtimestamp",new > > > Integer(e.getErrorOffset()),s); > > > } > > > } > > > > > > Michael Stephenson > > > > > > > > > > > > > [ Attachment, skipping... ] -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-interfaces по дате отправления: