From: "Theodore Petrosky" <webobjects-dev@wocommunity.org>
Received-SPF: pass
 receiver=post.selbstdenker.com; client-ip=66.163.186.147; envelope-from=tedpet5@yahoo.com
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.13\))
Subject: Re: [WO-DEV] Postgresql jdbc driver upgrade not recommended
Date: Sat, 30 Oct 2021 12:41:26 -0400
References: <list-26709431@post.selbstdenker.com>
To: WebObjects <webobjects-dev@wocommunity.org>
In-Reply-To: <list-26709431@post.selbstdenker.com>
Message-Id: <E916B81F-B5B6-4115-8613-EDFB281DFA81@yahoo.com>
Content-Length: 4361

Well, I can confirm the same issue with jdbc postgresql-42.2.23.jar.    =
wonder 7.2

Ted

> On Oct 29, 2021, at 6:00 AM, D Tim Cummings =
<webobjects-dev@wocommunity.org> wrote:
>=20
> I have built a small app which demonstrates this behaviour.
>=20
> https://github.com/timcu/wopg4230
>=20
> It is a very simple app with a database with one table with one record =
with one field (other than the primary key). The app has one WOComponent =
with one form with one text field and one save button.
>=20
> It is a maven app but that makes it easy to swap between jdbc driver =
versions.
>=20
> I would be interested if other people see the same behaviour. You will =
need to set up a postgresql database but I have put instructions on the =
github README.md on how to do that.
>=20
> Tim
>=20
> On 27/10/21 20:06, D Tim Cummings wrote:
>> Postgresql data type : Numeric(38,4) allows null
>>=20
>> Java data type: BigDecimal
>>=20
>> EOModel using prototype: currencyAmount
>>=20
>> When number is first retrieved from database it has precision 10 =
scale 4 eg 150000.0000
>>=20
>> I click the edit button which puts the number in a textfield which =
has numberformat "$#,##0; ($#,##0)" and it displays as $150,000
>>=20
>> I click save button. Number in EO is now 150000 with precision 6 and =
scale 0
>>=20
>> I run ec().saveChanges() where ec() is my editingContext.
>>=20
>> Number in EO is still 150000 with precision 6 and scale 0
>>=20
>> I repeat the procedure "edit / save" several times and randomly the =
number in EO eventually becomes 15 with precision 2 and scale 0. If it =
happens before the saveChanges() then the new number gets saved to the =
database. However it can happen after the save in which case my app sees =
the small number but it doesn't get saved to database if I shutdown the =
app at that point and start it up again.
>>=20
>> It looks like a problem with my app except that it only started =
happening with the new JDBC driver and reverting the JDBC driver removes =
the problem.
>>=20
>>=20
>> Tim
>>=20
>>=20
>> On 27/10/21 18:48, Hugi Thordarson wrote:
>>> Hi Tim,
>>> out of curiosity, what's the data type of the number that's getting =
truncated? (both the DB and java/model side)
>>>=20
>>> - hugi
>>>=20
>>>=20
>>>> 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>
>>>=20
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>>    the mailing list <webobjects-dev@wocommunity.org>.
>>> To unsubscribe, E-mail to: <webobjects-dev-off@wocommunity.org>
>>> To switch to the DIGEST mode, E-mail to =
<webobjects-dev-digest@wocommunity.org>
>>> To switch to the INDEX mode, E-mail to =
<webobjects-dev-index@wocommunity.org>
>>> Send administrative queries to =
<webobjects-dev-request@wocommunity.org>
>>>=20
>>=20
>> #############################################################
>> This message is sent to you because you are subscribed to
>>  the mailing list <webobjects-dev@wocommunity.org>.
>> To unsubscribe, E-mail to: <webobjects-dev-off@wocommunity.org>
>> To switch to the DIGEST mode, E-mail to =
<webobjects-dev-digest@wocommunity.org>
>> To switch to the INDEX mode, E-mail to =
<webobjects-dev-index@wocommunity.org>
>> Send administrative queries to =
<webobjects-dev-request@wocommunity.org>
>>=20
> <OpenPGP_0x7EF42CC581B85618.asc>