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

Re: Problem with JDBC interface in Postgresql-6.3

From: Peter T Mount <pmount(at)maidast(dot)demon(dot)co(dot)uk>
To: Uri Blumenthal <uri(at)ibm(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problem with JDBC interface in Postgresql-6.3
Date: 1998-03-17 07:14:18
Message-ID: Pine.LNX.3.95.980317071216.18802B-100000@maidast (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 16 Mar 1998, Uri Blumenthal wrote:

> >>>>> "Peter" == Peter T Mount <pmount(at)maidast(dot)demon(dot)co(dot)uk> writes:
> 
>     Peter> I've tried to reproduce this, but it's not failing.
> 
> Darn... I recompiled and re-installed PostgreSQL-6.3, and
> now I can't reproduce this yesterday's error either. (:-(
> 
> [but see below.]
> 
> Opening large object 19201
> Opening test destination object
> Copying large object to file
> object size=6839
> copied 512 bytes, 6327 left
> copied 1024 bytes, 5815 left
> copied 1536 bytes, 5303 left
> copied 2048 bytes, 4791 left
> copied 2560 bytes, 4279 left
> copied 3072 bytes, 3767 left
> copied 3584 bytes, 3255 left
> copied 4096 bytes, 2743 left
> copied 4608 bytes, 2231 left
> copied 5120 bytes, 1719 left
> copied 5632 bytes, 1207 left
> copied 6144 bytes, 695 left
> copied 6656 bytes, 183 left
> copied 6839 bytes, 0 left
> The whole object copied successfully (6839 bytes).
> Closing object

weird... at least that problems now gone ;-)

> But now I'm trying "example.datestyle" and it fails me:
> 
> PostgreSQL datestyle test v6.3 rev 1
> 
> Connecting to Database URL = jdbc:postgresql:foo
> Connected...Now creating a statement
> 
> Running tests:
> Test 0 - postgres,european failed, returned 08-01-1998
> Test 1 - postgres,us failed, returned 01-08-1998
> Test 2 - iso failed, returned 1998-01-08
> Test 3 - sql,european failed, returned 08/01/1998
> Test 4 - sql,us failed, returned 01/08/1998
> Test 5 - german failed, returned 08.01.1998
> Now closing the connection

Just ran here:

Running tests:
Test 0 - postgres,european passed, returned 08-01-1998
Test 1 - postgres,us passed, returned 01-08-1998
Test 2 - iso passed, returned 1998-01-08
Test 3 - sql,european passed, returned 08/01/1998
Test 4 - sql,us passed, returned 01/08/1998
Test 5 - german passed, returned 08.01.1998
Now closing the connection


> Surprising thing is, that the date appears to be the same,
> so it's beyond me why 
> 	standard.equals(rs.getDate(1)) 
> 
> returns "False".
> 
> Any idea?

Again, are your client & backend on different machines/platforms, and what
platform(s) are you using?

-- 
Peter T Mount  petermount(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk


pgsql-hackers by date

Next:From: Jan WieckDate: 1998-03-17 07:19:24
Subject: Re: [HACKERS] RE: [QUESTIONS] The Complete and Ccomprehensive list of Newbie qu
Previous:From: Peter T MountDate: 1998-03-17 07:10:04
Subject: Re: Problem with JDBC interface in Postgresql-6.3

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