Re: Right version of jdbc

[Raivo Rebane <raivore55@xxxxxxxxx>]

Hi,

now I using following -

[INFO] Copying postgis-jdbc-2.1.7.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar
[INFO] Copying postgresql-42.6.0.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar
[INFO] Copying checker-qual-3.31.0.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\checker-qual-3.31.0.jar

but on executions I got -

Exception in thread "main" java.lang.NoClassDefFoundError: org/postgis/PGgeometry
        at backendproject.ProcQueryMushrooms.ProcQuery(ProcQueryMushrooms.java:41)
        at backendproject.BackendMain.main(BackendMain.java:81)
Caused by: java.lang.ClassNotFoundException: org.postgis.PGgeometry
        at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
        at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
        at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)

What I have to do ?

I use following -

PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

Regards

Raivo

On Mon, Sep 25, 2023 at 2:29 PM Dave Cramer <davecramer@postgres.rocks> wrote:

Sorry 42.6.0

Interesting that github still has 42.5.4 as the release

Dave Cramer

www.postgres.rocks

On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks> wrote:

Hi,

The latest version of the driver is usually the right answer. So 42.5.4

Dave Cramer

www.postgres.rocks

On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@xxxxxxxxx> wrote:

Hi,

I use :

  PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit

and

PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

What versions of jdbc driver I have to use for proper work ?

Regards,

Raivo