Re: JDBC Maven Checksum

Hi

Possibly answering my own question. Looking at the extracted jar contents the dates are different between the Maven and website versions. E.g.
jar1 - Feb 19 18:44 META-INF/
jar2 - Feb 19 19:49 META-INF/
It would explain the difference in checksum. Are the jars rebuilt before uploading to each site?

Thanks

From: daveshep666(at)hotmail(dot)com
To: stephen(at)eccostudio(dot)com; pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] JDBC Maven Checksum
Date: Sat, 22 Feb 2014 18:15:37 +0000

Hi

Sorry but I am not seeing the same checksums, even with the latest build of driver. I noticed the filename is different for the jars depending on where it comes from, maybe that's the issue? Contents of the jar looks the same after extracting it and doing a directory diff with meld. Apologies if I am doing something stupid, I am new to Maven.

SAH1 From PostgreSQL website
dfa6c29a6c81094260cd903d40475e84c731cbd9 postgresql-9.3-1101.jdbc41.jar
66bb9af92e4b399cb4563a9efe51ea20433ec0a4 postgresql-9.3-1101.jdbc4.jar

SAH1 From Maven
f68c2783393afc9a642035964869417043d2c7dc postgresql-9.3-1101-jdbc41.jar
9da59f12badea19b3b2884161f624bcf6750f985 postgresql-9.3-1101-jdbc4.jar

Date: Fri, 21 Feb 2014 20:37:00 +0000
Subject: Re: [JDBC] JDBC Maven Checksum
From: stephen(at)eccostudio(dot)com
To: pgsql-jdbc(at)postgresql(dot)org

> On Sun, Jan 26, 2014 at 4:22 PM, David Shepherd <daveshep666(at)hotmail(dot)com>

> wrote:

>>

>> Hi

>>

>> Can someone please explain why there is a checksum difference between the

>> JDBC drivers on the PostgreSQL website and those in Maven? I am using Maven

>> for the first time so am unsure which file is correct or why there is a

>> difference.

>>

>> These are the sha1 hashes I am seeing:

>>

>> Maven

>> 7a09dd2b8c01babc07617973fd6f99c007e2b786 postgresql-9.3-1100-jdbc4.jar

>>

>> PostgreSQL website

>> fe6ed26ff71d75ebb99e2ec2123003e05ea16dc5 postgresql-9.3-1100.jdbc4.jar

>>

>> Thank you

>

>

Dave,

When you build the jar for the site which targets do you run?

The Maven upload part of the build script uses the same jar target

that I presume is used for building the website jar. I'll take a look

at it to see what's happening.

I just took a look into this and can't seem to find that jar on the postgresql jdbc website anymore.
So I tried it with the latest 9.3-1101-jdbc41 jar and found them to be exactly the same. I also confirmed from the build script that it is using the same jar file for the website and uploading to Maven. There is a Java version string put into the MANIFEST.MF file but that should be constant across the jars.

If you have the older jar, what I did was extract both of them into separate directories and then perform a recursive diff.