Re: text type handling - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: text type handling
Date
Msg-id Pine.BSO.4.64.0812031447380.4061@leary.csoft.net
Whole thread Raw
In response to Re: text type handling  ("Ken Boss" <Ken.Boss@dnr.state.mn.us>)
Responses Re: text type handling
List pgsql-jdbc

On Wed, 3 Dec 2008, Ken Boss wrote:

> Thanks much for your response, Kris.  I have been able to make things
> work for my purposes by applying the patch suggested by Daniel Migowski
> in the thread referenced below.  I tried to implement your suggestion as
> well, but know only enough to be dangerous.  Returning Integer.MAX_VALUE
> from the Oid..TEXT case in the getPrecision method of TypeInfoCache.java
> had no discernible effect - I must have been coding in the wrong place.
> At any rate, I will look forward to that fix in the next release.
>

That's basically what I had in mind, but for a couple more types as well
(see the attached patch).  If this doesn't work we need to know that so we
can come up with something else, so your testing is appreciated.  Can you
be more clear about what Crystal Reports does when it gets confused?  Is
it possible that CR is trying to calculate a total row size in an integer
value and overflows when it sees Integer.MAX_VALUE?  If so, returning some
other large, but not huge value might work.

Kris Jurka

Attachment

pgsql-jdbc by date:

Previous
From: "Ken Boss"
Date:
Subject: Re: text type handling
Next
From: Kris Jurka
Date:
Subject: Re: text type handling