메일링 리스트 webobjects-dev@wocommunity.org 메시지 #292
보낸 사람: Hugi Thordarson <webobjects-dev@wocommunity.org>
제목: Re: [WO-DEV] Postgresql jdbc driver upgrade not recommended
일자: Wed, 27 Oct 2021 08:48:31 +0000
받는 사람: WebObjects & WOnder Development <webobjects-dev@wocommunity.org>
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:
>
> 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
>
>
> <OpenPGP_0x7EF42CC581B85618.asc>

가입 (FEED) 가입 (DIGEST) 가입 (INDEX) 탈퇴 Listmaster에게 메일 보내기