The missing class is from the postgis jar. Are you sure it is on your classpath ?
Dave Cramer www.postgres.rocks On Mon, 25 Sept 2023 at 08:26, Raivo Rebane <raivor...@gmail.com> wrote: > 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 <raivor...@gmail.com> 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 >>>> >>>> >>>> >>>>
