Re: [JDBC] TIMESTAMP

2001-10-02 Thread David Siebert
If you mean the 7.2 beta jdbc driver then I am using it and I still get the same error. Do I need to clear the database? The version of postgres seems old 6.5.2 is the reported version. Any idea how to update it. I am running it on Suse 7.1 And I am not all that hot in Linux. "Yes I know it is off

Re: [JDBC] TIMESTAMP

2001-10-02 Thread Barry Lind
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

Re: [JDBC] TIMESTAMP

2001-10-02 Thread David Siebert
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 {

Re: [JDBC] TIMESTAMP

2001-10-02 Thread Barry Lind
David, Can you specify the exact error you are getting? along with the database version, jdbc version and java version you are running? Also a test case that demonstrates the problem would be very helpful as well. thanks, --Barry David Siebert wrote: > I am having problems with getTimestamp

Re: [JDBC] TIMESTAMP

2001-10-02 Thread David Siebert
--- Thomas O'Dowd <[EMAIL PROTECTED]> wrote: > Can you post a sample of your code that reproduces > the problem. What > timezone are you in? I think there is a problem with > some timezones > which are on the half hour. Can you post the > exception you get also. > > Tom. > > On Mon, Oct 01, 200

Re: [JDBC] TIMESTAMP

2001-10-01 Thread Thomas O'Dowd
Can you post a sample of your code that reproduces the problem. What timezone are you in? I think there is a problem with some timezones which are on the half hour. Can you post the exception you get also. Tom. On Mon, Oct 01, 2001 at 02:15:39PM -0700, David Siebert wrote: > I am having problems

[JDBC] TIMESTAMP

2001-10-01 Thread David Siebert
I am having problems with getTimestamp. I keep getting an invalid format error. I am using the latest JDBC driver. Help please. I have searched the arcives and I have found others seem to have the same issue but none of the fixes provided seemed to work. _

Re: [JDBC] Re: [Fwd: JDBC Timestamp problem]

2001-02-23 Thread Antonio Fiol
Peter T Mount wrote: > Quoting Antonio Fiol <[EMAIL PROTECTED]>: > > > Joseph Shraibman wrote: > > > > > jdbc version don't follow postgres versions, so the jdbc drivers from > > > the 7.1 codebase should work with a 7.0 server. Provided there > > aren't any bugs in those jdbc drivers, of course

Re: [JDBC] Re: [Fwd: JDBC Timestamp problem]

2001-02-23 Thread Peter T Mount
Quoting Antonio Fiol <[EMAIL PROTECTED]>: > Joseph Shraibman wrote: > > > jdbc version don't follow postgres versions, so the jdbc drivers from > > the 7.1 codebase should work with a 7.0 server. Provided there > aren't any bugs in those jdbc drivers, of course. Why are you using 7.0 > when 7.

Re: [JDBC] Re: [Fwd: JDBC Timestamp problem]

2001-02-23 Thread Antonio Fiol
Joseph Shraibman wrote: > jdbc version don't follow postgres versions, so the jdbc drivers from > the 7.1 codebase should work with a 7.0 server. Provided there aren't > any bugs in those jdbc drivers, of course. Why are you using 7.0 when > 7.0.3 is out? I think some of the timestamp problems

[JDBC] Re: [Fwd: JDBC Timestamp problem]

2001-02-22 Thread Joseph Shraibman
. Antonio Fiol wrote: > > Sorry, I sent the message to Peter only... > > > > Subject: Re: [JDBC] JDBC Timestamp problem > Date: Thu, 22 Feb 2001 18:08:55 +0100 > From: Antonio Fiol <[EMAIL PR

Re: [JDBC] JDBC Timestamp problem

2001-02-22 Thread Peter T Mount
Quoting Antonio Fiol <[EMAIL PROTECTED]>: > Hello, > > I have an application that worked well woth Postgresql 6.5. > > Now I am on 7.0, and I get this exception when I execute an > rs.getTimestamp("reftime"): > > Bad Timestamp Format at 0 in 1970-01-01 01:26:56.99+01 > at > org.postgre

[Fwd: [JDBC] JDBC Timestamp problem]

2001-02-22 Thread Antonio Fiol
Sorry, I sent the message to Peter only... > Yes, there's been a lot of problems with timestamps, mainly where it was > getting confused with timezone/millisecond variations. 99% of these have been > fixed in the 7.1 driver. > > (I say 99% as there is bound to be a senario we've missed out ;-)

Re: [JDBC] JDBC Timestamp problem

2001-02-22 Thread Jeff Hoffmann
Antonio Fiol wrote: > > Hello, > > I have an application that worked well woth Postgresql 6.5. > > Now I am on 7.0, and I get this exception when I execute an > rs.getTimestamp("reftime"): > > Bad Timestamp Format at 0 in 1970-01-01 01:26:56.99+01 > at > org.postgresql.jdbc1.ResultSet.

[JDBC] JDBC Timestamp problem

2001-02-22 Thread Antonio Fiol
Hello, I have an application that worked well woth Postgresql 6.5. Now I am on 7.0, and I get this exception when I execute an rs.getTimestamp("reftime"): Bad Timestamp Format at 0 in 1970-01-01 01:26:56.99+01 at org.postgresql.jdbc1.ResultSet.getTimestamp(ResultSet.java:445) at