X-CGP-ClamAV-Result: CLEAN
X-VirusScanner: Niversoft's CGPClamav Helper v1.22.2a (ClamAV engine v0.102.2)
From: "Hugi Thordarson" <webobjects-dev@wocommunity.org>
Received: from mail-03.1984.is ([93.95.224.70] verified)
  by post.selbstdenker.com (CommuniGate Pro SMTP 6.3.7)
  with ESMTPS id 26696985 for webobjects-dev@wocommunity.org; Wed, 27 Oct 2021 10:48:53 +0200
Received-SPF: none
 receiver=post.selbstdenker.com; client-ip=93.95.224.70; envelope-from=hugi@karlmenn.is
Received: from localhost
	by mail-03.1984.is with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <hugi@karlmenn.is>)
	id 1mfebn-0007Ss-Be
	for webobjects-dev@wocommunity.org; Wed, 27 Oct 2021 08:48:31 +0000
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.20.0.1.32\))
Subject: Re: [WO-DEV] Postgresql jdbc driver upgrade not recommended
Date: Wed, 27 Oct 2021 08:48:31 +0000
References: <list-26696087@post.selbstdenker.com>
To: WebObjects & WOnder Development <webobjects-dev@wocommunity.org>
In-Reply-To: <list-26696087@post.selbstdenker.com>
Message-Id: <FBEF9CEF-B887-4669-8854-BBAABBEA60EC@karlmenn.is>
X-Mailer: Apple Mail (2.3693.20.0.1.32)

Hi Tim,
out of curiosity, what's the data type of the number that's getting =
truncated? (both the DB and java/model side)

- hugi


> On 27 Oct 2021, at 04:53, D Tim Cummings =
<webobjects-dev@wocommunity.org> wrote:
>=20
> 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.
>=20
> For example
>=20
> 150000 became 15
>=20
> This did not affect numbers ending in three zeros
>=20
> 151000 stayed as 151000
>=20
> 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.
>=20
> 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
>=20
> <dependency>
>     <groupId>org.postgresql</groupId>
>     <artifactId>postgresql</artifactId>
>     <version>42.2.23</version>
> </dependency>
>=20
> Hope this helps
>=20
> Tim
>=20
>=20
> <OpenPGP_0x7EF42CC581B85618.asc>