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

Re: neooffice form problem with numerics

From: "Reuben Cummings" <reubano(at)gmail(dot)com>
To: "Kris Jurka" <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: neooffice form problem with numerics
Date: 2008-11-23 02:11:42
Message-ID: 68bad9530811221811j301eb3adgcb4be0a9362b1884@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks!!! Worked like a charm!! I was banging my head for days trying
to figure it out.

Reuben

On Sat, Nov 22, 2008 at 8:21 PM, Kris Jurka <books(at)ejurka(dot)com> wrote:
>
>
> On Sat, 22 Nov 2008, Reuben Cummings wrote:
>
>> Hi, I am trying to use a neooffice form to insert numerical values
>> into a postgres database and get the following error:
>>
>> ESTERROR:  42804: column "back_load" is of type numeric but expression
>> is of type character varying at character 35
>
> Neooffice is apparently calling setString for the numeric parameter.  The
> driver assumes this means it is really a string type and the backend gets
> the type mismatch error.  Neooffice should really be calling setBigDecimal
> for a numeric expression, but you can work around this by providing the
> driver with an instruction to avoid specifying a type for values provided by
> setString.  Use the URL parameter "stringtype=unspecified" when connecting
> to the database and that should hopefully work.
>
> Kris Jurka
>

In response to

pgsql-jdbc by date

Next:From: Ronald VyhmeisterDate: 2008-11-25 21:26:57
Subject: Problem with accessing Russian UTF database
Previous:From: Kris JurkaDate: 2008-11-23 01:21:48
Subject: Re: neooffice form problem with numerics

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