Re: [JDBC] Postgis example TestAutoregister is not working due tomissing getVersion() from pgjdbc community jar - Mailing list pgsql-jdbc

On Fri, Aug 4, 2017 at 9:51 AM, Dave Cramer <pg@fastcrypt.com> wrote:
> What do you need getVersion() for ?
https://mvnrepository.com/artifact/net.postgis/postgis-jdbc/2.1.7.2

On the above link if we extract postgis-jdbc-2.1.7.2.jar and this
contain example TestAutoregister and getVersion is part of it.


>
> Note there are:
>
> @Override
> public int getMajorVersion() {
>   return org.postgresql.util.DriverInfo.MAJOR_VERSION;
> }
>
> @Override
> public int getMinorVersion() {
>   return org.postgresql.util.DriverInfo.MINOR_VERSION;
> }
>
>
>
> Dave Cramer
>
> davec@postgresintl.com
> www.postgresintl.com
>
> On 3 August 2017 at 21:44, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:
>>
>> Hi pgsql-jdbc community!
>>
>> Steps of EDB PostgreSQL9.6  installers download from EnterpriseDB website.
>>
>> ------
>> 1. Install JDK 7 on Linux 32 and Linux 64 and on mac install JDK 8
>> 2. Install pgjdbc and postgis from (PostgreSQL) StackBuilder
>> 3. Performs below commands from terminal:
>>
>> For Linux:
>> ------------
>> export JAVA_HOME=/usr/local/jdk1.7.0_51/bin/java
>> export PATH=/usr/local/jdk1.7.0_51/bin:$PATH
>> export
>>
CLASSPATH=.:/opt/PostgreSQL/pgJDBC/postgresql-42.1.3.jre6.jar:/opt/PostgreSQL/9.6/PostGIS/java/jdbc/postgis-jdbc-2.1.7.2.jar:$CLASSPATH
>> export
>>
CLASSPATH=.:/opt/PostgreSQL/pgJDBC/postgresql-42.1.3.jre7.jar:/opt/PostgreSQL/9.6/PostGIS/java/jdbc/postgis-jdbc-2.1.7.2.jar:$CLASSPATH
>>
>> For MAC:
>> ----------
>> export JAVA_HOME="/Library/Internet\
>> Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java"
>> export PATH="/Library/Internet\
>> Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/":$PATH
>> export
>>
CLASSPATH=.:/Library/PostgreSQL/pgJDBC/postgresql-42.1.3.jar:/Library/PostgreSQL/9.6/PostGIS/java/jdbc/postgis-jdbc-2.1.7.2.jar:$CLASSPATH
>> export
>>
CLASSPATH=.:/Library/PostgreSQL/pgJDBC/postgresql-42.1.3.jre6.jar:/Library/PostgreSQL/9.6/PostGIS/java/jdbc/postgis-jdbc-2.1.7.2.jar:$CLASSPATH
>> export
>>
CLASSPATH=.:/Library/PostgreSQL/pgJDBC/postgresql-42.1.3.jre7.jar:/Library/PostgreSQL/9.6/PostGIS/java/jdbc/postgis-jdbc-2.1.7.2.jar:$CLASSPATH
>>
>> 4. Connect psql with postgres database.
>>
>> 5. <PG_HOME>/bin/psql -d postgres -p 5432
>>
>> 6. Create Postgis Extensions.
>>
>> CREATE EXTENSION Postgis;
>> CREATE EXTENSION Postgis_topology;
>> CREATE EXTENSION fuzzystrmatch;
>> CREATE EXTENSION Postgis_tiger_geocoder;
>>
>> 7. Verify installed postgis extensions version through psql commands.
>>
>> SELECT postgis_version();
>> SELECT postgis_full_version();
>> SELECT postgis_lib_build_date();
>> SELECT postgis_scripts_installed();
>>
>> 8. extract postgis-jdbc-2.1.7.2.jar file through jar xf
>> 9. Now execute the example files and execute following query:
>>
>> java examples/TestAutoregister
>> jdbc:postgresql://localhost:5432/postgres postgres postgres
>>
>> Expected Result:
>> ----------------
>> Postgis jar Example executed successfully.
>>
>> Output:
>>
>> java examples/TestAutoregister
>> jdbc:postgresql://localhost:5432/postgres postgres postgres
>> Testing proper auto-registration
>> Driver version: PostgreSQL 9.4 JDBC4.1 (build 1206)
>> Creating JDBC connection to jdbc:postgresql://localhost:5432/postgres
>> PostGIS Version: 2
>> PGgeometry successful!
>> Box3d successful!
>> Box2d successful!
>> Finished.
>> TestAutoregister.java finished without errors.
>>
>> Actual Result:
>> --------------
>> java examples/TestAutoregister
>> jdbc:postgresql://localhost:5432/postgres postgres postgres
>> Testing proper auto-registration
>> Exception in thread "main" java.lang.NoSuchMethodError:
>> org.postgresql.Driver.getVersion()Ljava/lang/String;
>> at examples.TestAutoregister.main(TestAutoregister.java:64)
>> ------------
>>
>> After complete investigation, I observed that getVersion information
>> has been removed under community 42.jdbc.jar file however in
>> postgis-jdbc-2.1.7.2.jar, we are still using getVersion.
>>
>> We(EDB PostgreSQL team) released last postgis-pg96-2.3.2-1 version on
>> 15-Feb-2017 while community jdbc team removed getVersion from JDBC jar
>> file from PostgreSQL JDBC Driver 42.0.0 version on
>> 19-Feb-2017.(https://jdbc.postgresql.org/)
>>
>>
>> Please note that we are shipping pgjdbc driver from
>> https://jdbc.postgresql.org/download.html while postgis jdbc jar under
>> this location:
>> https://mvnrepository.com/artifact/net.postgis/postgis-jdbc/2.1.7.2
>>
>> Please note that on 9.4.1212 version getVersion information is
>> available but not available on 42.jdbc.jar file
>>
>> Kindly let us know if we are planning to fix that issue or not and we
>> will modify our postgis accordingly?
>>
>> Kind Regards,
>> --
>> Fahar Abbas
>> QMG
>> EnterpriseDB Corporation
>>
>>
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>



--
Fahar Abbas
QMG
EnterpriseDB Corporation