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

We can not execute TestAutoregister due to missing getVersion under
jdbc.jar file.

On Fri, Aug 4, 2017 at 10:01 AM, Fahar Abbas
<fahar.abbas@enterprisedb.com> wrote:
> 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



--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com