Mailing List webobjects-dev@wocommunity.org Message #291
From: Matthew Ness <webobjects-dev@wocommunity.org>
Subject: Re: [WO-DEV] Postgresql jdbc driver upgrade not recommended
Date: Wed, 27 Oct 2021 16:17:23 +1100
To: wo-dev <webobjects-dev@wocommunity.org>
Hi Tim,

Please report back any further findings. This sounds like something that would be picked up in tests pretty quickly so i'm very interested in the cause.

Regards,

--
Matt
https://logicsquad.net
https://www.linkedin.com/company/logic-squad/


On Wed, Oct 27, 2021, at 3:53 PM, D Tim Cummings wrote:
> I just upgraded my postgresql jdbc driver from 42.2.23 to 42.3.0 and
> suddenly any number returned from the database that ended in four zeros
> was having the zeros trimmed.
>
> For example
>
> 150000 became 15
>
> This did not affect numbers ending in three zeros
>
> 151000 stayed as 151000
>
> I am still looking for the cause but rolling back to 42.2.23 fixed the
> problem. Problem was reproducible on Postgresql 10.18 on Ubuntu and
> Postgresql 13.3 on Mac.
>
> I am using Wonder 7.2 with Postgresql plugin. My project is defined
> using the maven structure. I was using the postgresql jdbc driver in my
> pom.xml with
>
> <dependency>
>      <groupId>org.postgresql</groupId>
>      <artifactId>postgresql</artifactId>
>      <version>42.2.23</version>
> </dependency>
>
> Hope this helps
>
> Tim
>
>
>
> Attachments:
> * OpenPGP_0x7EF42CC581B85618.asc
> * OpenPGP_signature
Subscribe (FEED) Subscribe (DIGEST) Subscribe (INDEX) Unsubscribe Mail to Listmaster