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

Re: int4/int8 problem with jdbc was Re: "Fix" for INT8 literals

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: Jan Heise <jan(at)janheise(dot)de>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: int4/int8 problem with jdbc was Re: "Fix" for INT8 literals
Date: 2004-06-02 13:27:21
Message-ID: 20040602142721.A432@bacon (view raw or flat)
Thread:
Lists: pgsql-jdbc
On 02/06/2004 12:47 Jan Heise wrote:
> oliver, thanks for your reply.
> 
> the db in question is a 7.4 site in production. upgrading to another 
> version is not really what i'd like
> to do. the explicit cast is problematic too, i'm using hibernate as my 
> orm. unless i missed something
> in the docs, i can not add the cast to the config - but this is sth. for 
> the hibernate forums.
> 
> the problem is a special case where i have to load objects from the 
> table in question by the pk
> (details would be quite long, but i can not change the table-structure 
> at this time). table size is
> approx. 120 million rows and approx 2 million rows have a pk < INT4_MAX. 
> so i think my only
> option is dropping the foreign keys, making the pks and all references 
> bigger than INT4_MAX
> and recreate the fk.
> 
> jan

There's an unofficial patch:

http://archives.postgresql.org/pgsql-jdbc/2003-09/msg00143.php

which might solve your problems for now. IIRC, there's a server-side patch 
been submitted which will solve the int4/int8 issue and may be 7.5.

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for 
Business             |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

In response to

Responses

pgsql-jdbc by date

Next:From: Manuel SugawaraDate: 2004-06-02 16:14:33
Subject: Column quoting in result set getters
Previous:From: Jan HeiseDate: 2004-06-02 11:47:24
Subject: Re: int4/int8 problem with jdbc was Re: "Fix" for INT8 literals

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